Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Default Search Options
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Default Search Options
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Default Search Options
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. -- Regards, Zack Barresse, aka firefytr "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
HDI change paste options default to "Match Destination Formatting | Setting up and Configuration of Excel | |||
Search within workbook | New Users to Excel | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
default chart options | Charts and Charting in Excel |