By default, Microsoft Office Excel 2007 uses the Body Font font in font size 11 (which is displayed as the Calibri font in font size 11 when you type data in a worksheet, header or footer, or text box) but you can change the default font and font size for all new workbooks that you create.
- Click the Microsoft Office Button , and then click Excel Options.
- In the Popular category, under When creating new workbooks, do the following:
- In the Use this font box, click the font that you want to use.
- In the Font Size box, enter the font size that you want to use.
NOTE: To begin using the new default font and font size, you must restart Excel. The new default font and font size are used only in new workbooks that you create after you restart Excel; existing workbooks are not affected. To use the new default font, you can move worksheets from an existing workbook to a new workbook. For more information, see Move or copy a worksheet.
Courtesy of: Microsoft Office Knowledge Base
For Word 2003 and Earlier:
Open the “Options” dialog box. Click on “Tools” on the tool bar and select “Options.” This opens the Options dialog box in which you can change the default attributes of your workbook.
Change the default font. Click the “General” tab and then click the arrow in the “Standard font” field. Select a new font from the list.
Change the font size. Click the “Size” box and select a new font size.
Click “OK” when you have finished making your changes.
You will have to restart Excel in order for the changes to take effect.
This post was inspired by the Nick Burns video with Jackie Chan on “My Spreadsheet has a font?”