| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Filter on Selected rows and columns
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Filter on Selected rows and columns
You can limit the rows but you cannot limit the columns.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Filter on Selected rows and columns
Excel 2003........DataListCreate List with the selected range.
Filtering and sorting will be done only within the List. Excel 2007..........InsertTable Gord Dibben MS Excel MVP On Mon, 7 Dec 2009 11:46:01 -0800, Mike wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Advanced Filter: How do you MOVE the selected rows... | Excel Worksheet Functions | |||
| SHADING OF SELECTED ROWS & COLUMNS | Excel Discussion (Misc queries) | |||
| Highlighting selected cells/rows/columns | New Users to Excel | |||
| No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
| How to printout only selected rows and columns | New Users to Excel | |||
Hybrid Mode
