In today’s age, we come across several numerical and data tasks that need to be managed properly to carry out work efficiently. One of the reliable tools to create and save data is Excel. A drop-down list in Excel helps to quickly and accurately organize data. If you are looking for a guide on this, check out How to Create Drop Down List in Excel for a complete step-by-step method.
Method to create drop-down list
The method consists of the following steps:
Step:1
Go to Google and open the Excel. Make sure that you are logged in to Excel.
Step:2
Open the first result on Google
Step:3
Go to sign up.
Step:4
Click on the create new.
step: 5
Select the box.
Step:6
At the upper middle of the page, there is an option of data click on it.
Step:7
Now click on the data validation
Step:8
A page will open, click on the yes option
Step:9
Here you will enter the desired data, click on the allow option, and then select the desired.
Step:10
In the source option, insert different values that you want to keep and separate them with a comma.
Additionally, if you’re working in Google Docs and want to clean up your document, check out How to Delete a Page in Google Docs for a quick and easy guide. Stay with us till the end to learn it quickly.
Step:11
Then, click on the apply option.
Step:12
Now, manually add the values by clicking on the box
The list has successfully been uploaded.
That was only for a sample. You can make a drop-down list of your own choice.
Final words
The article has explored the simple and easy steps for How to Create Drop Down List in Excel. If you are a regular user of Excel and want to save data efficiently, then this article can prove helpful for you. In due time, if you are facing any difficulty, please leave it in our comment section.
