Buzz
Starting from Office 2007, Office 2016, Office 2019, and Office 2021, both Word and Excel use Calibri as the default font. To make your documents or spreadsheets easier to read, many users want to change the default font style or adjust the font size. In this article, we will show you simple steps to change the default font in Excel 2016.
Default Font in Excel 2016
Mastering Font Settings in Excel 2016
If you haven't installed Office 2016 yet, refer to the following article for guidance.
- Reference: Installing Office 2016 on Your Computer
Step 1: Open any Excel 2016 file, then click on the File menu.
Step 3: Once the Options window appears, click on the General tab.
Notice the pane on the right-hand side, navigate to the When creating new workbooks section, click the dropdown arrow next to Use this as the default font to choose the default font.
Next, select the default font under the Font Size line, then click OK.
Step 4: A prompt will appear requesting to restart Excel, click OK to restart.
After restarting, you'll notice that the font and font size have been set according to your selection.
In subsequent sessions, you won't need to select the font again.
From the 2016 version onwards, when you open Excel, a quick browse screen of available document templates will appear before entering the main editing interface. If you find this feature intrusive, you can disable it by:
- Click on File >>Options >>General and uncheck the box next to Show the Start screen when this application starts, then click OK.
- Also in the Excel Options window, you can set up automatic text saving by:
Click on the Save tab, check the box next to Save AutoRecover information every... minutes, choose the time interval for automatic saving, and press OK.
You can also customize the Excel workspace interface by clicking on the Customize Ribbon tab. Then choose how functions are displayed on the menu bar and tabs in the Choose commands from and Customize the Ribbon sections, click OK to finish.
Here's how to set the default font in Excel 2016. Additionally, there's a handy trick in Excel that frequent users may find useful: creating diagonal lines to divide cells into two triangular sections. This method saves space and enhances visual layout.
- Learn more: How to create diagonal lines in Excel 2016 cells
