Search

How to change the default font and size in Excel

 

There are many fonts available in Excel. The default font for every new workbook in Windows-based Excel 2019 is "Body Font", with font size 11. Body Font with font size 11 is displayed in Excel worksheet as Calibri font, with font size 11.

Below image shows default font and its size in Excel 2019.

Default font for Excel 2019 is Calibri size 11

Sometimes according to the requirement of a particular project, you may need to change the default font and its size, because every time it is difficult to change the font and its size.

If you want to change the default font in Excel and its size, follow these steps.

Step 1 - Open Excel Options Dialog Box window by clicking "File" on Excel Ribbon and then selecting "Options" from menu from Excel Backstage View.

Default font and size in Excel options dialog box

Step 2 - Select the new default font from "Use this as the default font" and size from "Font size" Drop-down lists. In this example, "Segoe UI" font and font size 12 is selected, as shown below.

Default font and size is changed

After changing the font and font size, click "OK" button in Excel Options Dialog Box window. Excel will display a dialog box for program restart for font change to take effect, as shown below.

Excel Restart dialog box for font change

Step 3 - Once Excel is restarted, you can see that the default font is changed to "Segoe UI" font and font size 12 for a new Excel workbook, as shown in below image. Please note that the font and its size in existing Excel workbooks will not change. The default font and its size is changed only for new blank worksheets or new workbooks.

Default font and size changed

 

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook