bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Formatting > Cell Formatting > Changing the Default Font

Changing the Default Font

Summary: Using the Options menu to change the default font in Excel. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Every time you create a new spreadsheet, Excel uses a default font setting to determine how your text appears. While you can easily change fonts as you go, you may find it even easier to change your default font to the one you use most often. To do this, follow these steps:

  1. Choose Options from the Tools menu. This displays the Options dialog box.
  2. Make sure the General tab is selected. (Click here to see a related figure.)
  3. Use the Standard Font drop-down list to choose the font you want Excel to use by default.
  4. Modify the Size setting if you want the font a different size.
  5. Click on OK to save your changes. Excel informs you that you must exit and restart Excel for your changes to take effect.
  6. Click on OK to close the dialog box.

You have now changed the default font. As instructed by Excel, you should exit the program and restart. Your changes will then be in effect for any new spreadsheets you create.

Tip #2667 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.
 
Check out ExcelTips: The Macros today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)