Highlight the entire area between column1 and column 2 and then apply Auto
Filter.
That should work.
Alok
"Peter Crickman" wrote:
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.
|