Autofilter Secrets In Excel

摘要

With every new version of Excel, the AutoFilter command becomes more powerful. It's simple to do basic AutoFiltering: Enable the filter dropdowns, and choose an item from the dropdown to filter a data set. This month's article, however, will cover three lesser-known AutoFilter features. You can enable the AutoFilter drop-downs on the headings of your data set in a number of ways. In Excel 2003, you can go to the Data menu and choose Filter, AutoFilter. In Excel 2007, choose the large Filter icon on the Data tab of the ribbon. The dropdowns will also appear if you use Ctrl+L in Excel 2003 or Ctrl+T in Excel 2007.