Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
wrapping text across a number of columns
0 views
Skip to first unread message
Den
Feb 13, 2006, 1:08:29 AM2/13/06
to
I wish to wrap text across a number of columns and ensure this text is
justified.
justified.
George
Feb 13, 2006, 1:37:27 AM2/13/06
to
Den wrote:
> I wish to wrap text across a number of columns and ensure this text is
> justified.
> 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. A1:D1
Then Format>Cells
Select the Alignment Tab
Horizontal : Justify
Merge cells : Checkmark On
Hope it helps
George
Max
Feb 13, 2006, 10:19:22 AM2/13/06
to
> Select the cells you want eg. A1:D1
> Then Format>Cells
> Select the Alignment Tab
> 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
George
Feb 13, 2006, 9:29:34 PM2/13/06
to
Den wrote:
> 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
>
> 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
Feb 13, 2006, 9:36:26 PM2/13/06
to
George
Thank you so much - works perfectly.
Thank you so much - works perfectly.
Den
George
Feb 13, 2006, 9:55:17 PM2/13/06
to
Den wrote:
> George
> Thank you so much - works perfectly.
>
> Den
>
> George
> Thank you so much - works perfectly.
>
> Den
>
Anytime.
Good to hear and thank you for your feedback :-)
George
Angela
Apr 3, 2006, 2:10:04 PM4/3/06
to
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.
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
Apr 3, 2006, 10:32:08 PM4/3/06
to
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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Angela" <Ang...@discussions.microsoft.com> wrote in message news:45E498B1-A383-4D0D...@microsoft.com...
0 new messages