ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you keep text from one cell showing over the next cell? (https://www.excelbanter.com/excel-discussion-misc-queries/73312-can-you-keep-text-one-cell-showing-over-next-cell.html)

Sean VandeWall

Can you keep text from one cell showing over the next cell?
 
Frequently I have a lengthy amount of text in a cell, and a blank cell next
to it. I would prefer it if the text did not continue over into the next
blank cell.

I know there is an option for Word Wrap, and this increases the size of the
row. Unfortunately this isn't an option I'd like to take. I also don't want
to shrink the text to fit the cell's column width.

So I'm curious if there is a way to have the text display within its own
cell, and any character that would exceed the cell's column width would hide,
instead of carrying over into the blank cell next to it.

CLR

Can you keep text from one cell showing over the next cell?
 
Just type a "space" or any other character in the cell just to the right of
the cell containing your text.

Vaya con Dios,
Chuck, CABGx3



"Sean VandeWall" wrote:

Frequently I have a lengthy amount of text in a cell, and a blank cell next
to it. I would prefer it if the text did not continue over into the next
blank cell.

I know there is an option for Word Wrap, and this increases the size of the
row. Unfortunately this isn't an option I'd like to take. I also don't want
to shrink the text to fit the cell's column width.

So I'm curious if there is a way to have the text display within its own
cell, and any character that would exceed the cell's column width would hide,
instead of carrying over into the blank cell next to it.


bigwheel

Can you keep text from one cell showing over the next cell?
 
A single space in the adjacent cell will suppress the text showing in it but
there may be another way €¦

"Sean VandeWall" wrote:

Frequently I have a lengthy amount of text in a cell, and a blank cell next
to it. I would prefer it if the text did not continue over into the next
blank cell.

I know there is an option for Word Wrap, and this increases the size of the
row. Unfortunately this isn't an option I'd like to take. I also don't want
to shrink the text to fit the cell's column width.

So I'm curious if there is a way to have the text display within its own
cell, and any character that would exceed the cell's column width would hide,
instead of carrying over into the blank cell next to it.



All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com