Maybe it's only a display thing.

Edit|goto special
Check Objects
and then hit the delete key.

If that doesn't work, maybe you could run a little macro:

Option Explicit
Sub testme02()
Dim myShape As Shape
With ActiveSheet
.AutoFilterMode = False
For Each myShape In .Shapes
myShape.Delete
Next myShape
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John wrote:

Okay sometime ago I inserted some autoshapes into cells on a spreadsheet. The
autoshapes have now disappeared from the sheet but they show up in preview
and print on the paper. But I want to make them all go away. But on the
spreadsheet I can't get to them to delete them!! Help..this is driving me
crazy! Anyone have any suggestions??
Thanks
John

--

Dave Peterson