I have a range of data from A2:A10 that i am displaying through data validation drop down list.
I want to display a default value when i press delete on any of the cells in range .The default value -"Select Value" which will always be displayed when i am going to select a dropdown value.Please help.
eg-the dropdown should have value like this and select value will always be displayed even if i press delete or nothing is entered.
Select Value
A
B
C
I want to display a default value when i press delete on any of the cells in range .The default value -"Select Value" which will always be displayed when i am going to select a dropdown value.Please help.
eg-the dropdown should have value like this and select value will always be displayed even if i press delete or nothing is entered.
Select Value
A
B
C