EXCEL-2000 column headings hide from data
 

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

EXCEL-2000 column headings hide from data
 

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" wrote:

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

EXCEL-2000 column headings hide from data
 

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.

"מיכאל (מיקי) אבידן" wrote:

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" wrote:

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

EXCEL-2000 column headings hide from data
 

Don't pick a column.

Pick a range.


Gord Dibben MS Excel MVP

On Wed, 24 Feb 2010 10:24:01 -0800, CRHIV
wrote:

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.

"????? (????) ?????" wrote:

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" wrote:

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