Creating A Drop-Down List In Excel In Just 7 Easy Steps

handsome man working in the corner | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop-down list multiple selection | Featured

Creating a drop-down list in Excel allows users to easily input data entries. This will also come in handy if you need to organize items by category or if you need a drop-down list selection. Instead of typing a single entry for every cell, you can just select from the options already listed. We’ve created an efficient 7-step guide to creating a drop-down list in Excel.

Creating a Drop-Down List in Excel: An Easy Guide

Step 1: Open a New Sheet in Excel

To start, open a new sheet in Excel.

Step 2: Create the Lists of Items You Will Input in Another Blank Document

Open a blank document either on your Notepad or Microsoft Word and list down the items you will input. This will serve as your reference, especially if you will input multiple items. When you list down your items, make sure each item is separated by a comma.

Step 3: Go to Excel and Select the Cell for Your Drop-Down List

Step 3 | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop-down list multiple selection

Select the cell where you wish to add your drop-down list. You can also select several cells or select an entire row or column.

Step 4: Go to the “Data” Tab

Step 4 | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop down list with color

Go to the “Data” tab then select “Data Validation.” You will then see a pop-up dialog box.

Step 5: Click “Settings” then Go to “Allow” Category

Step 5 | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop down list with checkboxes

Click the drop-down menu arrow then select “List.” After selecting”List,” proceed to the “Source” category.

Step 6: Copy and Paste the Items in the “Source” Category

Step 6 | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop down list with checkboxes

Copy the items you listed in the separate document then paste it in the “Source” box. You can also enter items one by one if you will only put a couple of them. Also, don’t forget to separate your items with a comma.

Step 7: Click “OK”

Step 7 | Creating A Drop-Down List In Excel In Just Easy Steps | creating a drop-down list in excel | excel drop down list with color

Lastly, click “OK.” But before clicking, make sure the boxes for the “Ignore blank” and “In-cell dropdown” are both checked.

Creating a drop-down list gives a user the ability to choose from the options you’ve provided. Take note though that putting an entry that is not on the list of options will make Excel invalidate it. The good thing about having drop-down lists is that it buys you more time when modifying the sheet. You can also explore other options when it comes to drop-down lists such as creating an Excel drop-down list with color or an Excel drop-down list with checkboxes.

Are there other ways you can recommend creating a drop-down list in Excel? Share your suggestions in the comments section below.

Up Next: Excel Dates | How to Format Dates in Excel