How to create drop-down list in Excel
Creating a dropdown list is easy in Excel, but the process is not obvious. Here is a summary of the steps to create a custom dropdown list in Excel:
- Create a Named Range: This step is necessary to create the list we’ll be using in your dropdown list.
- Add Data Validation: This is the not-so-obvious step where you’ll prime the cell for featuring a dropdown list.
- Add Named Range to Data Validation:Finally, you’ll put it all together and define the source of the dropdown list (i.e. your previously Named Range).
- Set Input Message for Data Validation:This step is optional. It lets you add a popup message to guide your spreadsheet users.
loading...
No comments: