Non-Bleeding Cells

[Mike H.]

Is there a way to format a cell so that it only displays its contents in the
current cell rather than appearing to "bleed" over to the adjoining cells.
In other words if the cell contained the text string "Now is the time for all
good men" and the cell was only 10 characters wide, on-screen you would only
see "Now is the" because that is all that would display. If this was in cell
A1, cell B1 would appear empty. What happens now is that the contents just
display across all the cells it needs in order to show the whole sentence. I
don't want to wrap the text. I don't want to change anything in any way
other than have the contents appear truncated so B1 is "empty". Thanks.

 

[RagDyeR]

A1 runs over into B1 because B1 is empty.

So, if you add this formula to B1:

=""

It's no longer empty.

This leaves B1 with the appearance of being empty,
allows users to easily overwrite it to add data,
and can be viewed in the formula bar,
which is a much better alternative then using the "much dreaded" <SpaceBar>
to fill B1.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Is there a way to format a cell so that it only displays its contents in the
current cell rather than appearing to "bleed" over to the adjoining cells.
In other words if the cell contained the text string "Now is the time for
all
good men" and the cell was only 10 characters wide, on-screen you would only
see "Now is the" because that is all that would display. If this was in
cell
A1, cell B1 would appear empty. What happens now is that the contents just
display across all the cells it needs in order to show the whole sentence.
I
don't want to wrap the text. I don't want to change anything in any way
other than have the contents appear truncated so B1 is "empty". Thanks.

 

[Mike H.]

I don't really like this as a solution because of what is involved. I would
prefer to just be able to format the cell someway so it doesn't bleed over.
There might be something in B2, which prevents the bleeding but B1 was empty
so I'd have to fill in just the empty cells.

 

[RagDyer]

AFAIK, there's no way to format Column A without using wrapping, which you
said you didn't want to do.

Here's a relatively simple and easy way to fill those "in-between" blank
cells:

Select Column B, including the filled cells,
Hit <F5>
Click <Special>
Click <Blanks>
Click <OK>
Type
=""
Hit <Ctrl> <Enter>
And you're done!

 

[Mike H.]

That is a tolerable way to do it. Thanks!

I don't really like this as a solution because of what is involved. I would
prefer to just be able to format the cell someway so it doesn't bleed over.
There might be something in B2, which prevents the bleeding but B1 was empty
so I'd have to fill in just the empty cells.

 

[RagDyeR]

You're welcome, and appreciate the feed-back.