HOW TO Edit Drop Down List in Excel (find, add and remove items)

Learn how to edit a drop down list in Excel (drop down menu). Includes how to remove and add items to a drop down list, and how to find a drop down list in Excel.

Timing:
@ 00:00 How to edit a drop down list in Excel
@ 00:45 Excel how to find drop down list
@ 02:09 Excel how to find drop down list if Source is a Named Range
@ 03:18 Excel – edit, remove and add items to drop down list
@ 04:43 Excel – edit, remove and add items to drop down list if Source is a Named Range (for older versions of Excel)

Related video:

Related video: [put links to Create drop down and edit drop down here]

❤ VERSION FRIENDLY ❤
Try this with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork

[gevans]

I love listening to women teach! So simple yet comprehensive enough that you explained everything really well. Thank you

[meljomartin]

You are a lifesaver! This is the first video I've watched that mentions the "unhide" option. Thank you!

[amoamasamt]

Thanks for the clear and concise instructions. In my case the Excel dropdown list that I needed to edit was entered right into the "source" box in the Data Validation Settings Tab. It's a lot easier to edit if it's in a spreadsheet location as you instructed. To add a blank where I could enter information other than the listed items, I added, after the last item (which was separated by commas), two hyphens (--). I would never have been able to figure this out without your and others help! A million thanks!

[abdk]

You are just Amazing!!! Couldn't find this "in depth" information anywhere else on youtube!!!

[shivathealmighty]

I love your crucifix locket.. God bless you❤..

[darkbeauty]

Exactly what I needed. I wanted to edit the data in a drop down list in an Excel Template.

Your instructions showed me how to find and edit the lists. Thanks so much.

New subscriber! 😁

[ericacastro]

Thank you thank you thank you! Straight to the point very clear instructions you are a blessing!!

[charlenegarcia]

Oh My Gosh, You have helped me so much, you can't even imagine. I've been trying to update a huge long running spreadsheet, that I didn't originally put together. I have been trying to figure this out since Monday (it's now Wednesday). Good God, ur a Blessing 😇💝

[conkaiserdor]

Helped me way more than any other google search, thanks!

[carrollphillips]

I viewed many videos and came across your video; I figured it out after reviewing it. Thank you so much for help your expertise.

[LeonPessanha]

Not every hero wears capes...you are my guarding angel! Thank you so much! I couldn't find the damn list source. 😅

[geejaysf]

You have a few key parts that others miss.

[alizaki]

That's great and excellent, THANK YOU!!

[MrJhawk]

Thanks! Just what I needed! Subscribed for future tips:-) Take Care.

[kristinastringfield]

Thank you sooo much!!!! Easy instructions!

[murth]

Thank you so much, in my case the sheet was hidden so you solved my problem. 🙂

[jessetyson]

How can you quickly search a name without scrolling through all the names in the list ?

[BlakeC]

Didn't work for me. The Data Validation dialog box does not show any such field as "Source".

[KevinCross-fhsk]

what if the Drop down list is not in a cell? it's just there in the middle of the sheet... I've tried to delete the rows but it's still there

[wildwestunlimited]

I know how to make a drop down list. The drop down list only shows 7 items in my list. I want to see more in the list below the scroll. Do you have a video on this? Thank you!!!