Microsoft Office Tutorials and References
In Depth Information
Using Find and Replace
6. To set options, click the Options button and
make your selections:
Perform one of the following:
Click Find Next to highlight the first cell
that matches your criteria. The cursor
moves to the first matching cell. If you
want, you can continue searching to the
next matching cell by clicking Find Next
To search for data that uses a particular
format, click the Format button next to
the Find What list, select the format to
search for (such as Currency format),
and click OK to return to the dialog box.
You can select a cell that contains the
formats to find by clicking the Choose
Format From Cell button in the Find
Format dialog box and clicking a cell.
Click Find All (to display a list of all
matching cells). A list of matching cells
appears at the bottom of the Find and
Replace dialog box. Drag a corner of the
dialog box to make it wider and longer in
order to make the list easier to use. Select
a cell in the list to move the cursor to that
To replace data and apply a particular
format, click the Format button next to
the Replace With list, and follow the
process described previously for
selecting formats.
Once a cell is highlighted, click Replace
to replace the matching data with the
replacement data you entered in Step 5.
Normally, Excel searches only within the
current worksheet. To search within the
entire workbook, select Workbook from
the Within list.
To replace all matching cells without
highlighting each one first, click Replace
In order to decrease the time in which it
takes Excel to locate the data you’re
searching for, you might want to
indicate the direction in which you want
Excel to search the sheet. Just open the
Search list and select either By Rows or
By Columns.
8. When you’re through searching and replacing,
click Close.
Normally, Excel searches formulas and
the cells to which they refer. To search
data or comments only, open the Look
In list and select Values or Comments.
To match text by exact upper- and
lowercase, select the Match Case checkbox.
To find cells that contain only the
contents you are searching for, select the
Match Entire Cell Contents checkbox.
Search JabSto ::

Custom Search