How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Steve Herrod Your Own Question
Steve Herrod
Steve Herrod, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 3326
Experience:  Trained in Microsoft Office from 2000 through to latest version 2010.
Type Your Microsoft Office Question Here...
Steve Herrod is online now
A new question is answered every 9 seconds

Hello, I am doing an audit with registration numbers of

Customer Question


I am doing an audit with registration numbers of vehicles and other information. The registrations are arranged in rows, but there are two or three rows between each registration number that contains other info. What I want to do is see if these reg numbers occur on other sheets in the workbook (there are about 20-25 sheets per work book) and many vehicle registrations, so ctrl + F is not an option. I also need to indicate that they do occur in other worksheets, and possible other workbooks...

Do you have any suggestions?

Thanks in advance :)
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Steve Herrod replied 5 years ago.

Steve Herrod :

Hi, I'll be happy to help with this issue

Steve Herrod :

It should be possible to search multiple sheets using Ctrl F

Steve Herrod :

but you need to do it in the way below...

Steve Herrod :
  1. Select the worksheets that you want to search by holding down the SHIFT key and clicking the worksheet tabs.
  2. On the Edit menu, click Find.
  3. In the Find what box, type the data that you are searching for, and then click Find Next.
Steve Herrod :

Let me know if that hapens

Steve Herrod :

works ok

Steve Herrod :


Steve Herrod :