software

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

Den wrote:
gt; I wish to wrap text across a number of columns and ensure this text is
gt; justified.

You will find what you need under cell formating.

Select the cells you want eg. A11
Then Formatgt;Cells
Select the Alignment Tab

Horizontal : Justify
Merge cells : Checkmark On

Hope it helps
George

gt; Select the cells you want eg. A11
gt; Then Formatgt;Cells
gt; Select the Alignment Tab

For centering col headers,
try also the quot;Center Across Selectionquot; 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
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

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

quot;Georgequot; wrote:

gt; Den wrote:
gt; gt; I wish to wrap text across a number of columns and ensure this text is
gt; gt; justified.
gt;
gt; You will find what you need under cell formating.
gt;
gt; Select the cells you want eg. A11
gt; Then Formatgt;Cells
gt; Select the Alignment Tab
gt;
gt; Horizontal : Justify
gt; Merge cells : Checkmark On
gt;
gt; Hope it helps
gt; George
gt;

Den wrote:
gt; George
gt;
gt; Thank you for your response. This has worked well however the text I am
gt; inserting always types from the bottom - I would like to be able to type the
gt; text from the top as I will not always fill each section completely within
gt; the merge cells and typing from the bottom will leave blank lines at the top
gt; of my response.
gt;
gt; Hope this makes sense.
gt;
gt; Den
gt;
gt;gt;
In the same area 'Format gt; Cells gt; Alignment'.
There is a vertical alignment - change it to top, or center etc.

George

George
Thank you so much - works perfectly.

Den

quot;Georgequot; wrote:

gt; Den wrote:
gt; gt; George
gt; gt;
gt; gt; Thank you for your response. This has worked well however the text I am
gt; gt; inserting always types from the bottom - I would like to be able to type the
gt; gt; text from the top as I will not always fill each section completely within
gt; gt; the merge cells and typing from the bottom will leave blank lines at the top
gt; gt; of my response.
gt; gt;
gt; gt; Hope this makes sense.
gt; gt;
gt; gt; Den
gt; gt;
gt; gt;gt;
gt; In the same area 'Format gt; Cells gt; Alignment'.
gt; There is a vertical alignment - change it to top, or center etc.
gt;
gt; George
gt;

Den wrote:
gt; George
gt; Thank you so much - works perfectly.
gt;
gt; Den
gt;

Anytime.

Good to hear and thank you for your feedback :-)

George

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 quot;center across selectionquot; it quot;centeredquot; each line rather than
quot;justifyingquot; the whole cell. I had to choose quot;justifyquot; with quot;merge cellsquot;
checked.

quot;Maxquot; wrote:

gt; gt; Select the cells you want eg. A11
gt; gt; Then Formatgt;Cells
gt; gt; Select the Alignment Tab
gt;
gt; For centering col headers,
gt; try also the quot;Center Across Selectionquot; option
gt; under Horizontal (Text alignment)
gt; (achieves the same visual w/o using merged cells)
gt;
gt; Merge cells may cause downstream problems,
gt; so its best to avoid this
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

You can use Center Across Selection and then Left Justify the text.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Angelaquot; gt; wrote in message ...
gt; I'd just like to add my two cents on this....Actually, it doesn't achieve
gt; exactly the same visual if the text is long. I had the same issue, but when
gt; I chose quot;center across selectionquot; it quot;centeredquot; each line rather than
gt; quot;justifyingquot; the whole cell. I had to choose quot;justifyquot; with quot;merge cellsquot;
gt; checked.
gt;
gt; quot;Maxquot; wrote:
gt;
gt; gt; gt; Select the cells you want eg. A11
gt; gt; gt; Then Formatgt;Cells
gt; gt; gt; Select the Alignment Tab
gt; gt;
gt; gt; For centering col headers,
gt; gt; try also the quot;Center Across Selectionquot; option
gt; gt; under Horizontal (Text alignment)
gt; gt; (achieves the same visual w/o using merged cells)
gt; gt;
gt; gt; Merge cells may cause downstream problems,
gt; gt; so its best to avoid this
gt; gt; --
gt; gt; Max
gt; gt; Singapore
gt; gt; savefile.com/projects/236895
gt; gt; xdemechanik
gt; gt; ---
gt; gt;
gt; gt;
gt; gt;