Justify text across multiple columns

F

fins2r

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

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
 
F

fins2r

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

L. Howard Kittle

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

Regards,
Howard
 
Top