How to Create a Drop Down List in Excel

Drop down lists can be a powerful tool for creating user-friendly spreadsheets in Microsoft Excel. A drop-down list allows you to choose a value from a predefined set of options, making data entry faster and reducing the risk of errors. In this article, we’ll walk you through a step-by-step guide on how to create a drop down list in Excel.

Table of Contents

Step 1: Create a List

The first step in creating a drop-down list is to create a list of the options you want to include. This list can be located anywhere in your workbook, but creating it on a separate sheet is usually best. In this example, we’ll create a list of fruits on a sheet called “Fruit List.”

Create a List
Create a List

Step 2: Select the Cell

Next, select the cell where you want the drop-down list to appear. In this example, we’ll select cell B2.

Select the Cell

Step 3: Go to Data Validation

With the cell selected, go to the “Data” tab in the top menu and click “Data Validation” in the “Data Tools” section.

Go to Data Validation

Step 4: Set Validation Criteria

In the “Data Validation” dialog box, select “List” from the “Allow” drop-down menu. In the “Source” field, enter the range of cells that contain your list of options. In this example, we’ll enter “=FruitList!A1:A4”. This tells Excel to use the values in cells A1 through A4 on the “Fruit List” sheet as the options for the drop-down list.

Set Validation Criteria

Step 5: Additional Settings

You can also set additional settings for your drop-down list, such as allowing blank cells or limiting the number of characters in the cell. Once satisfied with the settings, click “OK” to create the drop-down list.

Additional Settings

Step 6: Test the Drop-Down List

Now you can test your drop-down list by clicking on the cell with the drop-down arrow. You should see the list of options that you entered in the “Source” field. Select one of the options, and it will be entered into the cell.

Test the Drop Down List

Step 7: Editing the List

If you need to edit the list of options for the drop-down list, go back to the “Data Validation” dialog box and update the “Source” field with the new range of cells.

Drop Down List in Excel Editing the List

In conclusion, creating a drop-down list in Excel is a simple and effective way to improve the usability and accuracy of your spreadsheets. By following these simple steps, you can create a drop-down list that will save time and reduce the risk of errors in your data entry. You can buy a new Windows 10 from Indigo Software and enhance the security of your data. In the server 2019 standard license, you can access the new features of Excel spreadsheets and simplify your daily tasks.

I could have bought Office 2021 from another company cheaper but didn't so glad I paid more had issues with download and the support from Joe and Jenna was awesome. You get what u pay for so spend the extra money and go... with Indigo. I've used multiple times and they have never let me down.read more
Herbert CumbaaHerbert Cumbaa
15:55 26 Jul 22
Outstanding! Fair Price for Product! (Office Professional Plus 2016) Received Install Codes Immediately after Purchase! Processed Perfectly with Microsoft! Wanted Legit Software for Our Church! Will Use Again!... A+A+A+A+A+A+A+A+A+A+A+read more
Allan DrakeAllan Drake
20:51 16 Jul 22
Asked for two activations for office 2019 professional I bought two times. Microsoft says since I updated to win 11 the code provided is not a good code on either computer. Indigo sent me both replacement codes. I... also sent in a form on your website with my phone number.read more
Bob SBob S
14:13 20 Jun 22
I purchased MS Office 2019 for my new computer in 2021. The Install went well and all was good. A little over a year later Outlook stopped being able to sign into the Comcast email. Talking to Comcast tech after several... different trials we found by deleting the Comcast account and reinstalling it fixed the problem. About a month later the problem happen again. The delete and recreate the account trick did not work. Comcast indicated it was a MS Outlook problem since my iPhone that uses the same interface and the webmail portal all worked with the account. I then contacted Indigo about the issue. I got an email the next day asking for the order #. A few days later a email with YouTube video links on how to setup the Office software. I replied with a second more in depth description of what had been tried to resolve the issue. I have not heard from them in a week now. I can't imagine someone dealing with this lack of responce if their business depended upon it. Fortunetly for me, it is just for home use. The problem may not be MS Outlook, but you have to be able to get the support / knowledgebase to work thru to the solution.Edit: As soon as I checked my email, Indego had responded with a proceedure to reinstall Office and make sure no other office products were installed. It worked and Office is resyncing with the email account now.read more
Sidney RuetzSidney Ruetz
21:03 19 May 22
Best software purchasing experience bar none. Excellent prices and installation was painless and flawless. I needed both Windows 10 and Microsoft office. I saved a lot of money. You can't go wrong here!!!
Dito DalawaDito Dalawa
15:15 24 Dec 21
Indigo Software
4.9
431 reviews
powered by Google
js_loader