Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird: inside of a cell I have a small box or cell I can't delete.
I have one cell in the middle of my spread sheet and it has in it a small box
or cell in it. It looks like the boxes you enter text into when filling out a form on a website. It is smaller than the cell itself and I can actually click the mouse inside it and type 5-10 characters. I tried deleting the cell, the line, the column and it just shifts around the sheet. I tried right clicking on it to cut it out like an image but it doesn't work. Right clicking inside the box doesn't give you an options menu. I have no idea what it is. maybe I accidentally entered a shortcut code for some HTML insert, but usually anything like that would still be able to show an options menu when right clicked. Has anyone seen this before? Can you tell me what it is and how to get rid of it please? |
#2
|
|||
|
|||
Answer: Weird: inside of a cell I have a small box or cell I can't delete.
It sounds like you may have accidentally inserted a comment box into the cell. Here's how you can remove it:
If that doesn't work, try these steps:
If neither of these methods work, it's possible that the small box is actually a part of the cell's formatting. In that case, try these steps:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird: inside of a cell I have a small box or cell I can't delete.
Try showing the Control toolbox toolbar.
In xl2003 menus: View|toolbars and check that option. Then click on the Design Mode icon on that toolbar. Then try selecting that object and hitting the delete key on the keyboard. Then click on the design mode icon once more to get back to normal. ACECOWBOY wrote: I have one cell in the middle of my spread sheet and it has in it a small box or cell in it. It looks like the boxes you enter text into when filling out a form on a website. It is smaller than the cell itself and I can actually click the mouse inside it and type 5-10 characters. I tried deleting the cell, the line, the column and it just shifts around the sheet. I tried right clicking on it to cut it out like an image but it doesn't work. Right clicking inside the box doesn't give you an options menu. I have no idea what it is. maybe I accidentally entered a shortcut code for some HTML insert, but usually anything like that would still be able to show an options menu when right clicked. Has anyone seen this before? Can you tell me what it is and how to get rid of it please? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird: inside of a cell I have a small box or cell I can't delete.
Press F5 and select Special and select Objects. If this does not clear
everything then try the below --From the sheet hit the keys (Alt + F11) to launch VBE (Visual Basic Editor) --Hit (Ctrl + G) so that Immediate window will be enabled --Paste the below line including ? to the immediate window and enter (Make sure you press Enter after placing the cursor end of the line) Activesheet.DrawingObjects.delete If this post helps click Yes --------------- Jacob Skaria "ACECOWBOY" wrote: I have one cell in the middle of my spread sheet and it has in it a small box or cell in it. It looks like the boxes you enter text into when filling out a form on a website. It is smaller than the cell itself and I can actually click the mouse inside it and type 5-10 characters. I tried deleting the cell, the line, the column and it just shifts around the sheet. I tried right clicking on it to cut it out like an image but it doesn't work. Right clicking inside the box doesn't give you an options menu. I have no idea what it is. maybe I accidentally entered a shortcut code for some HTML insert, but usually anything like that would still be able to show an options menu when right clicked. Has anyone seen this before? Can you tell me what it is and how to get rid of it please? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird: inside of a cell I have a small box or cell I can't delete.
I may also be an active x control - If you go the developer tab (you can
enable in the excel options section when you click the offcie button in excel 2007) and enter desgin mode you may be able to then select and delete the object -- If this helps, please remember to click yes. "ACECOWBOY" wrote: I have one cell in the middle of my spread sheet and it has in it a small box or cell in it. It looks like the boxes you enter text into when filling out a form on a website. It is smaller than the cell itself and I can actually click the mouse inside it and type 5-10 characters. I tried deleting the cell, the line, the column and it just shifts around the sheet. I tried right clicking on it to cut it out like an image but it doesn't work. Right clicking inside the box doesn't give you an options menu. I have no idea what it is. maybe I accidentally entered a shortcut code for some HTML insert, but usually anything like that would still be able to show an options menu when right clicked. Has anyone seen this before? Can you tell me what it is and how to get rid of it please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering digits in a cell with numbers already inside cell | Excel Worksheet Functions | |||
Cell Reference Weird Format | Excel Discussion (Misc queries) | |||
how do i set up a cell to autoformat to the text inside the cell? | Excel Discussion (Misc queries) | |||
Weird characters at beginning of cell | Excel Discussion (Misc queries) | |||
Weird wrapping in cell | Excel Worksheet Functions |