Search

  • Thread starter Thread starter Michele
  • Start date Start date
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
 
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.
 
Or if you have Excel 2002 (XP), then simply do Edit / Find / Options / Change 'Within Sheet' to
'Within Workbook'
 
Back
Top