Microsoft Office Tutorials and References
In Depth Information
Finding and Replacing a Format
Click Edit on the menu bar, and then click Replace.
Click the Options >> button, if necessary, to display the format choices.
Click the top Format list arrow, and then click Format.
Specify the format you want to find in the Find Format dialog box, and then click the
Click the bottom Format list arrow, and then click Format.
Enter the new format, which will replace the old format, and then click the OK button.
Click the Replace All button to replace all occurrences of the old format; click the
Replace button to replace the currently selected cell containing the old format; or click
the Find Next button to find the next occurrence of the old format before replacing it.
Click the Close button.
In the Sales worksheet, the table titles and column titles are displayed in a bold font.
After seeing how the use of color has made the worksheet come alive, Joan wants you to
change the titles to a boldface blue. Rather than selecting the cells that contain the table
and column titles and formatting them, you will replace all occurrences of the boldface
text with blue boldface text.
To find and replace formats:
1. Click Edit on the menu bar, and then click Replace . The Find and Replace dialog box opens.
You can use this dialog box to find and replace the contents of cells. In this case, you will use
it only for finding and replacing formats, leaving the contents of the cells unchanged.
2. Click the Options >> button to display additional find and replace options. See Figure 3-23.
The dialog box expands to display options that allow you to find and replace cell formats. It
also includes options to determine whether to search within the active sheet or the entire
workbook. Currently no format options have been set.
Find and Replace dialog box
previews the selected formatting
click to open
the Find Format
dia l og box
click to display
click to replace
all o ccurrences in
click to find but not
necessarily to replace
click to replace the
next occurrence in
Trouble? If the button on your workbook appears as Options <<, the additional options
are already displayed, and you do not need to click any buttons.
3. Click the top Format button to open the Find Format dialog box. Here is where you specify the
format you want to search for. In this case, you are searching for cells that contain boldface text.