#1   Report Post  
Old May 8th 09, 03:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 471
Default Non-Bleeding Cells

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.

  #2   Report Post  
Old May 8th 09, 03:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Non-Bleeding Cells

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!
================================================== ===


"Mike H." wrote in message
...
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.


  #3   Report Post  
Old May 8th 09, 08:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 2
Default Non-Bleeding Cells

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" wrote:

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!
================================================== ===


"Mike H." wrote in message
...
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.



  #4   Report Post  
Old May 8th 09, 09:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Non-Bleeding Cells

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!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike H." <Mike wrote in message
...
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" wrote:

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!
================================================== ===


"Mike H." wrote in message
...
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.





  #5   Report Post  
Old May 8th 09, 11:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 471
Default Non-Bleeding Cells

That is a tolerable way to do it. Thanks!

"Mike H." wrote:

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" wrote:

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!
================================================== ===


"Mike H." wrote in message
...
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.





  #6   Report Post  
Old May 9th 09, 03:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Non-Bleeding Cells

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

Regards,

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

"Mike H." wrote in message
...
That is a tolerable way to do it. Thanks!

"Mike H." wrote:

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" wrote:

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!
================================================== ===


"Mike H." wrote in message
...
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.







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
Cells won't change font color or show hi-lighted cells in document ROBIN Excel Discussion (Misc queries) 1 March 27th 08 09:39 PM
display a range of cells editible cells based on matching date Miki Excel Worksheet Functions 0 October 10th 07 03:27 PM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017