Forum Discussion

smo4142's avatar
smo4142
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's avatar
    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's avatar
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

RStepovich's avatar
RStepovich
Former Employee
Aug 12, 2022

Haytham Amairah 

I'm using the F2 key, it looks like it works, I save it, refresh everything and my typo is still in my drop down list, but it has been 'fixed' in the data validation source list.

Resources