Content

How do I use AutoFilter in Excel?

To use AutoFilter in Excel...

  1. Click ‘Data’
  2. Point to ‘Filter’
  3. Click ‘AutoFilter’
    1
  4. An arrow will be placed to the right side of each column in the top row 1
  5. You can then filter the data by clicking on any of the options in any of the list to only bring up the records that match the criteria that you choose.
  6. To take the filter off – Click ‘Data’, Point to ‘Filter’, Click ‘AutoFilter’
Last Updated On: 9/22/06