How to add a drop-down list in Microsoft Excel

`Working with Excel sheets? There are a number of simple tips and simple shortcuts in Excel that can save you time and increase productivity for both beginners and advanced users. One of which is to add a drop down list in Microsoft Excel and some of you are probably not aware of it.

How to add a drop down list in Microsoft Excel

If you are using repeated values ​​in the cell, it is better to choose from the drop-down menu rather than typing each time, this makes things easier for you as you work with Excel sheets.

The more rows in your Excel sheet, the more of a mess it can be, it’s much easier to add a drop-down list, it also saves you a number of rows, and also prevents users from filling in the wrong values. Here’s how to insert or add a drop down list in Microsoft Excel.

How to add a drop down list in Microsoft Excel

  • Step 1: Select the Cellwhat you want to create as a drop-down list.
  • Step 2: In the menu bar, click Data and choose Validation.
  • Step 3: Under the Settings tab, you can see the validation criteria. Here in the To allow field, choose List from the drop-down list and type the origin of the cell from which you are bringing data into the list, for example from B1 to B10.
  • Step 4: Click OK to save and close the window.

Now the cell you selected will be turned into a drop down list showing you the list of data you originated. Here is the result, you can see the drop down list in the image below.

Note: We used Microsoft Excel using office.com, but the features remain very similar just like using the dedicated Excel app.

That’s it, here’s how you can add a drop down list in Microsoft Excel. Do you like this easy guide? Moreover things can be found below, take a look.

Obtain updates on the latest tech news, smartphones and gadgets, be sure to follow us on our social media profiles.

Instagram | Facebook | Twitter | Youtube

Follow us on Google News

Leave a Reply

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