Microsoft Office Tutorials and References
In Depth Information
Searching a Spreadsheet
Searching a Spreadsheet
Rather than search for a specific cell, you may want to search for a particular
label or number in a spreadsheet. Excel lets you search for the following:
Specific text or numbers
All cells that contain formulas
All cells that contain conditional formatting
Searching for text
You can search for a specific label or number anywhere in your spreadsheet.
To search for text or numbers, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group.
A pull-down menu appears.
3. Click Find.
The Find and Replace dialog box appears, as shown in Figure 8-14.
If you click the Replace tab, you can define the text or number to find
and new text or numbers to replace it.
4. Click in the Find What text box and type the text or number you want
to find.
Figure 8-14:
The Find
and Replace
dialog box
lets you
search your
Search JabSto ::

Custom Search