Default Search Options

[Idaho Word Man]

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

 

[Brad]

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

"

 

[Zack Barresse]

Hi,

Overall, sounds like a job for Access. But if your boss is hell-bent on
sticking with Excel, you could always do this recording a macro and add a
variable through some input box (or the sorts) that way. I'm not sure if
there is a way besides that, as the Search retains the last used settings.