Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Justify text across multiple columns
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 |
#2
|
|||
|
|||
Justify text across multiple columns
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 "fins2r" wrote in message ... 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 |
#3
|
|||
|
|||
Justify text across multiple columns
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" wrote: 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 "fins2r" wrote in message ... 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 |
#4
|
|||
|
|||
Justify text across multiple columns
Okay, I see. Sorry, no I don't know how you would do that.
Regards, Howard "fins2r" wrote in message ... 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 |
#5
|
|||
|
|||
Justify text across multiple columns
Are you merging the cells? Works for me in Excel 2003 when I wrap text, and
fully justify. ************ Anne Troy www.OfficeArticles.com "fins2r" wrote in message ... 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" wrote: 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 "fins2r" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Columns & VLookup?? | Excel Worksheet Functions | |||
Combining multiple columns of text | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions | |||
splitting text to multiple columns | Excel Discussion (Misc queries) |