|
If you put something in the next cell it will not fill over, you could put
="" for instance -- Regards, Peo Sjoblom "NothingButRomance" om wrote in message on.com... Thank you for that info, but I guess I should have mentioned that one too. I tried that and it makes the rows way too tall, so that is not an option either. I also can't "shrink to fit" because then my Mom won't be able to see the words. I just thought there was a way to "contain" the text in a cell and have it "cut off" where the next cell begins. Thanks! Vasant Nanavati Wrote: Format | Cells | Alignment | Text Control | Wrap Text. -- Vasant "NothingButRomance" wrote in message on.com...- When I have a "sentence" of text in a field and the field next to it is empty, the sentence text strings into it and you don't see a empty field. I know that I can change the width of the field that the sentence is in, but that won't work in this case because I need it small, so is there a way to stop the text from wandering into the next field? This is not a Merge issue, by the way, Merge is not checked. I can go into the empty field and hit the space button to make the field before it (with the sentence) think that its not empty, but that only works while you have it open, even if you save, the string comes back the next time you access the file. HELP!! Thanks, Lalla -- NothingButRomance- -- NothingButRomance |
If you put something in the next cell it will not fill over,
you could put ="" for instance Hitting a space would be slightly faster, no? <g But the OP did mention this .. hit the space button to make the field before it (with the sentence) think that its not empty, But thought that this part of the original post may not be quite correct, going by tests carried out here .. but that only works while you have it open, even if you save, the string comes back the next time you access the file. The space(s) remained where they were hit or copied down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Spaces may be slightly faster, but for me, they're extremely difficult to
noctice. But if I put ="" in a cell, I can select the cell and see it in the formula bar. Entering a space character adds some time when I want to find out what's in that cell. (Pay me now, or pay me later???) Max wrote: If you put something in the next cell it will not fill over, you could put ="" for instance Hitting a space would be slightly faster, no? <g But the OP did mention this .. hit the space button to make the field before it (with the sentence) think that its not empty, But thought that this part of the original post may not be quite correct, going by tests carried out here .. but that only works while you have it open, even if you save, the string comes back the next time you access the file. The space(s) remained where they were hit or copied down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- -- Dave Peterson |
Wrap text, and re-fix the row height to whatever standard size you want.
- Mangesh "NothingButRomance" om wrote in message on.com... Thank you for that info, but I guess I should have mentioned that one too. I tried that and it makes the rows way too tall, so that is not an option either. I also can't "shrink to fit" because then my Mom won't be able to see the words. I just thought there was a way to "contain" the text in a cell and have it "cut off" where the next cell begins. Thanks! Vasant Nanavati Wrote: Format | Cells | Alignment | Text Control | Wrap Text. -- Vasant "NothingButRomance" wrote in message on.com...- When I have a "sentence" of text in a field and the field next to it is empty, the sentence text strings into it and you don't see a empty field. I know that I can change the width of the field that the sentence is in, but that won't work in this case because I need it small, so is there a way to stop the text from wandering into the next field? This is not a Merge issue, by the way, Merge is not checked. I can go into the empty field and hit the space button to make the field before it (with the sentence) think that its not empty, but that only works while you have it open, even if you save, the string comes back the next time you access the file. HELP!! Thanks, Lalla -- NothingButRomance- -- NothingButRomance |
It was meant in the spirit of light banter, Dave !
But I see your point (and Peo's) (Pay me now, or pay me later???) No or's about that, I wanna be paid now and later <g -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
I didn't mean to get too serious, but I bet most people who inherit workbooks
from others who clear cells with the spacebar, hate that. (I do!) Max wrote: It was meant in the spirit of light banter, Dave ! But I see your point (and Peo's) (Pay me now, or pay me later???) No or's about that, I wanna be paid now and later <g -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- -- Dave Peterson |
"Dave Peterson" wrote
I didn't mean to get too serious, but I bet most people who inherit workbooks from others who clear cells with the spacebar, hate that. (I do!) Granted, Dave. Thanks. And I guess that's why I tend towards a liberal use of TRIM in formulas pointing to textual data. One never knows when a (extra) spacebar hit is intentional or accidental. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com