Search trhu whole document
 

Hi,
I am trying to find an easy way to search through the whole Excel
document, and not only current wheet (as Ctrl+F does).
Any ideas how to do this?

Cheers!


--
Ekser
------------------------------------------------------------------------
Ekser's Profile: http://www.excelforum.com/member.php...o&userid=11400
View this thread: http://www.excelforum.com/showthread...hreadid=511694

Search trhu whole document
 

Select all sheets (right click on a sheet tab and select "select all
sheets")
Then do a ctrl-f and it will show you all the matches.

Hans

Search trhu whole document
 

Cool, thanks! :cool:


--
Ekser
------------------------------------------------------------------------
Ekser's Profile: http://www.excelforum.com/member.php...o&userid=11400
View this thread: http://www.excelforum.com/showthread...hreadid=511694