Excel 2019 Bible

Chapter 19: Making Your Formulas Error-Free

19

Format button Click to search for cells that have a particular formatting. (See the upcom-

ing “Searching for formatting” section.)

Click Find Next to locate the matching cells one at a time or click Find All to locate all

matches. If you use the Find All button, the Find and Replace dialog box expands to display

the addresses of all matching cells in a list. When you select an entry in this list, Excel

scrolls the worksheet so that you can view it in context.

After using Find All, press Ctrl+A to select all the found cells in the worksheet.

Because the Find and Replace dialog box is modeless, you can access the worksheet and make changes without the

need to dismiss the dialog box.

Replacing information

To replace text with other text, use the Replace tab in the Find and Replace dialog box.

Enter the text to be replaced in the Find What field and then enter the new text in the

Replace With field. Specify other options as described in the previous section.

Click Find Next to locate the first matching item and then click Replace to do the replace-

ment. When you click the Replace button, Excel locates the next matching item. To override

the replacement, click Find Next. To replace all items without verification, click Replace All.

If the replacement didn’t occur as you planned, you can use the Undo button on the Quick

Access toolbar (or press Ctrl+Z).

To delete information, enter the text to be deleted in the Find What field, but leave the Replace With field empty.

Searching for formatting

From the Find and Replace dialog box, you can also locate cells that contain a particular

type of formatting. As an option, you can replace that formatting with another type of

formatting. For example, assume that you want to locate all cells that are formatted as bold

and then change that formatting to bold and italic. Follow these steps:

1. Choose Home ➪ Editing ➪ Find & Select ➪ Replace or press Ctrl+H. The Find and
   Replace dialog box appears.


2. Make sure that the Replace tab is displayed. If necessary, click the Options but-
   ton to expand the dialog box.


3. If the Find What and Replace With fields are not empty, delete their contents.