[6 Easy Steps] How To Add A Drop Down List In Excel On My PC?

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.

How To Add A Drop Down List In Excel
Figure A

Here’s How You Can Create A Drop-Down List

  • Start an Excel workbook.
How To Add A Drop Down List In Excel
  • Select a cell to hold your drop-down menu.
How To Add A Drop Down List In Excel
  • Go to the top of the screen and select the Data tab. Atop the Ribbon, it’s nestled between Formulas and Review.
How To Add A Drop Down List In Excel
  • Select the Data Validation option.
How To Add A Drop Down List In Excel
  • Find the Allow menu in Settings and select List from the options.
How To Add A Drop Down List In Excel
  • 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.
How To Add A Drop Down List In Excel

Also read:- How To Remove Activate Windows Watermark? [Explained Briefly]

Conclusion

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.

Good luck!

Leave a Reply

Your email address will not be published. Required fields are marked *

How To Charge Laptop In Car? [Gadgets Used] What Happens If I Reset My iPhone? Check out iPhone 14 Colors HD Pro All Full Forms Of Computer Subject