Question: You are using a worksheet reference when supplying values to a drop - down menu. A range of values in the range A 2 :A
You are using a worksheet reference when supplying values to a dropdown menu. A range of values in the range A:A is supplied directly inside the data validation window.
Which of these is the right way to enter the range to prevent the range from changing as the data validation is applied to other cells?
A $:$
None of the mentioned options
SA:SA
$A$:$A$
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
