How to Remove Drop Down Arrow in Excel (6 Methods)

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.

Using Filter to Remove Drop-Down Arrow from Table

📌 Steps:

  • Firstly, select the range of the cells that you want to remove the arrow.
  • Next, select the Filter option on the Data tab.

Using Filter to Remove Drop-Down Arrow from Table

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.

Keyboard Shortcut to Remove Drop-Down Arrow

Finally, you will get the desired output that contains no drop down icon like the following:

Keyboard Shortcut to Remove Drop-Down Arrow


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.

Data Validation Feature to Remove Drop-Down Arrow in Excel

  • 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.

Data Validation Feature to Remove Drop-Down Arrow in Excel

  • When the Data Validation box appears, click on Clear All and click on OK.

Data Validation Feature to Remove Drop-Down Arrow in Excel

  • 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


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.

Using Go to Special Option

📌 Steps:

  • Firstly, press Ctrl+G, as a result, the Go To dialogue box will appear. Click on Special.

Using Go to Special Option

  • When the Go To Special dialogue box appears, select Data Validation.

  • Next, go to the Data tab and click on the Data Validation option.

Using Go to Special 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.

Using Go to Special Option

  • Finally, you will get the desired output that contains no drop down icon like the following:

Using Go to Special Option


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.

Using Paste Special Command to Remove Drop-Down Arrow

  • 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.

Using Paste Special Command to Remove Drop-Down Arrow

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

VBA Codes to Remove Drop-Down Arrow

  • 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.

VBA Codes to Remove Drop-Down Arrow

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!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo