validation with a default

  • Thread starter Thread starter Ruth
  • Start date Start date
R

Ruth

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?
 
Pre-fill the cell with the default value, but leave all three options in the
pull-down.
 
Back
Top