 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Default 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 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 " > I'm very unfamiliar with Excel, so navigating within it is a struggle for > me. [quoted text clipped - 18 lines] > > Fred 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.  SignatureRegards, Zack Barresse, aka firefytr > I'm very unfamiliar with Excel, so navigating within it is a struggle for > me. [quoted text clipped - 18 lines] > > Fred |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.