Wiki Sumber Informasi iSIKHNAS

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.