Automatically search entire Excel spreadsheet

How can I make it so that all searches within an Excel 2016 spreadsheet will start from the beginning (without me having to scroll to the top of the spreadsheet)?

The cursor or mouse pointer will often be located somewhere towards the middle of an Excel spreadsheet and when I search for something the result won't be found since the item I am looking for is located above where I am originating my current search. I will then have to press the CTRL-Home keys to scroll to the top of the spreadsheet in order to find what I am looking for.

I would rather be able to search the entire spreadsheet without having to first press the CTRL-Home keys to move to the top of the spreadsheet in order to begin the search.

How can this be done?
IT GuyNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew LeniartIT Consultant & Freelance JournalistCommented:
Providing no columns or rows are highlighted, Excel should default to searching from the start of the spreadsheet when you do a CTRL-F to search, or Ctrl-H to search and replace.  There is no need to scroll to the top when I do it here?
Rob HensonFinance AnalystCommented:
If the value being searched occurs more than once, one near the top of the sheet and one towards the end, when the cursor is in the middle of the sheet then the value that is towards the end will be found first, clicking Find next will then go to the one at the top.

If the value only occurs once then the same principle will apply; the search will go down the sheet first but then go back to the top to continue without any user prompt, unlike MS Word which does ask if you want to continue at the start of the document.
Zeth LarssonCommented:
Try to import the attached file into you VBA editor.
Then go to your XL meny an open the macro dialog (View->Macron), where you can execute the macro, and assign it to some key-combination, for quick start.
SearchWorkSheet.bas
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

IT GuyNetwork EngineerAuthor Commented:
Zeith,

Can you please provide me with the steps on how I can import the attached file into my VBA editor? I'm not sure how to do this.
Rob HensonFinance AnalystCommented:
Had a thought since posting; as we have already said it doesn't matter where the cursor is, it will still searh the whole sheet.

The one caveat - if you have a range of cells selected, the search will only search that range.

The fact that you're pressing Home to get desired results would suggest you are moving from a selected range to a single cell rather than the fact that you're moving to the top.
Zeth LarssonCommented:
It is like the last contributor Rob says, normaly the search function schould search the hole worksheet.
But if it is not the case for your installation, you can use the file I sent.
1: open MS Excel
2: Click click the menu "Developer".
   If you don't have a menu option "Developer", do this, else goto step 3
   (this is translation from my swedish XL, and some Googlish :-)
   a: Klick "Archive". b: Click "Alternative". c: Klick "customize the menu area"
   d: In the rigt part of the dialog, check the checkbox "Developer". Back out with OK
3: Select the "Visual Basic" button.
4: In the left side of the window, you may se something like image01.png
5: Rightclick "VBAProbject...." and select "Import file...", and the file I sent you. Click "Open",
Then you schould get a new module, and the script is ready to execute.
image01.PNG
BillDLCommented:
Do you have a "Find ALL" button in your "Find" dialog?

https://www.gcflearnfree.org/excel2016/using-find-replace/1/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Zeth LarssonCommented:
Yes, I have a button for "Find all"
Translation from swedish.
Start (to the right of Archive) -> Edit (tool at the far right) -> Search and edit (binoculars symbol).
That open a dialog with lots of options.
BillDLCommented:
I was wondering whether the person asking this question can see that button.
IT GuyNetwork EngineerAuthor Commented:
I've started using the "Find all" button. Thanks for pointing that out.
BillDLCommented:
Thank you Knowledgeable
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.