Remove DropDown Arrow From One Column

XLML

Active Member
Joined
Aug 15, 2003
Messages
407
I opened a file that has a dropdown arrow in Cell C3 with no choices. I thought it could be removed by using Data-Filter-AutoFilter, but that doesn't work. Any ideas?

Thanks in advance,
XLML
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
It probably has a data validation attached to it. Go to Data|Validation, and make sure you're allowing Any Value.
 

Padawan

Active Member
Joined
Apr 9, 2002
Messages
392
Try this.
Select C3
Go to Data->Validation
Clear all (Button at the bottom)
 

XLML

Active Member
Joined
Aug 15, 2003
Messages
407

ADVERTISEMENT

I should have posted that I tested Data..Validation... Clear All before I posted. I still have the problem.

XLML
 

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
Are there any macros associated with the file? Post any you might suspect of being relevant to this problem.
 

XLML

Active Member
Joined
Aug 15, 2003
Messages
407

ADVERTISEMENT

Sorry ... There are no macros in the file.

XLML
 

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
After looking at the file, the only way I could remove it was using this macro:

Code:
Sub LoseObjects()

For Each Shape In Sheet1.Shapes
    Shape.Delete
Next Shape

End Sub

If you don't want to delete it, you can go to Tools|Options|View --> and select Hide Objects.

I have no idea how it got there, or even what it is, but it looks like it was just the arrow for a drop down box... the macro should solve your problem (if there aren't any legitimate objects on the sheet that you would want to keep...)
 

Caliche

Active Member
Joined
Mar 26, 2002
Messages
339
I had the same problem some days ago. Juan Pablo González helped my out with this post:

"Si, conozco un caso... es muy extraño. Se puede solucionar corriendo este macro

Sub RemoveDropdowns()
Dim shp As Shape

For Each shp In Sheet1.Shapes
shp.Delete
Next shp
End Sub

pero con cuidado, si hay celdas con comentarios, Excel explota !
_________________
Regards,

Juan Pablo González
MrExcel.com Consulting "


(But be carefull : if there are cells with comments, Excel crashs)
HTH.
 

XLML

Active Member
Joined
Aug 15, 2003
Messages
407
Thanks for all the help everyone. I used the macro to remove the arrow.

XLML
 

Forum statistics

Threads
1,147,508
Messages
5,741,568
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top