How to Create A Drop Down List in Excel


How do I make a drop down list in Excel or how can I create a drop down list in excel? Excel is a little bit of a complex tool that requires a better understanding of how to use excel. Not anymore is similar to how to use excel because of the various feature, unlike Microsoft Word. Therefore, it’s not surprising if one doesn’t know how to create a drop down list in Microsoft Excel. In this article, we will show you a step-by-step guide on how to make a drop down list in Excel.

How to Create A Drop Down List in Excel

In the meantime, one of the most used of Excel is that it helps to organize tasks, events, or data in an orderly manner. Many businesses and companies use the tool to keep things organized. The use of drop-down lists in cells helps businesses to work more efficiently in worksheets. The feature allows you to be able to sort items from a list that you create. You can use the drop-down list in cells to arrange data or items in a category you create.

To create a drop down list in excel, you need to have already installed an app on your device. Find out how to create a drop-down list on Windows, macOS, and the Web.

How to Create a Drop Down List in Excel on Windows

Data entry is more convenient and more accurate with the help of a drop-down list to set up a number of entries people can make in a call. Here is the following step:

  • First of all, you need to open your Microsoft Excel.
  • Then, in the new worksheet, create entries that you want to show in your drop-down list.
  • Next, choose the cell in the worksheet to set up the drop-down list where you want it.
  • Go to the Data icon located on the Ribbon and click Data Validation.
  • Then, go to the Settings tab, in the Allow box, select List.
  • Click in the Source box.
  • Check the Ignore Blank box if you want to approve people to leave the cell empty.
  • Also, click the In-cell dropdown checkbox.
  • Select the Input Message icon.
  • Next, select the Error Alert icon.

Finally, you can click OK, if you have completed the action of creating a drop-down list in Microsoft Excel.

How to Create a Drop Down List in Microsoft Excel on macOS

Here is the following step:

  • First of all, you need to create a list of valid entries for the drop-down.
  • Type in the entries on the worksheet whether in a single column or row.
  • Next, select the cells you want to create privacy for which will help to restrict data entry.
  • In the Data section, under Tools, select the option Data Validation or Validate.
  • Under the Settings section, in the Allow pop-up menu, click List.
  • Then, go to the Source box, and in your worksheet, select your list of valid entries.
  • Click Ok.

How to Make a Drop-down List in Excel on Web

Here is the following step:

  • First of all, you have to launch the Microsoft Excel web.
  • Then, in the new worksheet create an entry that you want to put in the drop-down list.
  • Next, select the Cell.
  • In the Data tab in the Ribbon, select Date Validation.
  • On the Settings tab, click List from the Allow box section.
  • Click in the Source box.
  • Then, click Ok.

In addition, once you have completely created your drop-down list, check it again to see that you create what you wanted. For instance, review if “change the column width and row height” shows all your entries.

Add or Remove Items From a Drop-down List

Most time you might want to add or remove items from a drop-down list even after creating your first drop-down list. Here is the following instruction below on how to add more items or delete items if you want to:

  • Navigate to the end of the list to add a new item.
  • Then, type in the new item.
  • However, if you want to remove or delete an item, you can select the item you want to delete and click Delete.

In addition, you can visit the Microsoft Support center to learn how to perform some actions like editing a drop-down list that’s based on a named range or editing a drop-down list based on a range of cells.


Please enter your comment!
Please enter your name here