How can you add a drop-down list in a cell in Excel?

To add a drop-down list in a cell in Excel, follow these simple steps:

1. Select the cell where you want the drop-down list to appear.
2. Go to the "Data" tab on the Excel ribbon.
3. Click on the "Data Validation" button in the "Data Tools" group.
4. In the Data Validation dialog box, select "List" from the Allow drop-down menu.
5. In the "Source" field, enter the items you want to appear in the drop-down list, separated by commas.
6. You can also select a range of cells on the worksheet that contains the list of items.
7. Click OK to apply the data validation and create the drop-down list in the selected cell.

By following these steps, you can easily add a drop-down list in a cell in Excel, making data entry more efficient and accurate.

For more Microsoft Excel tips and tricks, check out our Excel category.