| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple Column AutoFiltering
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I wish to have multiple column widths for a the same column. | Excel Worksheet Functions | |||
| generate multiple rows based on cell value | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| multiple criteria in one column | Excel Worksheet Functions | |||
Linear Mode
