Forum Discussion

Copper Contributor

Oct 26, 2018

Solved

superimpossed field that I cannot remove

If someone can help me, I'd appreciate it. I have a superimpossed field or item that does not clear. I try to erase, delete, cut and I cannot figure out how to get rid of it. If I click on it, I ca...

SergeiBaklan
Oct 26, 2018
Hi Patricia,

You have lot of boxes one under one. To delete on ribbon Home->Find & Select-Go to Special

Here select Objects, Ok

Now all your boxes are to be selected

Click Del

Diamond Contributor

Oct 26, 2018

Hi Angela,

How did you try to delete it? Try to click on the border of that box, most probably you'll see

press Del then

Copper Contributor

Oct 26, 2018

Dear Sergei,

Thank you for replying.

The field does not respond to anything other than opening a second box to insert a check mark. I can write text on it, it has a live cursor, but I cannot eliminate it. When I get to the edge an arrow or a double lined cross opens, but I cannot get rid of it. I have tried Del, I have tried right-click / delete,

I have tried moving it with drag and drop (does not move)

Attached is a capture of this thing with the check mark and writing on it.

SergeiBaklan
Diamond Contributor
Oct 26, 2018
Angela, could you please make a copy of your file, delete all information (or at least sensitive one) and attach that file to your post here
- Angela Pedraza
  Copper Contributor
  Oct 26, 2018
  Dear Sergei,
  I figured out how to copy the portion where it is in a file to upload.
  If you can tell me what the problem is, I'll learn to not do that again. I've struggled with this since last night.
  THANK YOU!
  Patricia
  Excel help.xlsx23 KB
  - SergeiBaklan
    Diamond Contributor
    Oct 26, 2018
    Important. Forgot to say such way you will delete all objects at once in your sheet. You have lot of them like this
    
    However, if you'd like to keep some object(s) which you will use, when delete them one by one. On ribbon in Developer tab activate Design mode
    
    click on object and Del. Repeat with each of them which you'd like to delete.
- Angela Pedraza
  Copper Contributor
  Oct 26, 2018
  Dear Sergei,
  It is a rather large workbook file of terminology, with many worksheets. As I tried copying this specific worksheet only to send to you, this ghostly field disappeared in the new worksheet, it does not copy. Would you want me to send the whole file?
  For resolution purposes, I guess I can copy the whole worksheet to a new one given that the field disappeared like that.
  If you are part of the Excel technical team wanting to look into this, I can send you the whole file.
  Patricia

Resources