Remove Drop Down list in Excel
Hello, everybody, today we are going to talk about how to Remove Drop Down List and we hope that you might be liking our tutorial and learning from it. Anyways, in this tutorial of Excel Superstar, we are going to answer a query. Our Excel experts received a many E-mails on how to Remove Drop down list? So, we have decided to answer it. In one of our tutorial we showed how to create a drop-down list, technically it is termed as Data Validation list. So, let’s have a summary of it or else you can have recap of it
For creating a data validation list following steps should be followed:
- Select a cell in which you want to create a drop down list
- Click on ‘data’ tab from ribbon
- In “data” tab you will find “Data Validation” button click on it
- A dialogue box will appear, In that box, the first tab will be “Setting” in that you will find “Validation Criteria”
- Now, in “validation criteria” you will find a Term “Allow” which is by default set to “Any value.” Which means the user can enter any value in that cell it can be a number or text.
- Term “Allow” has a drop down list where you find a different If a user select a “List” option from the drop down list, so the cell will only accept the value which is mention in the list
- After selecting “List” option, you will find a new term called as “Source” with a text box which is placed below the “Allow” term. In this text, box user has to enter the drop down list menu or value.
- After, the Completion of this process if a user enters any other value rather than the value mentioned in the list, it will not accept the value and will give an error.
- By Carrying out this process, you can create a desired drop down list.
Now, A question which was asked to our Excel Superstar experts was although, we have created a drop down list. But, how to remove it? For removing drop down list, there are two methods the first one is reverse the whole process that has been carried out for creating a “drop down list” that is to be as follows:
- Select “Data” tab from ribbon
- Click on “Data Validation ”
- From the “Validation Criteria” set “Allow” term value to default which is “Any value ”
This process will remove the drop down list. But it is quite tedious and lengthy process. However, the second method which you will be learning is quite tricky and easy just it will take two steps to remove Drop down the list. Follow this magical steps to remove drop down list
- Select a blank cell and “copy” it
- “Paste” it into the drop down list cell
Cheers, You are done! Your drop down list has been removed. Isn’t it is a magical step? Don’t be amazed at more cool tricks Subscribe to our YouTube channel and Like our Facebook page it also a time to say, Hi on twitter! We appreciate each every feedback from our user. Excel Superstar it the Leading Excel Online training company. For the complete online excel tutorial in Hindi and English. Buy our Excel Course at a half price and become Excel expert.