Create Drop-Down in Excel By Entering Data Manually
In the above model, cell references are utilized in the Source field. You can likewise add things straight by entering them physically in the source field. This is the way you can straightforwardly enter it in the information approval source field:
Step 1: Select the Cell
Select a cell where you need to make the drop-down list (cell A2 in this model).
Step 2: Go to the Data Tab and Select Data Validation in the Data Tools Group
Go to Data –> Data Tools –> Data Validation.
Step 3: Select List in Validation Criteria
In the Data Validation popup, inside the Settings tab, select List as the Validation Criteria. When you select List, the source field shows up.
- In the Source field, enter Yes, and No.
- Make sure that the In-cell dropdown option is checked. Click OK.
This will make a drop-down list in the chosen cell. Every one of the things recorded in the source field, isolated by a comma, is recorded in various lines in the drop-down menu.
Note: If you need to make drop-down records in different cells at one go, select every one of the cells where you need to make it and afterward follow the above advances.
How to Create a Drop-Down List in Excel
A drop-down list offers users a selection from predefined options, commonly used on sites/applications for easy navigation. Dynamic arrays in Excel 365 allow us to create drop-down lists quickly, without complex setups.
Contact Us