A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

can't delete a cell content in excel



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2005, 10:38 PM
Mark B
external usenet poster
 
Posts: n/a
Default 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  
Old May 5th, 2005, 11:39 PM
Max
external usenet poster
 
Posts: n/a
Default

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  
Old May 6th, 2005, 04:46 PM
Jen Kulak
external usenet poster
 
Posts: n/a
Default

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  
Old May 6th, 2005, 06:42 PM
Mark
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.