Remove Header/Title from list
 

I have several lists created and use them for pull downs on various sheets.
I would like to eliminate the title row such as "Column 1". I have added my
own titles instead of "Column 1" but would prefer no header as this becomes a
valid selection in the pull down. Any suggestions?
--
Dar

Remove Header/Title from list
 

You can have your cake and eat it:

Rather than start you validation pull-down at the top of a column (H1 thru
H30 for example), use H2 thru H30
--
Gary''s Student - gsnu200796


"DarS" wrote:

I have several lists created and use them for pull downs on various sheets.
I would like to eliminate the title row such as "Column 1". I have added my
own titles instead of "Column 1" but would prefer no header as this becomes a
valid selection in the pull down. Any suggestions?
--
Dar

Remove Header/Title from list
 

Thanks that works until I populate the sheet referenced by the pull downs
again with data from Access. Then row 2 contains the title.

But thanks for the tip. I will try a few other things incorporating your
suggestion and see if I can make it work.

Thanks again,
--
Dar


"Gary''s Student" wrote:

You can have your cake and eat it:

Rather than start you validation pull-down at the top of a column (H1 thru
H30 for example), use H2 thru H30
--
Gary''s Student - gsnu200796


"DarS" wrote:

I have several lists created and use them for pull downs on various sheets.
I would like to eliminate the title row such as "Column 1". I have added my
own titles instead of "Column 1" but would prefer no header as this becomes a
valid selection in the pull down. Any suggestions?
--
Dar