Filter for blank cells, non-blank cells, use criteria to filter, filter by cell or font color, just to name a few. Watch this video for more details.
Other videos in this course
This video is part of a training course called Sort and filter data. You can download the entire course or watch the videos online:
- Video: Sort and filter data. Sort data in Excel quickly, in just a few clicks. To change the order of your data, sort it. To focus on a specific set of data, filter a range of cells or a table.
- Video: Sort details. We sorted numbers in the previous video. You can also sort text and dates, either alphabetically, by format (such as color), or by a custom list you create.
- Video: AutoFilter details. (You are here!) Filter for blank cells, non-blank cells, use criteria to filter, filter by cell or font color, just to name a few. Watch this video for more details.
- Video: Advanced filter details. You can use the Advanced Filter to create more powerful filters, such as filtering for unique records and using operators such as OR.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.