Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
how to set default value in list validation for a cell
Ex: a list validation with values 2,3,4,5.. in a cell In this 3 should be default value when u open the file for the particular cell Please put some light on this. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the default selection in a validation dropdown is the current value of the
cell if there is a match. Otherwise nothing will be shown as selected. -- Regards, Tom Ogilvy "harinath" wrote in message ... how to set default value in list validation for a cell? Ex: a list validation with values 2,3,4,5.. in a cell. In this 3 should be default value when u open the file for the particular cell. Please put some light on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Results with a Validation List | Excel Worksheet Functions | |||
Data Validation "List" - Setting length of list shown | Excel Discussion (Misc queries) | |||
lookup one value in list and return multiple results | Excel Worksheet Functions | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
I need function that can list the "top ten" highest results | Excel Worksheet Functions |