Remove DropDown Arrow From One Column

[XLML]

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

 

[yee388]

It probably has a data validation attached to it. Go to Data|Validation, and make sure you're allowing Any Value.

 

[Smitty]

Try Data-->Validation-->Clear All.

HTH,

Smitty

 

[Padawan]

Try this.
Select C3
Go to Data->Validation
Clear all (Button at the bottom)

 

[XLML]

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

XLML

 

[yee388]

Are there any macros associated with the file? Post any you might suspect of being relevant to this problem.

 

[XLML]

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

XLML

 

[yee388]

After looking at the file, the only way I could remove it was using this macro:

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]

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]

Thanks for all the help everyone. I used the macro to remove the arrow.

XLML