Fred, this may be a bit less than what you need, but one thing you should
try to see if it fits your needs is to click on a worksheet tab, right click
it, then select the "Select all Sheets" choice. This will highlight all of
the sheets in your workbook, then do the Control F routine to pull up a
specific job number.

Cheers and good luck! Brad

"
"Idaho Word Man" wrote in message
...
I'm very unfamiliar with Excel, so navigating within it is a struggle for
me.
My boss has created a job tracking system in Excel, with multiple tabs
across the bottom, one for each worker in our group. Several times a day
I
need to find out who is working on a particular job, so I open the
tracking
system and use Ctrl-F to search for the job number.

Is there a way I can reset the default search options when I do this?
Every
time I use Ctrl-F, it comes up searching within the individual sheet, by
formulas. Of course I can't find anything that way, so I need to reset it
every time to search within the workbook by values. Is there a way I can
reset the search options once and for all, so it just comes up looking for
what I want? That would be a whole lot less aggravating than needing to
reset
them 20 times a day.

Thanks,

Fred