Can't clear cell of "object" copied/ pasted from web page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 25 Feb 2008 18:44 GMT

I pasted some text from a web page into a cell in a speadsheet. But when I
copied from the web page I must have copied a check box that was near the
text, so that got pasted as well. Thing is, I can't get rid of it. I've
tried to clear the contents of the cell, but only the text in the cell goes
away. Even deleting the entire line or column only gets rid of the text.
The check box is "stuck" in the same spot on the sheet. I've looked at the
Format Cell function but I can't see any way to address this issue.

Any ideas? TIA

Reply to this Message

Dave Peterson - 25 Feb 2008 19:44 GMT

Show the control toolbox toolbar.

In xl2003:
View|Toolbars|check control toolbox
Click on the Design mode icon
Try to delete the object.
click on the design mode icon to get back to normal
close that toolbar.

> I pasted some text from a web page into a cell in a speadsheet. But when I
> copied from the web page I must have copied a check box that was near the
[quoted text clipped - 5 lines]
>
> Any ideas? TIA

Signature

Dave Peterson

Reply to this Message

Dave - 25 Feb 2008 19:59 GMT

That did it. Thanks, Dave.

> Show the control toolbox toolbar.
>
[quoted text clipped - 17 lines]
>>
>> Any ideas? TIA

Reply to this Message