How-To Geek

How to Set the Default Font and Font Size for New Workbooks in Excel


Excel uses the very nice Calibri font by default in Windows, but if you’d like to use a different font or change the default size, you can easily adjust the setting in the Excel options screen.

Start by clicking the “File” tab.


On the backstage screen, click “Options” in the list of items on the left.


Make sure the General screen is active. Then, select the font you want as the default from the “Use this as the default font” drop-down list.


To select a different font size as the default size, select a size from the “Font size” drop-down list.


Click “OK” to accept the changes and close the Excel Options dialog box.


You must exit Excel and restart it for the changes to take effect. Click “OK” on the following dialog box that displays and then close and reopen Excel.


Now, you’ll see your chosen font and size as the defaults for all cells on all worksheets in any new workbooks you create in Excel.


You can always change the font using the Home tab on the ribbon as well, but it’s only for the selected cells on the current worksheet.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 10/19/16

More Articles You Might Like