Justify text across multiple columns

[Guest]

I have used Edit, Fill, Justify to fill rows with text within the boundaries
of a set number of columns, but the text in each row is left justified. How
do I justify the text (even spacing) in each row. If I highlight all of the
text (multiple columns and rows) and then select Format, Cells, Alignment,
Justify; Excel jams all the text into the first column. I know I could use a
text box, but I'd prefer not to. Any help would be appreciated. Thanks.
-Dave

 

[L. Howard Kittle]

Hi Dave,

Select the cells you want to center on.
Under Format > Alignment > Horizontal drop down > Center across selection >
OK

Should do what you want if I understand the question.

HTH
Regards,
Howard

 

[Guest]

Thanks for the reply Howard, but I want to justify the text outside edge to
outside edge across several columns (like a newspaper, or like how Justify
works in MS Word). Any further suggestions?

 

[L. Howard Kittle]

Okay, I see. Sorry, no I don't know how you would do that.

Regards,
Howard

 

[Anne Troy]

Are you merging the cells? Works for me in Excel 2003 when I wrap text, and
fully justify.
************
Anne Troy
www.OfficeArticles.com