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'
 
Top