validation with a default
 

Hi

I have a cell that uses a validation list with 3 different options: "Net",
"Gross", and "Metric". Is there a way to have "Net" as the default and if
they need "Gross" or "Metric" they can select it from a drop down list?

--
Thank-you!
Ruth

validation with a default
 

Pre-fill the cell with the default value, but leave all three options in the
pull-down.
--
Gary''s Student - gsnu200902


"Ruth" wrote:

Hi

I have a cell that uses a validation list with 3 different options: "Net",
"Gross", and "Metric". Is there a way to have "Net" as the default and if
they need "Gross" or "Metric" they can select it from a drop down list?

--
Thank-you!
Ruth

validation with a default
 

Thank-you! I didn't think it could be so easy
--
Thank-you!
Ruth


"Ruth" wrote:

Hi

I have a cell that uses a validation list with 3 different options: "Net",
"Gross", and "Metric". Is there a way to have "Net" as the default and if
they need "Gross" or "Metric" they can select it from a drop down list?

--
Thank-you!
Ruth