Forum Discussion

Copper Contributor

Jul 25, 2019

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...

excel

Haytham Amairah
Jul 25, 2019
smo4142

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

Haytham Amairah

Silver Contributor

Jul 25, 2019

smo4142

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

SCrider

Copper Contributor

Jul 04, 2020

Haytham Amairah I can pull up the validation box, and I can put it in edit mode, but not at the same time. What am I doing wrong? I want to be able to change options in the drop down menus. I added pictures to show my problem.