Filter Data

Download starting Sheet

Now you want to know how many of those expenses occurred in the last 1000 days.

Autofilter is perfect for this!

Steps:

1. Select A1
2. Press in sequence: ALT then D then F then F
3. Select the arrow on cell F1
4. Choose "Number Filters"
5. Choose "Less than"
6. Type 1000
7. Press OK

Great !... only one expense in the last 1000 days. My wife must be taking this cost cutting seriously.

Your sheet should now look like this

To turn filter off:

• Press in sequence: ALT then D then F then F

Next Lesson: Teach Yourself Excel Lesson 22 - VLOOKUP Formula

Training Video on how to Filter Data in Excel: