how can you get autofilter to work on more than one column at a time?
D Debra Dalgleish Sep 14, 2004 #2 If you select one cell in the table, and choose Data>Filter>AutoFilter, all columns in the table should have an AutoFilter dropdown arrow. You can filter one column, then others in the same table.
If you select one cell in the table, and choose Data>Filter>AutoFilter, all columns in the table should have an AutoFilter dropdown arrow. You can filter one column, then others in the same table.