Excel 2003 - Delete lists and/or filters from of range cells.

[Champ]

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.

 

[David Biddulph]

Deselect autofilter, then select the 3 consecutive columns which you wish to
cover with the filter, then reselect autofilter.

 

[Dave Peterson]

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.