| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Delete lists and/or filters from of range cells.
My spreadsheet has auto filter set and has therefore created lists at the top
of each column within my specified range of cells. I would like to retain the first 3 lists but delete the rest. Is this possible? Cheers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Delete lists and/or filters from of range cells.
Deselect autofilter, then select the 3 consecutive columns which you wish to
cover with the filter, then reselect autofilter. -- David Biddulph "Champ" wrote in message ... My spreadsheet has auto filter set and has therefore created lists at the top of each column within my specified range of cells. I would like to retain the first 3 lists but delete the rest. Is this possible? Cheers. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 - Delete lists and/or filters from of range cells.
Lists and autofilter are different.
You may want to explain what you have (include range addresses) a little more if David's response doesn't solver your problem. Champ wrote: My spreadsheet has auto filter set and has therefore created lists at the top of each column within my specified range of cells. I would like to retain the first 3 lists but delete the rest. Is this possible? Cheers. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove or delete lists/filters. | Excel Discussion (Misc queries) | |||
| Linking Lists and Filters between Worksheets in Excel | New Users to Excel | |||
| In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
| Delete row if all cells are blank, Excel 2000 & 2003 | Excel Discussion (Misc queries) | |||
| Delete automatic headers/footers in dropdown lists in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
