Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
Best way to inser file property into and excel sheet (cell) | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions |