microsoft excel training london - find words multiple sheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training london - Find words in multiple sheets

microsoft excel training london - Find words in multiple sheets

resolvedResolved · Low Priority · Version Standard

Vicky has attended:
PowerPoint Introduction course

Find words in multiple sheets

Is there a way of using ctrl F to find a word in excel in all sheets when multiple sheets are used?

RE: Find words in multiple sheets

Yes. If you select multiple sheets (hold Ctrl or Shift), and then search, Excel will search all the sheets you specified.


 

Excel tip:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips


Server loaded in 0.09 secs.