If you’re new to Excel, you may be wondering how to set the default font and font size for new workbooks. In this article, we’ll show you how to do just that. To set the default font and font size for new workbooks in Excel, follow these steps:
- Open your new workbook.
- On the Home tab, in the Font group, click the Default Font button ( ).
- In the dialog box that appears, select a font from the list on the left side of the window (or type a custom name in the Font Name text box). Click OK to close the dialog box and set your default font and 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.
