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 drop-down menu. A range of values in the range A2:A6 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 $2:A$6
None of the mentioned options
SA2:SA6
$A$2:$A$ 6
 You are using a worksheet reference when supplying values to a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!