How to Create DROP DOWN LIST in Excel cell
Learn how to create a drop-down list in an Excel cell. This Excel 365 tutorial covers how to create a drop-down list using data from the same worksheet or another sheet and creating drop-down lists in earlier versions: Excel 2016, Excel 2013, and Excel 2010.
Timing:
@ 00:00 How to create drop down List in Excel cell
@ 00:44 How to create a drop down list on the same worksheet
@ 03:15 Add a drop down from a list on another Sheet (Excel 2010 to Excel 365)
@ 04:58 Excel Tip: How to protect your list
@ 05:20 Create a drop down list from a different worksheet (for older versions of Excel)
Related Videos:
How to EDIT AN EXISTING Drop Down List in Excel (find, add and remove items) • HOW TO Edit Drop Down List in Excel (...
How to REMOVE a Drop Down List in Excel
• Remove Drop Down List in Excel
👀 Read the full blog post here: https://excelatwork.co.nz/2021/07/04/...
🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Essential Steps to becoming Proficient in Excel’ PDF today: https://excelatwork.co.nz/subscribe/ 🔔
❤ VERSION FRIENDLY ❤
Try this with 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
Смотрите видео How to Create DROP DOWN LIST in Excel cell онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel at Work 23 Июнь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 655 раз и оно понравилось like людям.