Jun 27, 2010

My Digital Life Editorial Team

1 Comment

Delicious

How to Set or Change the Default Font in Excel 2010

Microsoft Office Excel 2010 uses Calibri font in font size 11 as the default body font when typing data in a worksheet, header or footer, or text box. Excel users may want to enter text in another font type or font size that will be used or applied by default when entering text for all new workbooks created.

Here’s how to change and set the default font type and font size style in Excel 2010:

1. Run Office Excel 2010.
2. Click on File tab.
3. Click Options.

   

4. In the General category, under When creating new workbooks section, select the font to use in the Use this font drop down box.

   

   Optionally, select a preferred font size for the font type in the Font Size box.

5. Click on OK button.
6. Click OK again when prompted with “for your change to the standard font to take effect, you must quit and then restart Microsoft Excel” dialog box.

   

7. Close all Excel windows and restart Excel 2010, and the new default font and font size will be applied to new workbooks created.

Tip: The new default font and font size are used only in new workbooks that are been created after restarting Excel; existing workbooks are not affected.

Related posts:

1. How to Save Excel 2010 or 2007 Workbook as .XLS By Default (from .XLSX)
2. Switch and Change Back to Office 2003 Default Font and Style Set in Office Word 2007
3. Change Office 2007 Default File Save Formats and Extensions using Group Policy (GPO)
4. Download ING Change Font to Personalize your Windows Mobile Device
5. How to Save As PPT (PowerPoint 97 – 2003) File Type By Default in Office 2007 or 2010