Monday, May 26, 2014

Change the Default Font & Size


By default, Excel uses Calibri font with 11 pt size (10 pt if you use Excel 2003) for any new workbook you create. Of course, you can change the formatting for each book / sheet whenever you like. But your company uses a particular font in all the reports (other than Calibri) and you want that font as your default font? Read on.

This post is useful if you want to change the default font and size so that each time you create a new workbook, your chosen font is the default.

Excel 2010 and later:

File tab > Options > General > When creating new workbooks segment > select font you like in the Use this font drop down. Select size of the font you want as default in the Font size drop down list.

Excel 2007:

Click the Microsoft Office button > Excel Options > Popular tab > When creating new workbooks segment > select font you like in the Use this font drop down. Select size of the font you want as default in the Font size drop down list.

Excel 2003:

Tools menu > Options > General tab > select a font in the Standard font drop down box. In the Size box, type or click a font size.

Points to remember:
  1. You must restart Microsoft Office Excel to begin using the new default font and font size.
  2. The new default font and font size are used only in new workbooks that you create after you restart Excel. Existing workbooks are not affected.