wrapping text across a number of columns

  • Thread starter Thread starter Guest
  • Start date Start date
Den said:
I wish to wrap text across a number of columns and ensure this text is
justified.
Click to expand...

You will find what you need under cell formating.

Select the cells you want eg. A1:D1
Then Format>Cells
Select the Alignment Tab

Horizontal : Justify
Merge cells : Checkmark On

Hope it helps
George
 
Select the cells you want eg. A1:D1
Then Format>Cells
Select the Alignment Tab
Click to expand...

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

---
 
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
 
Den said:
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
Click to expand...
In the same area 'Format > Cells > Alignment'.
There is a vertical alignment - change it to top, or center etc.

George
 
George
Thank you so much - works perfectly.

Den

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

George
Click to expand...
 
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.
 
Back
Top