Thread: Delete some column headings from an autofiltered range.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Champ Champ is offline
external usenet poster
  
Posts: 37
Default Delete some column headings from an autofiltered range.


"Champ" wrote:

I've selected a range of cells e.g. A6 to CP83 and autofiltered this range. I
wish to retain the list headings for columns A to C but wish to remove the
list headings from the remaining columns D to CP without affecting the
overall list range. Can this be done? ......and more importantly remove the dropdown list arrow from columns D to CP.

Thanks
Champ
Reply With QuoteReply With Quote