Excel is all about data, and as a result, you’re frequently left with data you’d rather not have. If you leave a cell open, as in free to add anything to, expect errors of this type to appear, especially if the spreadsheet is a collaborative effort.
You can limit your exposure to incorrect data additions by only providing users with a limited number of options to choose from when using a drop-down list. This is how it’s done.
What Is A Drop Down List?
Figure A depicts a basic drop-down list in an Excel sheet. Click the data entry cell (D2 in this case) and then the drop-down arrow to display the list of values in B3:B6. If a user enters something that isn’t on that list of values, Excel rejects the entry, ensuring the validity of your data.
Here’s How You Can Create A Drop-Down List
- Start an Excel workbook.
- Select a cell to hold your drop-down menu.
- Go to the top of the screen and select the Data tab. Atop the Ribbon, it’s nestled between Formulas and Review.
- Select the Data Validation option.
- Find the Allow menu in Settings and select List from the options.
- Highlight the cells you want to include in the drop-down menu selection options, then click OK. If this does not work right away, click the Source box first, then highlight.
An Excel drop-down list can make data entry easier for the average Microsoft Excel user. Using a drop-down menu restricts the entry options for a selected cell, which speeds up data entry and reduces data entry errors.
With this guide, you should have no trouble creating drop-down lists of your own. Still, if you have any doubts(or suggestions), please leave them in the comments down below.