G
G.Allen
Is there a way to search multiple Excel Sheets (same workbook), other than clicking on each sheet and using the Find feature? Thank you, in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jason Morin
With XL2000 and higher, you can select multiple sheets by
holding down the Ctrl key and then do Edit > Find. Or
select all sheets by clicking the first sheet, hold down
the SHIFT key, and click the last sheet.
HTH
Jason
Atlanta, GA
Find feature? Thank you, in advance.
holding down the Ctrl key and then do Edit > Find. Or
select all sheets by clicking the first sheet, hold down
the SHIFT key, and click the last sheet.
HTH
Jason
Atlanta, GA
workbook), other than clicking on each sheet and using the-----Original Message-----
Is there a way to search multiple Excel Sheets (same
Find feature? Thank you, in advance.
G
G.Allen
Thank you are a lifesaver!
D
Dave Peterson
You may want to try Jan Karel Pieterse's FlexFind:
http://www.bmsltd.co.uk/MVP
or
http://www.bmsltd.ie/MVP/
You can search the whole workbook. And just click on one of the listed
addresses and off you go to that cell!
(xl2002 and above have similar capability builtin.)
http://www.bmsltd.co.uk/MVP
or
http://www.bmsltd.ie/MVP/
You can search the whole workbook. And just click on one of the listed
addresses and off you go to that cell!
(xl2002 and above have similar capability builtin.)