| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using validation and a default value | Excel Worksheet Functions | |||
| Default Windows Profile without default Office user info | Excel Discussion (Misc queries) | |||
| Validation Cell Always Visiable, with a default message in it... | Excel Discussion (Misc queries) | |||
| How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
| Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
Linear Mode
