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)
Read the full blog post here: https://excelatwork.co.nz/2021/07/05/...
Related video:
HOW TO Create Drop Down Menu in Excel • How to Create DROP DOWN LIST in Excel...
Remove Drop Down List in Excel • Remove Drop Down List in Excel
Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/
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