Microsoft Office Tutorials and References
In Depth Information
Finding and replacing stuff
Figure 8-38 Use the Find tab to locate a character string.
Use the options on the Find tab in the following ways:
Find What Type the string of characters you want to find. Be exact. Excel finds
exactly what you type, including spaces—nothing more, nothing less.
Match Case Distinguish capital letters from lowercase letters, finding only
occurrences that match the uppercase and lowercase characters of the Find What string. If
you leave this check box unselected, Excel disregards case.
Match Entire Cell Contents Find only complete and individual occurrences of the
string. Ordinarily, Find searches for any occurrence of a string, even if it is part of
Choose to search only the active worksheet or the entire workbook.
Search Choose to search by rows or by columns. Unless your worksheet is very
large, your search takes place in the blink of an eye, so this option might not be
much faster one way or the other. Finding items in a particular order might be
desirable, however. When you select the By Rows option, Excel looks through the
worksheet horizontally, row by row, starting with the currently selected cell. The By
Columns option searches through the worksheet column by column, beginning with
the selected cell.
Look In Choose formulas, values, or comments. The default is Formulas, which
means all text and numeric entries, regardless of formatting, as well as formulas.
When you select Values, Excel searches text and numeric entries and only the
displayed results of formulas. When you select Comments, Excel examines only the text
attached as a comment to a cell.