Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here’s how to create a drop-down list in Microsoft Excel.
Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet. Drop-down lists are perfect for several purposes, such as inputting information into a form.
Here’s how to create a drop-down list using Microsoft Excel on Windows and Mac.Create a drop-down list by manually entering data
There are a few ways to create a drop-down list on Excel. This specific method is the most straightforward and is particularly effective for a Microsoft Excel spreadsheet beginner and for lists that won’t require constant updates.
Step 1: Select the cell in the column where you want to input a drop-down list.
Step 2: Go to the Data tab and select the Data validation button or choose Data validation from the drop-down menu.
Step 3: Pick the Allow menu from the subsequent window that pops up and select List.
Step 4: Within the Source field, enter exactly what you want to be included in the drop-down list. Be sure to apply a comma after each list item.
Step 5: Select OK.
The cell you initially selected from step 1 will now have a functioning drop-down list consisting of all the information you entered in step 4.Create a drop-down list by selecting a range of cells
The most common way to create a drop-down list in Excel with multiple selections is by using a range, which relies on using data from other cells.
Step 1: Choose a column where you want to include the data that will be shown in the associated drop-down list.
