If you’re new to Excel, it’s important to set the default font and font size for your workbooks. This will ensure that your workbooks look and feel more professional. To do this, open the File menu and select New Workbook. Then, select the Font tab and enter a name for your new workbook. For example, if you’re working with a Microsoft Office application such as Excel, you might enter “Excel.” Next, select the Font Size tab and enter a size for your new workbook. For example, if you’re working with a Microsoft Office application such as Excel, you might enter “12pt.” Finally, click on the OK button to create your new workbook.
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.
