1. Home
  2. >>
  3. LATEST
  4. >>
  5. How to set default font and font size for new workbooks in Excel

How to set default font and font size for new workbooks in Excel



How to set default font and font size for new workbooks in Excel


Advertisements

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

Advertisements

Start by clicking on the “File” tab.

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

Advertisements

Make sure the General screen is active. Next, select the font you want to use as the default from the “Use this as the default font” dropdown list.

To select a different font size as the default, select a size from the “Font Size” dropdown list.

  The epic augello

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

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

You’ll now see the font and size you’ve chosen as defaults for all cells in all worksheets in all new workbooks you create in Excel.

You can also change the font using the Home tab on the ribbon, but only for selected cells in the current worksheet.