To put a drop-down list in Excel, follow these clear steps:
- Select the cell(s) where you want the drop-down list to appear. This can be a single cell, a range, or multiple cells.
- Go to the Data tab on the Excel ribbon.
- Click on Data Validation in the Data Tools group.
- In the Data Validation dialog box, under the Settings tab, set Allow to List.
- In the Source box, enter the items you want in the drop-down list separated by commas (e.g., Apple, Banana, Cherry), or select a range of cells that contain the list items.
- Make sure the In-cell dropdown box is checked so the drop-down arrow appears.
- Click OK.
Now, when you click on the selected cell(s), a drop-down arrow will appear allowing you to choose from the list you created
. This method helps reduce data entry errors and speeds up input by limiting choices to predefined options. You can also customize the list source by using a cell range or a named range for dynamic updates
