Data Filter on Selected rows and columns

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
Back
Top