If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can't delete a cell content in excel
I can't delete several cells content in Excel. When I double click on the
cell, it shows it as empty, but the words are still there when I move to another cell. I just want to delete the information as it's right in the middle of my worksheet. Please help me. |
#2
|
|||
|
|||
Think the text may have been formatted as:
Horizontal: Centre across selection (under Format Cells Alignment tab Text alignment) Try sleuthing on a couple of cells just to the left of where it displays Alternatively, select the entire row, then Click Format Cells Alignment tab Text alignment Set Horizontal to : Left (IIndent) OK Recheck the row, the offending text should be in its own cell -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "Mark B" Mark wrote in message ... I can't delete several cells content in Excel. When I double click on the cell, it shows it as empty, but the words are still there when I move to another cell. I just want to delete the information as it's right in the middle of my worksheet. Please help me. |
#3
|
|||
|
|||
Just single click the cell and then hit delete key.
"Max" wrote: Think the text may have been formatted as: Horizontal: Centre across selection (under Format Cells Alignment tab Text alignment) Try sleuthing on a couple of cells just to the left of where it displays Alternatively, select the entire row, then Click Format Cells Alignment tab Text alignment Set Horizontal to : Left (IIndent) OK Recheck the row, the offending text should be in its own cell -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "Mark B" Mark wrote in message ... I can't delete several cells content in Excel. When I double click on the cell, it shows it as empty, but the words are still there when I move to another cell. I just want to delete the information as it's right in the middle of my worksheet. Please help me. |
#4
|
|||
|
|||
I ended up moving another a few other cells to another block and all the
cells that wouldn't delete, disappeared. I think it may have been a glitch or something. I appreciate your responses, and if it happens again, I'll try Max's response. I already tried clicking the cell and pressing delete I don't know how many times. Thanks for you concern. Mark "Jen Kulak" wrote: Just single click the cell and then hit delete key. "Max" wrote: Think the text may have been formatted as: Horizontal: Centre across selection (under Format Cells Alignment tab Text alignment) Try sleuthing on a couple of cells just to the left of where it displays Alternatively, select the entire row, then Click Format Cells Alignment tab Text alignment Set Horizontal to : Left (IIndent) OK Recheck the row, the offending text should be in its own cell -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "Mark B" Mark wrote in message ... I can't delete several cells content in Excel. When I double click on the cell, it shows it as empty, but the words are still there when I move to another cell. I just want to delete the information as it's right in the middle of my worksheet. Please help me. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell addressing using the content of another cell. | Jandon | Worksheet Functions | 1 | March 30th, 2005 06:39 PM |
How do I export comments into another excel column as cell content | Hernan | Worksheet Functions | 1 | February 25th, 2005 02:17 PM |
What is the Excel 2003 syntax for linking a cell value to content. | John | Worksheet Functions | 0 | February 17th, 2005 05:03 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |