How to Edit a Drop-Down List in Excel

Learn how to edit a drop-down list in Excel - quick and easy.
In the previous excel tutorial, we went through a simple guide on how to create a drop-down list in Excel. In this video, we’ll go a bit further and you’ll learn how to edit the drop-down menu and change options offered on the list.

Watch next video tutorial:

How to Create / Remove a Drop-Down List in Excel:

How to Create Filter in Excel

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 How to Edit a Drop-Down List in Excel
0:40 How to Edit Longer Drop-Down List in Excel
2:18 How to Edit Shorter Drop-Down List in Excel

================

Subscribe and watch more videos that help you use Microsoft Excel quick and easy

Transcription How to Edit a Drop-Down List in Excel here

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[InsightfulJourney]

Best tutorial well put together!! Thanks again!!🙏🏻

[Ravishingravisha]

Omg!! This video was such a savior 😍! Loved it. 😊 thanks 😊

[ocatri]

Excellent, thanks for the info very helpful

[WarholsCrystalBall]

Excellent video, it helped me create my income and expenditure account for my small business

[gregfam]

Thank you so much for this! However, I have encountered lists that also allow me to overrride the options by typing actual text, for example if the provided answers aren't relevant. How would I allow the box to be overridden by the user?

[BleuShellx]

I need help please! 😢😢. I want to make a list with a dropdown menu. With 2 colloms. 1 with a name and in de second a time. So the title is linked on the time but shows up in the next collum so i can total the time

[kellysharpe]

I click on it (in a template from Microsoft) and it does not take me to a list. It's "Monthly Personal Planner" and there is no separate tab with the data lists. I don't know where the data is coming from, but it doesn't go beyond May 2022 and I want to add the rest of the months.

[lindoizm]

This is helpful but excel does not send me to the source tab! I have a tab for "table" i didn't create and I cannot find it for the life of me!

[simonrehak]

it doesnt work for me :( When i wanna shorter drop down list and i wanna mroe options, everything is in a line... For example *Source: Yes, Maybe, No* and i cannt choose only one option but it always choose like *Yes, Maybe, No* whyy :(