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.

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:

Read More: How to Remove Value in Excel

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 Panes in Excel

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:

Read More: How to Remove Outliers in Excel

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:

Read More: How to Remove Dotted Lines in Excel

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:

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

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

• How to Remove Compatibility Mode in Excel
• How to Remove Numbers from a Cell in Excel
• How to Remove HTML Tags from Text in Excel
• How to Remove 0 from Excel

<< Go Back To Data Cleaning in Excel | Learn Excel