Microsoft Office Tutorials and References
In Depth Information
Updating Old Fonts
Updating Old Fonts
When you install Microsoft Office, several new fonts are added to your system, and these new
fonts are used when you create a new workbook. The exact fonts that are used as defaults vary,
depending on which document theme is in effect.
See Tip 16 for more information about using document themes.
If you use the default Office theme, a newly created Excel workbook uses two new fonts:
Cambria (for headings) and Calibri (for body text). When you open a workbook that was saved
in a version prior to Excel 2007, the old fonts are not updated. The difference in appearance
between a worksheet that uses the old fonts and a worksheet that uses the new fonts is
dramatic. When you compare an Excel 2003 worksheet with an Excel 2010 worksheet, the latter is
much more readable and seems less cramped.
To update the fonts in a workbook that was created in a previous version of Excel, follow these
1. Press Ctrl+N to create a new, blank workbook.
2. Activate the workbook that uses the fonts to be updated.
3. Choose Home
Styles and click the bottom arrow of the scroller on the right side of the
Style Gallery.
4. When the gallery expands, choose Merge Styles.
5. In the Merge Styles dialog box, select the workbook that you created in Step 1 and
click OK.
Excel asks whether you want to merge styles that have the same names.
6. Reply by clicking the Yes button.
This procedure updates the fonts used in all cells except those that have additional formatting,
such as a different font size, bold, italic, colored text, or a shaded background. To change the
font in these cells, follow these steps:
1. Select any single cell.
2. Choose Home
Find & Select
Replace to display the Find and Replace
dialog box.
Or, press Ctrl+H.
Search JabSto ::

Custom Search