![[Home]](http://malektips2.com/graphics/logo-small.png){kind=logo}
Microsoft Excel 2010
Change the Default Font for New Workbooks
SUMMARY: Tired of every Excel 2010 workbook using 11 point Calibri as the default for cells? Change the default font for all new workbooks.
Just as in other Office 2010 applications, Microsoft Excel 2010 has a default font for new documents - 11 point "Body Text" (Calibri). While you can change the font for individual cells or groups of them, what if you grow tired of every new spreadsheet using this standard font? Maybe you want to use Arial or Verdana, or want cells a little larger so they are easier to read?
1. Select the "File" tab in the Ribbon.
2. The Microsoft Office Backstage View appears. Click the "Options" button.
(Or instead of steps 1 and 2, press Alt + T, then the letter O.)
3. The "Excel Options" dialog box appears. "General" should already be selected in the left pane - if not, do so.
4. Underneath "When creating new workbooks", there are two related options you can change:
* Next to "Use this font", click the pull-down and choose your desired default font. Yes, fonts such as Symbol and Wingdings are available, though strongly discouraged.
* Next to "Font size", click the pull-down and choose a new default font size, or type one directly in the box from 1 to 409 points.
5. Click "OK" on the bottom-right of the dialog box to close it.
6. As prompted, note that you will have to restart Excel 2010 for changes to take effect.
Return to the Microsoft Excel 2010 page.
blog comments powered by Disqus
