Chapter 11. Working with Data, Formulas, and Functions

Find Data

You can use the Find feature to quickly locate a word, phrase, or number in your worksheet.

You can have Excel search your entire worksheet or only specific cells. To have Excel search only specific cells, you must select the cells before starting the search.

By default, Excel finds the data that you specify, even if it is part of a larger word or number. For example, searching for the number 105 locates cells that contain the numbers 105, 2105, and 1056.

After you start the search, Excel finds and selects the cell containing the first instance of the word or number, which may appear in several locations in your worksheet. You can continue the search to find the next instance of the ...

Get Master Visually®: Microsoft® Office 2007 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.