Next, make sure there are no empty columns or rows in your data. While you can still use Autofilter if you have headings in two rows as shown here, it's much easier if you stick to headings in just one row: You should avoid using column headings in two rows, as shown in the following example, because they can confuse Excel's Autofilter feature and stop it working as it should. Your column headings should occupy just one row of the spreadsheet, as shown in this example: Each column should have a heading that explains what sort of data is in the column. Follow these simple steps to check that your data table is ready to use with Autofilter:Ĭheck that your data is organised in columns. To use Autofilter, first ensure you have a table of data to work with. This lesson is applicable for all versions of Excel (including Excel for Mac) although the visual presentation of the options may change from version to version. This tutorial covers how to set up a data table in Excel to use with Autofilter, and also shows you how to enable Autofilter and use it for basic filtering. It is very powerful if you need to 'mine' data in a list and find out specific information about the data in that list. It lets you treat a range of cells as a table and then filter out certain rows based on different criteria.

Autofilter is one of the most powerful features of Excel if you need to work with data in tabulated (table) format.

Sort excel for mac