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
Open Excel and check the data to use:
Select the cell where the drop-down list will be, then go to the "Data" menu and there click on "Data validation":
The following will open:
Under "Allow" select "List":
Select the data to display in "Origin":
We can see the selected range. Apply the changes.
We will see the arrow in the cell that has been selected:
We click on the drop-down arrow and it is possible to choose one of the available values:
We click on the desired value:
In case of manually entering a wrong value we will receive a notification alerting:
Drag this cell if you want the list to be available in more places:
There we will be able to select the desired values from the drop-down list:
It is possible to add more data to the list:
Once the data is entered, open "Data validation":
Set the data source: Applies the changes.
Now that new data will be available in the drop-down list:
Drag the cell to the others to have the update.
You can change a name on the source directly:
This will automatically update in the dropdown list:
Open "Data validation", it is possible to enter an input message for the user to orient:
It is also possible to enter an error message to customize the user experience:
In the cell of the drop-down list we will see the message:
In case of entering wrong text we will see the defined message:
To clear the dropdown list open "Data Validation":
Click on "Delete all":
We see how the parameters change, apply the changes.
We validate that the list will not be available.
This is the easy way to create a dropdown list in Excel and be able to better manage the supplied data..