C
CRHIV
How do you make the column headings where they don't show in data validation
drop down box?
drop down box?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
×
מיכ×ל (מיקי) ×בידן
Assuming the Data validation drop=down relays on a list [range of cells] DO
NOT include that cell while defining the data validation.
Micky
NOT include that cell while defining the data validation.
Micky
C
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.
column. When you set up D-V, it asks for a list, then you pick a column to
look in.
מיכ×ל (מיקי) ×בידן said: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 said:How do you make the column headings where they don't show in data validation
drop down box?
G
Gord Dibben
Don't pick a column.
Pick a range.
Gord Dibben MS Excel MVP
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.
????? (????) ????? said: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 said:How do you make the column headings where they don't show in data validation
drop down box?