Data Filter on Selected rows and columns

[Mike]

I would like to filter only a few selected rows and columns on my worksheet,
can I do this? Whe I higlight the selected rows and columns, it doesn't seem
to hold when I turn on the data filter. Please advise.

Thank you
Mike

 

[Don Guillett]

You can limit the rows but you cannot limit the columns.

 

[Gord Dibben]

Excel 2003........Data>List>Create List with the selected range.

Filtering and sorting will be done only within the List.

Excel 2007..........Insert>Table


Gord Dibben MS Excel MVP