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)
👀 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
Watch video HOW TO Edit Drop Down List in Excel (find, add and remove items) online without registration, duration hours minute second in high quality. This video was added by user Excel at Work 30 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 76,852 once and liked it like people.