If you need to search for something within your excel spreadsheet, you don't need to search sheet by sheet. When you CTRL F to bring up Find and Replace, click on Options, then click on the dropdown menu for Within and change it from Sheet to Workbook. It will now search your entire workbook for you and list all of the places your searched item can be found.
Hectic Helpers is Blogging your To Do ListTip of the Week - Excel TipPosted in 'Tips' on June 29, 2010
0 Comments [+] | Entry Link |
Get notified [+]
SearchPrevious Posts
Archives2009 [+]2008 [+]Sites worth visiting
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||

0 Comments 
Get notified