EXCEL-2000 column headings hide from data

[CRHIV]

How do you make the column headings where they don't show in data validation
drop down box?

 

[מיכ×ל (מיקי) ×בידן]

Assuming the Data validation drop=down relays on a list [range of cells] DO
NOT include that cell while defining the data validation.
Micky

 

[CRHIV]

I don't see a way not to include the row of labels that are on the top of the
column. When you set up D-V, it asks for a list, then you pick a column to
look in.

Assuming the Data validation drop=down relays on a list [range of cells] DO
NOT include that cell while defining the data validation.
Micky

How do you make the column headings where they don't show in data validation
drop down box?

 

[Gord Dibben]

Don't pick a column.

Pick a range.


Gord Dibben MS Excel MVP

I don't see a way not to include the row of labels that are on the top of the
column. When you set up D-V, it asks for a list, then you pick a column to
look in.

Assuming the Data validation drop=down relays on a list [range of cells] DO
NOT include that cell while defining the data validation.
Micky

How do you make the column headings where they don't show in data validation
drop down box?