Filter Drop-Down Not Working in Excel | Not Filtering All Columns or All Rows

In this video I explore eight reasons why filtering in Excel is not working properly (or at all!).

Table of Contents:

00:00 - Introduction
00:09 - REASON 1: Data contains blank rows or columns
02:32 - REASON 2: Data contains hidden blank rows or columns
04:03 - REASON 3: You have merged column headings
05:28 - REASON 4: You have merged cells in your records (data)
06:44 - REASON 5: Top 10, Above Average & Below Average filters don't work due to error in data
07:36 - REASON 6: Inconsistent formatting applied eg currency or dates
10:03 - REASON 7: Filter drop-downs are non responsive because sheets are grouped
10:54 - REASON 8: Filter drop-downs are non-responsive and buttons are greyed out because sheet is protected
------------------------