How to Find things in a Microsoft Excel spreadsheet

August 11, 2013

1 comment

Excel on Mac   Excel Shortcuts for Mac   Excel Skin   Find   find data   find shortcut   How Excel Skin Works  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Displaying the "Find" Dialog Box

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:

⌘F 

 

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!

 



1 Response

Sylvana
Sylvana

March 23, 2017

I have done this but it says Microsoft Excel cannot find the data you are searching for

Leave a comment

Comments will be approved before showing up.