Strange looking cell in Excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
 
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
Click to expand...
 
Back
Top