Translations:Basic Excel/48/en
Caution!
Before applying an autofilter, it is important to check that you will be applying the filter to the entire dataset of interest.
- An autofilter will be applied to the block of contiguous data in which the cursor is located when the autofilter is applied.
- Any blank (empty) rows or columns will restrict the scope of the autofilter to a subset of the data.
- This can have disastrous consequences if any of the autofilter's sorting options have been applied.