Forum Discussion
Solved
Unable to edit source list in data validation in Excel
Hello, I have a created a drop down list in Excel 2016 and would like to edit the source list. However, when I go the source list under the data validation type and try to move across the list, it p...
Hi,
When you go to the Source box in the Data Validation and you want to edit it, you need to switch to the Edit mode.
The default is the Enter mode as the below screenshot:
Just press F2 to switch to the Edit mode so that you can move the cursor without inserting any cell references.
Hope that helps
Hi,
When you go to the Source box in the Data Validation and you want to edit it, you need to switch to the Edit mode.
The default is the Enter mode as the below screenshot:
Just press F2 to switch to the Edit mode so that you can move the cursor without inserting any cell references.
Hope that helps
And Boom..there it is! Thank you so much, I don't know that I would have every found that tip anyone. It worked perfectly!
Best regards,
Linda