Microsoft Office Tutorials and References
In Depth Information
Tip 25: Updating Old Fonts
To update the fonts in a workbook that was created in a previous version of Excel, follow these steps:
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 ➜ Merge Styles
The Merge Styles dialog box appears.
4. 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.
5. 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 ➜ Editing ➜ Find & Select ➜ Replace, or press Ctrl+H.
The Find and Replace dialog box appears.
3. Make sure that the two Format buttons are visible. If these buttons aren’t visible, click the
Options button to expand the dialog box.
4. Click the upper Format button to display the Find Format dialog box.
5. Click the Font tab.
6. In the Font list, select the name of the font that you’re replacing (probably Arial, the old
default font) and then click OK to close the Find Format dialog box.
7. Click the lower Format button to display the Replace Format dialog box.
8. Click the Font tab.
9. In the Font list, select the name of the font that will replace the old font (probably Calibri)
and then click OK to close the Replace Format dialog box.
10. In the Find and Replace dialog box, click Replace All to replace the old font with the new