Jul 25 2019 08:48 AM
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 puts a cell reference there. Has anyone else had this problem. I may just not know what I am doing as this is the first time I have created a dropdown list in Excel.
Thank you,
Linda
Jul 25 2019 09:50 AM
Solution
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
Jul 25 2019 10:26 AM
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
Jul 03 2020 11:09 PM
@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.
Aug 11 2022 07:33 PM
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.
Jul 25 2019 09:50 AM
Solution
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