How To Set A Default Font In Excel

Please Note: This commodity is written for users of the following Microsoft Excel versions: 2007, 2010, 2022, and 2022. If you are using an before version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for before versions of Excel, click here: Changing the Default Font.

Changing the Default Font

David wonders how he tin can change the default font for Excel when he opens a new workbook. Setting the default font that yous desire Excel to use is actually quite like shooting fish in a barrel. All you demand to practise is follow these steps:

1. Display the Excel Options dialog box. (In Excel 2007 click the Office button then click Excel Options. In Excel 2010 and afterwards versions brandish the File tab of the ribbon and then click Options.)
2. Make sure Popular (Excel 2007) or General (Excel 2010 and later versions) is clicked at the left side of the screen. (Meet Figure 1.)



Figure 1. The Full general options of the Excel Options dialog box.

3. Change the Use this Font drop-downwardly list (Excel 2007 and Excel 2010) or the Use This As the Default Font drib-down listing (Excel 2022 and Excel 2022) and so that it reflects the font y'all want used.
4. If desired, employ the Font Size drop-downwardly list to pick the size of font you lot want Excel to utilize.
5. Click OK.
6. Restart Excel.

At present every time y'all create a new workbook, Excel will use these settings as the default. The only times it won't is if you base of operations a new workbook on a template or store a template named Volume.xltx or Book.xltm in the XLStart folder. (In this second example, you've overridden how Excel formats a new workbook by whatever is prepare inside the Book.xltx or Volume.xltm template file.)

Also keep in mind that these steps won't change the font in any previously created workbooks; those stay equally they were when you lot saved them.

ExcelTips is your source for toll-effective Microsoft Excel training. This tip (12618) applies to Microsoft Excel 2007, 2010, 2022, and 2022. You can find a version of this tip for the older carte interface of Excel here: Changing the Default Font.

Author Bio

With more than fifty non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services visitor. Learn more about Allen...

MORE FROM ALLEN

Understanding Master and Subdocuments

Most people use Word to create regular documents that you edit, view, and print. The program likewise allows y'all to create a ...

Discover More

Displaying Shortcut Keys in ScreenTips

ScreenTips can appear with or without shortcut keys displayed in them. Here's how to control whether they announced or not.

Discover More

Ensuring Unique Values in a Cavalcade

If you want to make sure that merely unique values are entered in a item cavalcade, you can use the data validation ...

Detect More

More ExcelTips (ribbon)

How Excel Stores Dates and Times

Excel stores dates and times internally using what is called a serial number. This tip explains how that serial number is ...

Discover More

Iterating Circular References

Does your information require that you perform calculations using circular references? If and then, then you lot'll want to exist enlightened of ...

Discover More

Setting the Width for Row Labels

Excel displays, past default, a row label or heading at the left side of each row on the screen. Equally you scroll down the ...

Observe More than

Source: https://excelribbon.tips.net/T012618_Changing_the_Default_Font.html

Share this post