[GeorgeJ]

I forget how to do this but I used to be able to in earlier versions of EXCEL.

Lets say I have a bunch of text which has the appearance of a paragraph.
Let's say each line starts in column B, so my text is in cols B10:B20. The
text strings are much longer than the width of col B, the the text extends
all the way to cols I, J and in some cases K. What I want is to make the
text not extend farther than column H. This would require some of the text
to move down to lower rows. Here is what I have been doing. I select cells
B10:H23 than then do

format/cells/alignment/horizontal/justify.

This doesn't do what I want. It moves all the text into the first column
(B), increases the heights of the rows significantly and the end result is
that nothing shows beyond column B. What I want is for the whole text blob
to be reformated so that all the text strings are still technically in col
B, but in display they extend rightward into adjacent cells but none goes
beyond col H. This involves haveing Excel treat the Text-strrings in Col B
as one big paragraph and reconfiguring them. I did this on older versions of
Excel. The commands were something like edit/fill/justify or
format/fill/justify or somethi8ng like that. I don't exactly remember. But
I can't figure out how to do what I want to do in EXCEL 2007. Can somebody
help me?


--
-regards

[Jim Rech]

The Justify command appears on the Fill menu which is in the last group on
the Home tab ("Editing"). The word "Fill" does not appear unless Excel is
pretty stretched out but the downward pointing arrow is Fill.

You would want to select the range B10:H20 (or a few rows more like to H25)
before executing this command.

--
Jim
"GeorgeJ" wrote in message
...
|
| I forget how to do this but I used to be able to in earlier versions of
EXCEL.
|
| Lets say I have a bunch of text which has the appearance of a paragraph.
| Let's say each line starts in column B, so my text is in cols B10:B20.
The
| text strings are much longer than the width of col B, the the text extends
| all the way to cols I, J and in some cases K. What I want is to make the
| text not extend farther than column H. This would require some of the
text
| to move down to lower rows. Here is what I have been doing. I select
cells
| B10:H23 than then do
|
| format/cells/alignment/horizontal/justify.
|
| This doesn't do what I want. It moves all the text into the first column
| (B), increases the heights of the rows significantly and the end result is
| that nothing shows beyond column B. What I want is for the whole text
blob
| to be reformated so that all the text strings are still technically in
col
| B, but in display they extend rightward into adjacent cells but none goes
| beyond col H. This involves haveing Excel treat the Text-strrings in Col
B
| as one big paragraph and reconfiguring them. I did this on older versions
of
| Excel. The commands were something like edit/fill/justify or
| format/fill/justify or somethi8ng like that. I don't exactly remember.
But
| I can't figure out how to do what I want to do in EXCEL 2007. Can
somebody
| help me?
|
|
| --
| -regards

[GeorgeJ]

Thanks Jim. That works perfectly. I don't know how long - if ever - it
would have taken me to figure that out. A search on the words "fill" &
"Justify" turned up so many entries as to be meaningless.