validation list

E

enyaw

I have a drop down list in a cell using a validation list. The list is on the
same worksheet as the drop down list. I inputted the letters A to Z in my
list and sorted it to use as sort of an autocomplete but when I protect the
sheet i cannot use this. Can anyone help?
 
M

Max

enyaw said:
I have a drop down list in a cell using a validation list. The list is on the
same worksheet as the drop down list. I inputted the letters A to Z in my
list and sorted it to use as sort of an autocomplete but when I protect the
sheet i cannot use this. Can anyone help?
Click to expand...

Just like for any data input range(s),
unlock* your DV range/cells before you apply sheet protection

*Select the DV range, then click Format > Cells > Protection tab > Uncheck
"Locked" > OK

To quick select all DV cells in the sheet for the unlocking:
Press F5 > Special > Data validation > All > OK
 
Top