For those of you who don’t know this shortcut…you are about to learn a staple in the shortcut world. Quickly displaying the Find Dialog box will save you those precious seconds of finding the option in your toolbar or menu, and now when your boss asks you if invoice #1245 has been paid you don’t have to scroll through your whole spreadsheet searching franticly for it.
Step 1: The only real requirement of this shortcut is that there is something to find in your Excel spreadsheet, meaning there is data somewhere. You can tweak the search by highlighting specific rows or cells you wish to search in, or execute the shortcut with without highlighting anything to search the entire spreadsheet.
Step 2: Execute shortcut:
And this pops up:
Type in the “Find what:” box the data you are searching for. I recommend keeping the options at their default settings but you can mess around with those if you’d like.
I searched Display the Find Dialog Box and clicked “Find Next”. This scrolled me to the cell with Display the Find Dialog box in it.
This is an invaluable tool when looking for data in a large spreadsheet. No one wants to scroll through a sea of data searching for that one cell, let the “command” + “F” shortcut do it for you!
Comments will be approved before showing up.