wrapping text across a number of columns

[Den]

I wish to wrap text across a number of columns and ensure this text is
justified.

 

[George]

I wish to wrap text across a number of columns and ensure this text is
justified.

You will find what you need under cell formating.

Select the cells you want eg. A11
Then Format>Cells
Select the Alignment Tab

Horizontal : Justify
Merge cells : Checkmark On

Hope it helps
George

 

[Max]

Select the cells you want eg. A11

Then Format>Cells
Select the Alignment Tab

For centering col headers,
try also the "Center Across Selection" option
under Horizontal (Text alignment)
(achieves the same visual w/o using merged cells)

Merge cells may cause downstream problems,
so its best to avoid this

 

[Den]

George

Thank you for your response. This has worked well however the text I am
inserting always types from the bottom - I would like to be able to type the
text from the top as I will not always fill each section completely within
the merge cells and typing from the bottom will leave blank lines at the top
of my response.

Hope this makes sense.

Den

 

[George]

George

Thank you for your response. This has worked well however the text I am
inserting always types from the bottom - I would like to be able to type the
text from the top as I will not always fill each section completely within
the merge cells and typing from the bottom will leave blank lines at the top
of my response.

Hope this makes sense.

Den

In the same area 'Format > Cells > Alignment'.
There is a vertical alignment - change it to top, or center etc.

George

 

[Den]

George
Thank you so much - works perfectly.

Den

In the same area 'Format > Cells > Alignment'.
There is a vertical alignment - change it to top, or center etc.

George

 

[George]

George
Thank you so much - works perfectly.

Den

Anytime.

Good to hear and thank you for your feedback

George

 

[Angela]

I'd just like to add my two cents on this....Actually, it doesn't achieve
exactly the same visual if the text is long. I had the same issue, but when
I chose "center across selection" it "centered" each line rather than
"justifying" the whole cell. I had to choose "justify" with "merge cells"
checked.

 

[David McRitchie]

You can use Center Across Selection and then Left Justify the text.
--