ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide column header or first field in a list (https://www.excelbanter.com/excel-discussion-misc-queries/179450-hide-column-header-first-field-list.html)

DarS

Hide column header or first field in a list
 
I have a named list. The first field in the list always seems to take on the
Header Row property. If I delete the row Column 1 then appears. I am
referencing the list as a validation drop down and Column 1 or what ever the
first field is becomes a valid selection. If I replace Column 1 with a vaild
choice it will not sort a-z but remains as the first item. Anyway around
that?
--
Dar


All times are GMT +1. The time now is 06:22 AM.

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