Search trhu whole document

E

Ekser

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

Cheers
 
F

flummi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to clear prior search terms from Navigation Pane 0
Prompt For Replace in Selection And More... 0
VBA concatenate ranges into a new document 0
Find/Replace specific indent 1
Start a mail merge upon opening the document 1
Need help removing extra TOC text from number lists used as TOC levels 0
Finding the proper style field and the numbered paragraph value within the style 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top