Datasheet

NOTE
If you use the Choose Format from Cell option in Step 4, you may find that not all occur-
rences of the formatting are replaced — usually because one or more aspects of the for-
matting do not match. For example, if you click on a cell that has General number
formatting, it doesn’t replace cells that have Date number formatting. The solution is to
click the Format button to display the Find Format dialog box and then click the Clear
button in each dialog box tab in which the formatting is not relevant.
In some cases, you may prefer to simply select the cells with a particular format. To do so,
perform Steps 1 through 4 in the preceding step list. Then click the Find All button. The
dialog box expands to display information about the qualifying cells (see Figure 20-2).
Click on the bottom part of the dialog box, and then press Ctrl+A to select all qualifying
cells.
Figure 20-2: The Find and Replace dialog box expands to display a list of all matching cells.
When these cells are selected, you can then format them any way you like. Note that you
can widen the columns in the list of found cells (by dragging a column border), and you can
also sort the list by clicking a column header.
NOTE
Conspicuously absent from the Find and Replace dialog box is the ability to search for cells
by their styles. Despite the fact that Excel 2007 places increased emphasis on cell styles,
it’s not possible to find all cells that use a particular style and apply a different style to
those cells. You can find and replace the formatting, but the cell style does not change.
Tip 20: Replacing Formatting
54
04_137666 ch01.qxp 5/22/07 7:31 PM Page 54