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

microsoft excel training london - find words multiple sheets

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

ResolvedVersion 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:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.