how do i search an entire file for numbers in excel?

D

Doug Kanter

terri said:
to search an entire excel file looking for certain numbers
Click to expand...

By "entire file", do you mean you want to search across all sheets in a
workbook, or just one sheet?
 
S

SVC

In Excel 2003, use the following steps:

Edit > Find (or Ctrl + F), in the Find what box enter the number, select the
cell Format, click Options and in Within select Workbook, and check Match
entire cell contents (this will prevent finding a string with the Find what
number). Click either Find all (which produces a list of cells in which the
number appears) or Find next (which will move you from cell to cell with each
click).

Earlier versions of Excel may differ slightly.
 
Top