SOLVED
Home

Unable to edit source list in data validation in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-773651%22%20slang%3D%22en-US%22%3EUnable%20to%20edit%20source%20list%20in%20data%20validation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773651%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20created%20a%20drop%20down%20list%20in%20Excel%202016%26nbsp%3Band%20would%20like%20to%20edit%20the%20source%20list.%20However%2C%20when%20I%20go%20the%20source%20list%20under%20the%20data%20validation%20type%20and%20try%20to%20move%20across%20the%20list%2C%20it%20puts%20a%20cell%20reference%20there.%20Has%20anyone%20else%20had%20this%20problem.%20I%20may%20just%20not%20know%20what%20I%20am%20doing%20as%20this%20is%20the%20first%20time%20I%20have%20created%20a%20dropdown%20list%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ELinda%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773807%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20source%20list%20in%20data%20validation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773807%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382183%22%20target%3D%22_blank%22%3E%40smo4142%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20go%20to%20the%20Source%20box%20in%20the%20Data%20Validation%20and%20you%20want%20to%20edit%20it%2C%20you%20need%20to%20switch%20to%20the%20Edit%20mode.%3C%2FP%3E%3CP%3EThe%20default%20is%20the%20Enter%20mode%20as%20the%20below%20screenshot%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124509iE03F34C9C0071BD4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Enter%20Mode.png%22%20title%3D%22Enter%20Mode.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20press%20F2%20to%20switch%20to%20the%20Edit%20mode%20so%20that%20you%20can%20move%20the%20cursor%20without%20inserting%20any%20cell%20references.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773857%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20source%20list%20in%20data%20validation%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773857%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20Boom..there%20it%20is!%20Thank%20you%20so%20much%2C%20I%20don't%20know%20that%20I%20would%20have%20every%20found%20that%20tip%20anyone.%20It%20worked%20perfectly!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ELinda%3C%2FP%3E%3C%2FLINGO-BODY%3E
smo4142
New Contributor

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

 

 

2 Replies
Solution

@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:

Enter Mode.png

 

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 

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies