Search Entire Workbook
 

I am trying to search for specific string throughout an entire workbook. I
have multiple (50+) worksheets in my file. I want to be able to search the
entire workbook for any cell that contains B836004. Do I need to open and
search each sheet at a time, or is there a quicker way?

Another way would be to go to Edit/Find and under "Within" select Workbook

"Sloth" wrote:

Nevermind. I feel stupid now. Just select all the spreadsheets you want to
search for. I tried this, but I forgot the B was part of the custom format,
in order to keep the cell a number.

"Sloth" wrote:

I am trying to search for specific string throughout an entire workbook. I
have multiple (50+) worksheets in my file. I want to be able to search the
entire workbook for any cell that contains B836004. Do I need to open and
search each sheet at a time, or is there a quicker way?