ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Delete some column headings from an autofiltered range. (https://www.excelbanter.com/excel-worksheet-functions/256478-delete-some-column-headings-autofiltered-range.html)

Champ

Delete some column headings from an autofiltered range.
 
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?

Champ

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


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com