Adobe Apple AWS CertNexus Check Point Cisco Citrix CMMC CompTIA Dell Training EC-Council F5 Networks Google IBM ISACA ISC2 ITIL Lean Six Sigma Oracle Palo Alto Python PMI Red Hat Salesforce SAP SHRM Tableau VMware Microsoft 365 AI Azure Dynamics Office Power Platform PowerShell Security SharePoint SQL Server Teams Windows Client Windows Server
Agile / Scrum AI / Machine Learning Business Analysis Cloud Cybersecurity Data & Analytics DevOps Human Resources IT Service Management Leadership & Pro Dev Networking Programming Project Management Service Desk Virtualization
AWS Agile / Scrum Business Analysis CertNexus Cisco Citrix CompTIA EC-Council Google ITIL Microsoft Azure Microsoft 365 Microsoft Dynamics 365 Microsoft Power Platform Microsoft Security PMI Red Hat Tableau View All Certifications
How to Create Drop Down Lists in Microsoft Excel Taylor Karl / Thursday, December 30, 2021 / Categories: Resources, Microsoft Office, Training Trends 3433 0 We are back with another "How To" blog for those of you looking for some quick and easy tips for Microsoft Excel. Let's jump in and learn how to create a drop down selection list! First, you will want to select the cell that will house the drop-down selection list: Example shown below: Next, you will journey over to the Data Tab: This tab is located in between the "Formulas" and "Review" Tabs at the top of the Excel sheet. Select Data Validation in the Data Tools Section: This section can be found in between "Sort & Filter" and "Forecast" Sections. Once you click Data Validation, a pop-up box will appear: Example shown below In the Allow Drop Down you will select "Lists": Example shown in the picture below Click in the Source box and then proceed to type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list and then click OK: You can also click your mouse on the cells and drag your mouse if you want multiple selections as shown below. Now your drop-down lists have been placed in the cells you selected: Before: After: There you have it! Your drop-down selections are now in the cell or column you prefer. For more Excel tips head to our Blog or you can venture to our Webinar Page to see what amazing events we have slated for the future! Submit your email below to download our free 49-page eBook, Top 20 Office Productivity Tips Print Tags Microsoft Excel Excel Hacks Microsoft Excel How To Series Excel Tips Related articles Excel Certification: What It Is and Why It Matters in the Professional World Microsoft SC-900 vs CompTIA Security+: All You Need To Know What’s the Difference: Power BI, Power Query, & Power Pivot Leading Through Change: Embracing AI and Automation in Your Organization Microsoft Power BI Vs Tableau: A Comprehensive Guide