How-To Geek

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

00_lead_image_change_default_font_and_size

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.

02_clicking_file_tab

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

03_clicking_options

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.

04_choosing_default_font

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

05_changing_font_size

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

05a_clicking_ok_excel_options_dialog

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.

06_close_and_restart_dialog

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.

07_default_font_verdana

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

Enter Your Email Here to Get Access for Free:

Go check your email!