Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Key Takeaways. Open your Excel spreadsheet and select the cell where you want the drop-down list. Go to the “Data” tab on the Ribbon. Click on “Data Validation” in the Data Tools group.

According to this range, the new drop-down list will show the same options that are written in the A1 to A5 cells. Read: How to connect Google Sheets with Microsoft Excel . How do I change the ...

To create a drop-down list in Excel, you must use the Data Validation feature. Data Validation is a feature in Excel that allows users to pick from a list of rules to limit the type of data that ...

Using drop-down lists can also make inputting information faster by already having the inputs available. If you have cells where only specific information should be inputted, drop-down lists are a ...

Highlight the list of items: Select the range of cells that contains the items you want to include in your drop-down list. Use the “Name Manager”: Navigate to the “Formulas” tab in Excel ...