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:
Excel 2007:
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.
Excel 2003:
Click on the Data Menu and choose "AutoFilter" and then follow the steps above.
It's that simple!
Subscribe to:
Post Comments (Atom)
-
Many people are familiar with online e-mail accounts that provide access from anywhere you have Internet access. These accounts include G...
-
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 ...
-
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?...
No comments:
Post a Comment