Search Entire Workbook

[Sloth]

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?

[Joy]

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?