If you are looking for some special tricks to remove the drop down arrow in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to remove the drop down arrow in Excel. In this article, we’ll discuss six methods to remove the drop down arrow in excel. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
6 Methods to Remove Drop Down Arrow in Excel
We will use six effective and tricky methods to remove the drop down arrow in Excel in the following section. Here, we demonstrate the first two methods (filter feature, keyboard shortcut) to remove the drop down arrow from the formatting table. We use the remaining four methods to remove the drop down arrow from data validation. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.
1. Using Filter to Remove Drop Down Arrow from Table
Here, we have a dataset of the Gross Revenue data table. If you want to remove the drop down arrow, you have to follow the following steps.
📌 Steps:
- Firstly, select the range of the cells that you want to remove the arrow.
- Next, select the Filter option on the Data tab.
Finally, you will get the desired output that contains no drop down icon like the following:
2. Applying Keyboard Shortcut
Use a keyboard shortcut to remove the drop-down arrow. It is the fastest and simplest method of removing the drop down arrow. To do this, at first, you have to select the range of the cell that you want to remove the arrow. Then, type ALT+A+T. Press Enter.
Finally, you will get the desired output that contains no drop down icon like the following:
3. Data Validation Feature to Remove Drop Down Arrow in Excel
Now, we are going to demonstrate the most used method to remove the drop down arrow in Excel. To do this, you have to follow the following steps.
📌 Steps:
- Firstly, select the range of the cell that you want to remove the arrow.
- Next, go to the Data tab and click on the Data Validation option.
- Afterward, a dialogue will appear as it contains data validation. Click on OK.
- When the Data Validation box appears, click on Clear All and click on OK.
- Finally, you will get the desired output that contains no drop down icon like the following:
Read More: How to Remove Data Validation Restrictions in Excel (3 Ways)
Similar Readings
- How to Remove #DIV/0! Error in Excel (5 Methods)
- Remove Panes in Excel (4 Methods)
- How to Remove Header and Footer in Excel (6 Methods)
- Remove Comments in Excel (7 Quick Methods)
- How to Remove Encryption from Excel (2 Methods)
4. Utilizing ‘Go To Special’ Option
Here, we are going to show you another method to remove the drop down arrow using Go To Special feature. You have to follow the following steps to do this.
📌 Steps:
- Firstly, press Ctrl+G, as a result, the Go To dialogue box will appear. Click on Special.
- When the Go To Special dialogue box appears, select Data Validation.
- Next, go to the Data tab and click on the Data Validation option.
- Afterward, a dialogue will appear as it contains data validation. Click on OK.
- When the Data Validation box appears, click on Clear All and click on OK.
- Finally, you will get the desired output that contains no drop down icon like the following:
5. Use of Paste Special Command
Using paste special command to remove the drop down arrow is another effective method. You have to follow the following steps.
📌 Steps:
- Firstly, you have to copy an empty cell.
- Afterward, select the range of cells containing data validation.
- Next, press Ctrl+Alt+V. When the Paste Special dialog box appears, select Validation and click on OK.
Finally, you will get the desired output that contains no drop down icon like the following:
6. VBA Codes to Remove Drop Down Arrow
By using a simple code, you will be able to remove the drop down arrow. You have to follow the following steps.
📌 Steps:
- Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert, select
- Next, you have to type the following code
Sub Remove_Drop_Down_Arrow()
Range("B5:D10").Validation.Delete
End Sub
- After that, close the Visual Basic window And press ALT+F8.
- When the Macro dialogue box opens, Select Remove_Drop_Down_Arrow in the Macro name. Press Run.
Finally, you will get the desired output that contains no drop down icon like the following:
Conclusion
That’s the end of today’s session. I strongly believe that from now you may remove the drop down arrow in Excel. If you have any queries or recommendations, please share them in the comments section below.
Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!