| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
