How to create a drop-down list in Microsoft Excel

Posted on by

How to create a drop-down list in Microsoft Excel
Microsoft 365
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection. You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow and then clicks an entry in the list. Learn more: https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b ► Subscribe to Microsoft 365 on YouTube here: https://aka.ms/SubscribeToM365 ► Follow us on social: LinkedIn: https://www.linkedin.com/showcase/microsoft-365/ Twitter: https://twitter.com/Microsoft365 Instagram: https://www.instagram.com/microsoft365/ Facebook: https://www.facebook.com/Microsoft365/ ► For more about Microsoft 365, visit https://msft.it/6006Tc8Z4 #Microsoft365 #MicrosoftExcel
https://youtu.be/udv5tffwEX0