Войти
  • 1353Просмотров
  • 4 года назадОпубликованоExcel at Work

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 REMOVE a Drop Down List in Excel 👀 Read the full blog post here: 🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Essential Steps to becoming Proficient in Excel’ PDF today: 🔔 ❤ VERSION FRIENDLY ❤ Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 ( 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