ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unknown object in cell (https://www.excelbanter.com/excel-discussion-misc-queries/45380-unknown-object-cell.html)

sonjaredmoon

unknown object in cell
 
a black and gray object like a radio button appeared in the upper left corner
of a cell after a cut/paste action. there was a radio button in the original
document next to the text I was copying. when you click on it, the toolbars
go gray, and the object changes like a radio button, but nothing else appears
to happen. nothing happens on right-click. this object obscures part of the
text in this cell.
what is it and how do I get rid of it?

Anne Troy

If it's the only object, you can use Edit--Go to--Special--Objects and
hit Delete.
Otherwise, use the selector tool on the drawing toolbar or design view from
the Control toolbox.
Ref:
http://www.officearticles.com/misc/d...oft_office.htm
************
Anne Troy
www.OfficeArticles.com

"sonjaredmoon" wrote in message
...
a black and gray object like a radio button appeared in the upper left
corner
of a cell after a cut/paste action. there was a radio button in the
original
document next to the text I was copying. when you click on it, the
toolbars
go gray, and the object changes like a radio button, but nothing else
appears
to happen. nothing happens on right-click. this object obscures part of
the
text in this cell.
what is it and how do I get rid of it?




sonjaredmoon

none of these suggestions worked - it appears that it is not an "object" as
excel defines an object. for instance when I tried "Edit--Go
to--Special--Objects and
hit Delete" excel told me there were no obects in the document.
could it be some sort of indicator like the little red triangle that appears
when a cell has a comment attached to it?

-redmoon

"Anne Troy" wrote:

If it's the only object, you can use Edit--Go to--Special--Objects and
hit Delete.
Otherwise, use the selector tool on the drawing toolbar or design view from
the Control toolbox.
Ref:
http://www.officearticles.com/misc/d...oft_office.htm
************
Anne Troy
www.OfficeArticles.com

"sonjaredmoon" wrote in message
...
a black and gray object like a radio button appeared in the upper left
corner
of a cell after a cut/paste action. there was a radio button in the
original
document next to the text I was copying. when you click on it, the
toolbars
go gray, and the object changes like a radio button, but nothing else
appears
to happen. nothing happens on right-click. this object obscures part of
the
text in this cell.
what is it and how do I get rid of it?





CyberTaz

Where did you copy _from_, not a web page by any chance? If so, you got a
special characte pasted in along with the text.

Try Rt+clicking the character in the cell (press ESC if necessary to close
the popup menu, don't click away to close it). You should see little round
'handles' at each of the 4 corners of the imaginary box that surrounds the
character. Press 'Delete' and it should go away.

HTH |:)

"sonjaredmoon" wrote:

none of these suggestions worked - it appears that it is not an "object" as
excel defines an object. for instance when I tried "Edit--Go
to--Special--Objects and
hit Delete" excel told me there were no obects in the document.
could it be some sort of indicator like the little red triangle that appears
when a cell has a comment attached to it?

-redmoon

"Anne Troy" wrote:

If it's the only object, you can use Edit--Go to--Special--Objects and
hit Delete.
Otherwise, use the selector tool on the drawing toolbar or design view from
the Control toolbox.
Ref:
http://www.officearticles.com/misc/d...oft_office.htm
************
Anne Troy
www.OfficeArticles.com

"sonjaredmoon" wrote in message
...
a black and gray object like a radio button appeared in the upper left
corner
of a cell after a cut/paste action. there was a radio button in the
original
document next to the text I was copying. when you click on it, the
toolbars
go gray, and the object changes like a radio button, but nothing else
appears
to happen. nothing happens on right-click. this object obscures part of
the
text in this cell.
what is it and how do I get rid of it?





sonjaredmoon

I got rid of it by cutting and pasting the data into a new workbook. I think
that's a pretty barbaric way to solve a problem tho, so I'd still like
suggestions as to what this mysterious thing is...

"sonjaredmoon" wrote:

none of these suggestions worked - it appears that it is not an "object" as
excel defines an object.


sonjaredmoon

yes it was a web page, and great suggestion. but right clicking on the
"object" did nothing, no pop up menus or grips, or anything. deleting the
cell, the row, or the column did not remove the thing either- only cutting
and pasting the data into a new spreadsheet. I'm beginning to suspect this is
just a graphics error - some kind of ghost image.

"CyberTaz" wrote:

Where did you copy _from_, not a web page by any chance? If so, you got a
special characte pasted in along with the text.

Try Rt+clicking the character in the cell (press ESC if necessary to close
the popup menu, don't click away to close it). You should see little round
'handles' at each of the 4 corners of the imaginary box that surrounds the
character. Press 'Delete' and it should go away.

HTH |:)

"sonjaredmoon" wrote:

none of these suggestions worked - it appears that it is not an "object" as
excel defines an object. for instance when I tried "Edit--Go
to--Special--Objects and
hit Delete" excel told me there were no obects in the document.
could it be some sort of indicator like the little red triangle that appears
when a cell has a comment attached to it?

-redmoon

"Anne Troy" wrote:

If it's the only object, you can use Edit--Go to--Special--Objects and
hit Delete.
Otherwise, use the selector tool on the drawing toolbar or design view from
the Control toolbox.
Ref:
http://www.officearticles.com/misc/d...oft_office.htm
************
Anne Troy
www.OfficeArticles.com

"sonjaredmoon" wrote in message
...
a black and gray object like a radio button appeared in the upper left
corner
of a cell after a cut/paste action. there was a radio button in the
original
document next to the text I was copying. when you click on it, the
toolbars
go gray, and the object changes like a radio button, but nothing else
appears
to happen. nothing happens on right-click. this object obscures part of
the
text in this cell.
what is it and how do I get rid of it?





All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com