Teach Yourself Excel Lesson 21 - Filter Data

Filter Data
Now you want to know how many of those expenses occurred in the last 1000 days.
Autofilter is perfect for this!
Steps:
- Select A1
- Press in sequence: ALT then D then F then F
- Select the arrow on cell F1
- Choose "Number Filters"
- Choose "Less than"
- Type 1000
- 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:
Attachment | Size |
---|---|
filter-data.xls | 22 KB |
»
- Nick's blog
- Login or register to post comments
- 10901 reads
Recent comments
5 years 51 weeks ago
6 years 37 weeks ago
6 years 49 weeks ago
6 years 51 weeks ago
7 years 5 days ago
7 years 6 weeks ago
7 years 14 weeks ago
7 years 14 weeks ago
7 years 15 weeks ago
7 years 15 weeks ago