Strange looking cell in Excel sheet

G

Guest

At times, I get this strange looking cell in the middle of a worksheet. It
overlaps into the middle of three adjacent cells: to the right, lower corner
right and the bottom one and has a fat line on the top and on the left.
Cannot erase, or delete it, neither through highlighting and clicking
"delete", nor through trying to make it a normal cell by highlighting it with
the format (brush) ikon. What is the purpose of this formatting and how does
it appear? How do get rid of it? Thanks
 
D

Dave Peterson

Maybe it's a shape.

Show the control toolbox toolbar.
click on the design mode icon
rightclick on it
hit the delete button
click on the design mode icon to get back to normal.
 
G

Guest

Thanks Dave.
I was able to delete it, but not with the "delete" key. After right clicking
on the design icon, in the context menu there is a command "cut" and this is
the one that worked. I am still curious how this came to existance and what
the purpose of this shaped cell is.
Greetings
 
D

Dave Peterson

I bet you could have used the design mode icon, selected the shape and hit the
delete key.

And are you missing any controls--comboboxes, commandbuttons....

Maybe the shape was "squished" when the rows that held it were deleted.
Thanks Dave.
I was able to delete it, but not with the "delete" key. After right clicking
on the design icon, in the context menu there is a command "cut" and this is
the one that worked. I am still curious how this came to existance and what
the purpose of this shaped cell is.
Greetings
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top