Using the Find function in Excel

R

Richard Argent

Im having difficulty using the Find function in Excel 97.
I have a spreadsheet with 14 sheets. When i use the Find
function to search for data contained within the
spreadsheet, the Find function only searches the
highlighted. Even if i highlight all sheets, the Find
function only searched the sheet marked in bold (even
though all sheets are highlighted). Searching for a single
piece of data is very time consuming as i am having to do
the Find 14 times (once for each sheet). Is there a way of
searching all individual sheets within a spreadsheet,
without having to do the search for each sheet? If Excel
does provide this function, then is there any add-on
software (free or otherwise) that could perform this Find
function?
 
Top