If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Find" through entire Workbook
How do I use the "Find" function to search through an
entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated. |
#2
|
|||
|
|||
"Find" through entire Workbook
Try this
Right-Click one of the sheets and click "Select All Sheets" on the shortcut menu, then perform your search. If any one of your sheets has more than one cell selected, this method won't work correctly. After selecting all sheets, press Ctrl+A to select all cells on all sheets to force the Find to search them all. If you are using XL97, the "select all sheets" method will not work. You can "Replace" across sheets, but not "Find".(Gord Dibben) In Excel 2002/2003, there is a "Within:" option in the Find/Replace dialog. You may want to try Jan Karel Pieterse's FlexFind at: http://www.bmsltd.co.uk/MVP/Default.htm -- Regards Ron de Bruin http://www.rondebruin.nl "AMMC" wrote in message ... How do I use the "Find" function to search through an entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated. |
#3
|
|||
|
|||
"Find" through entire Workbook
If you select all the sheets first (Click on the first tab, then Shift + Click on the last) then run your find query, it should look through them all.
"AMMC" wrote: How do I use the "Find" function to search through an entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated. |
#4
|
|||
|
|||
"Find" through entire Workbook
p.s. don't forget to go back to a single sheet selection before making
changes - otherwise you're editing them all at once... "Ron de Bruin" wrote in message ... Try this Right-Click one of the sheets and click "Select All Sheets" on the shortcut menu, then perform your search. If any one of your sheets has more than one cell selected, this method won't work correctly. After selecting all sheets, press Ctrl+A to select all cells on all sheets to force the Find to search them all. If you are using XL97, the "select all sheets" method will not work. You can "Replace" across sheets, but not "Find".(Gord Dibben) In Excel 2002/2003, there is a "Within:" option in the Find/Replace dialog. You may want to try Jan Karel Pieterse's FlexFind at: http://www.bmsltd.co.uk/MVP/Default.htm -- Regards Ron de Bruin http://www.rondebruin.nl "AMMC" wrote in message ... How do I use the "Find" function to search through an entire workbook instead of just one sheet in the Workbook?? Any advice would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|