+5 votes
49 views
Make Dropdown List in Excel

in Office by (551k points)
reopened | 49 views

1 Answer

+3 votes
Best answer

How to create dropdown list Excel

Excel is one of the most versatile applications for working with data of various types (date, text, numbers) and in large quantities thanks to its various functions and formulas that have been integrated to deliver precise results, but in addition to this there are some options to manage the information and one of these is to make use of drop-down lists which allow the user to select an answer from a menu of options without altering the result, it is ideal for surveys or exams, TechnoWikis will explain how to create a drop-down list in Excel in a simple way ..

 

By creating a drop-down list in Excel we can include information related to options or lists to choose different elements. This can help us to show and hide information and thus, in the same space, propose different options. That is why we are going to see how to make this checklist and thus be able to have a list of options in Excel.

 

 

To stay up to date, remember to subscribe to our YouTube channel!
SUBSCRIBE ON YOUTUBE

 

 

How to create dropdown list Excel

 

Step 1

Open Excel and check the data to use:

 

image

 

Step 2

Select the cell where the drop-down list will be, then go to the "Data" menu and there click on "Data validation":

 

image

 

Step 3

The following will open:

 

image

 

Step 4

Under "Allow" select "List":

 

image

 

step 5

Select the data to display in "Origin":

 

image

 

step 6

We can see the selected range. Apply the changes.

 

image

 

step 7

We will see the arrow in the cell that has been selected:

 

image

 

step 8

We click on the drop-down arrow and it is possible to choose one of the available values:

 

image

 

step 9

We click on the desired value:

 

image

 

step 10

In case of manually entering a wrong value we will receive a notification alerting:

 

image

 

step 11

Drag this cell if you want the list to be available in more places:

 

 

image

 

step 12

There we will be able to select the desired values ​​from the drop-down list:

 

image

 

step 13

It is possible to add more data to the list:

 

image

 

step 14

Once the data is entered, open "Data validation":

 

image

 

step 15

Set the data source: Applies the changes.

 

 

image

 

step 16

Now that new data will be available in the drop-down list:

 

image

 

Note
Drag the cell to the others to have the update.

 

 

step 17

You can change a name on the source directly:

 

image

 

step 18

This will automatically update in the dropdown list:

 

image

 

step 19

Open "Data validation", it is possible to enter an input message for the user to orient:

 

image

 

step 20

It is also possible to enter an error message to customize the user experience:

 

image

 

step 21

In the cell of the drop-down list we will see the message:

 

image

 

step 22

In case of entering wrong text we will see the defined message:

 

image

 

Step 23

To clear the dropdown list open "Data Validation":

 

Click on "Delete all":

 

image

 

step 24

We see how the parameters change, apply the changes.

 

image

 

step 25

We validate that the list will not be available.

 

 

image

 

This is the easy way to create a dropdown list in Excel and be able to better manage the supplied data..

 


by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Dec 19, 2022 in Office by backtothefuture (551k points) | 43 views
+4 votes
1 answer
asked May 24, 2020 in Help by backtothefuture (551k points) | 327 views
+3 votes
1 answer
asked Nov 14, 2022 in Office by backtothefuture (551k points) | 57 views
+4 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (551k points) | 330 views
+3 votes
1 answer
asked Sep 19, 2023 in Office by backtothefuture (551k points) | 28 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users