LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 09:16 AM
Referencing cell in another sheet yields null? [email protected] Excel Worksheet Functions 4 November 18th 05 01:11 AM
Best way to inser file property into and excel sheet (cell) Luc Excel Discussion (Misc queries) 3 July 5th 05 08:36 PM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
How do I change the Cell color automatically in an Excel sheet wh. stump Excel Worksheet Functions 2 January 6th 05 02:14 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"