wrapping text across a number of columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to wrap text across a number of columns and ensure this text is
justified.
 
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.
 
You can use Center Across Selection and then Left Justify the text.
--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Wrap text 3
Format text across cells 3
make row height a little bigger in a wrapped cell 3
how do I merge two adjacent cells and keep the data from both cell 1
converting text to columns 1
Can not see text in Excel when cell format is set to wrap text 1
Enter various number of blank lines in cells 2
Text control won't expand 1

Back
Top