How To Set Default Font In Excel

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

Changing the Default Font

David wonders how he tin change the default font for Excel when he opens a new workbook. Setting the default font that you want Excel to utilize is actually quite easy. All you need to do is follow these steps:

1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and later versions display 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. (See Figure one.)



Figure 1. The General options of the Excel Options dialog box.

3. Change the Utilize this Font drop-downwards list (Excel 2007 and Excel 2010) or the Apply This Every bit the Default Font drop-downwardly list (Excel 2022 and Excel 2022) and so that it reflects the font you want used.
4. If desired, utilise the Font Size drop-down list to pick the size of font you want Excel to utilise.
5. Click OK.
6. Restart Excel.

Now every fourth dimension you lot create a new workbook, Excel will utilise these settings as the default. The only times it won't is if you base a new workbook on a template or shop a template named Book.xltx or Book.xltm in the XLStart folder. (In this second case, you've overridden how Excel formats a new workbook by whatsoever is set within the Book.xltx or Book.xltm template file.)

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

ExcelTips is your source for price-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 hither: Irresolute the Default Font.

Author Bio

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

MORE FROM ALLEN

Locking Worksheet Names

Want to finish other people from irresolute the names of your worksheets? You tin can provide the desired safeguard past using the ...

Observe More than

Understanding Default Tab Stops

Ever wonder how Word determines the default setting for each tab stop in your document? This article should satisfy any ...

Notice More than

Calculation an Inverted A

Want to insert an upside-downward alphabetic character in your text? This tip provides a number of different approaches you can utilise to get ...

Discover More

More ExcelTips (ribbon)

Saving Non-Existent Changes

Open a workbook, look at the data, kickoff to shut the workbook, and y'all are asked if you want to save your changes. What ...

Discover More

Immigration Large Clipboard Entries

Need to clear out a big amount of data saved on the Clipboard? All you lot need to practice is to supervene upon information technology with a small ...

Notice More

Disabling the F1 Primal

Tired of hitting the F1 key past mistake and pulling up the Help organisation? Here are a couple of means (one drastic and 1 not ...

Discover More

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

Share this post