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.

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.

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