Have you ever searched an entire Excel spreadsheet for data that matched certain criteria?
Use the AutoFilter in Excel and you will be able to find data much quicker.
To do so, simply follow these easy steps:
With your list open, click on the "Data" Tab on the Ribbon. On the Data Tab, simply click the "Filter" button.
Notice your data Headers all have Drop Down Arrows next to them.
Now, simply click on the Drop Down Arrow of the Header (or Column) that contains the data in which you wish to search.
You may search for a specific item from the Drop Down list OR you may click on "Number Filters" from the Drop Down and another sub-menu will appear giving you options to search on items Greater than a particular number, etc.
Click on the Data Menu and choose "AutoFilter" and then follow the steps above.
It's that simple!
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
Since 1998, Google has been giving us Google Doodles. The first Google Doodle was in honor of the Burning Man Festival . It wa...