| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
aligning text
Under format cells/alignment, I have seen the option to horizontally align
text to "Centre across Selection" (the text is also wrapped across this selection). Is there any way to wrap text and align to the left across selection. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
aligning text
1. Merge the cells
2. Align left 3. Manually adjust row height to give best results -- Gary''s Student - gsnu200738 "A" wrote: Under format cells/alignment, I have seen the option to horizontally align text to "Centre across Selection" (the text is also wrapped across this selection). Is there any way to wrap text and align to the left across selection. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
aligning text
Sorry, I forgot to mention that I cant merge the cells. Is there another way
to do this? "Gary''s Student" wrote: 1. Merge the cells 2. Align left 3. Manually adjust row height to give best results -- Gary''s Student - gsnu200738 "A" wrote: Under format cells/alignment, I have seen the option to horizontally align text to "Centre across Selection" (the text is also wrapped across this selection). Is there any way to wrap text and align to the left across selection. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
aligning text
Can you insert a Text box, size it to the correct area, and put your text in
there? "A" wrote: Sorry, I forgot to mention that I cant merge the cells. Is there another way to do this? "Gary''s Student" wrote: 1. Merge the cells 2. Align left 3. Manually adjust row height to give best results -- Gary''s Student - gsnu200738 "A" wrote: Under format cells/alignment, I have seen the option to horizontally align text to "Centre across Selection" (the text is also wrapped across this selection). Is there any way to wrap text and align to the left across selection. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
aligning text
If you add an Alt + Enter to create a linefeed in the cell, the center across
and wrap text will work together. i.e. this is a long line of text <Alt + Enter this is another line of text <Alt + Enter<Enter Gord Dibben MS Excel MVP On Wed, 22 Aug 2007 02:16:01 -0700, A wrote: Under format cells/alignment, I have seen the option to horizontally align text to "Centre across Selection" (the text is also wrapped across this selection). Is there any way to wrap text and align to the left across selection. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligning within a cell | Excel Worksheet Functions | |||
| Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
| Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
| Aligning text in a text box | Excel Discussion (Misc queries) | |||
| Aligning text | Excel Discussion (Misc queries) | |||
Hybrid Mode
