As an example:
I highlight columns C, D, and E.
Click Data, Filter, AutoFilter
Column C, D, and E now have the arrows to filter
In column A and B there is some information.
Is it possible to make it such, that when C, D, or E are filtered that it does not effect column A or B at all?
Despite being able to select which columns to AutoFilter it effects every row that is not part of the AutoFilter columns.
Anyway to restrict the rows filtered to just the columns selected for AutoFilter?
I am using Excel 2000