Strange looking cell in Excel sheet
 

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
--
Hango

Strange looking cell in Excel sheet
 

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.

Hango wrote:

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
--
Hango

--

Dave Peterson

Strange looking cell in Excel sheet
 

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
--
Hango



"Dave Peterson" wrote:

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.

Hango wrote:

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
--
Hango

--

Dave Peterson

Strange looking cell in Excel sheet
 

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.

Hango wrote:

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
--
Hango

"Dave Peterson" wrote:

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.

Hango wrote:

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
--
Hango

--

Dave Peterson


--

Dave Peterson