Search

M

Michele

Can anyone tell me how to search across all worksheets in
a workbook? I have a viewing diary with a sheet for every
day of the month and it would really help if we could
search the whole workbook for a name.

Many thanks

Michele
 
H

Harald Staff

Hi Michele

Slect all sheets first. It's done this way:

Click sheet tab of the first sheet. Hold Shift button and click the the last sheet tab.
Now search.
 
K

Ken Wright

Or if you have Excel 2002 (XP), then simply do Edit / Find / Options / Change 'Within Sheet' to
'Within Workbook'
 

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

Need Help with Macro Security 1
WORD VBA Search and switch to advanced ... 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Pulling/Collating Data from Workbooks 6
Help with Sumproduct searching cell contents 2
Search and consolidate multiple values in multiple fields 2
how do I search workbook for data 3

Top