Multiple Column AutoFiltering

[Peter Crickman]

Hi,

I would like to be able to AutoFilter on two non-adjacent columns in a
spreadsheet. Is there any method to perform this task in Excel 2002 (XP)?
I get an error that the range is non-contiguous when I select two columns
separated by one or more columns.

Thanks in advance.

 

[Guest]

Highlight the entire area between column1 and column 2 and then apply Auto
Filter.
That should work.

Alok