Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justified
I am translating text which is done in Excel, I do not seem to be able to get
the same news paper print look, with a straight edge both on the left and the right. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justified
Hi
Choose Format, Cells, Alignment From the Horizontal Drop-down box choose Justify and click the Wrap Text Checkbox Peter "Betababy" wrote: I am translating text which is done in Excel, I do not seem to be able to get the same news paper print look, with a straight edge both on the left and the right. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justified
select the cell, go to format cells and select alignmenthorizontaljustify
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Betababy" wrote: I am translating text which is done in Excel, I do not seem to be able to get the same news paper print look, with a straight edge both on the left and the right. Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justifie
Hi John & thank you,
I tried to do what you suggested on a paragraph of text and it all went to the left and some text dissappeared. What I am after is something that I know we used to do in words, where the words are all straight on the left at the same time as all straight on the right. the words are spread out across each line to allway end at the same place on the right and the left. Any other ideas? Helene "John" wrote: select the cell, go to format cells and select alignmenthorizontaljustify -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Betababy" wrote: I am translating text which is done in Excel, I do not seem to be able to get the same news paper print look, with a straight edge both on the left and the right. Any suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justifie
I believe Excel does not have this capability of left and right justify in a
cell. Excel makes a very poor word processing apllication. Word is better suited to this task. Gord Dibben MS Excel MVP On Fri, 11 May 2007 13:38:02 -0700, Betababy wrote: Hi John & thank you, I tried to do what you suggested on a paragraph of text and it all went to the left and some text dissappeared. What I am after is something that I know we used to do in words, where the words are all straight on the left at the same time as all straight on the right. the words are spread out across each line to allway end at the same place on the right and the left. Any other ideas? Helene "John" wrote: select the cell, go to format cells and select alignmenthorizontaljustify -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Betababy" wrote: I am translating text which is done in Excel, I do not seem to be able to get the same news paper print look, with a straight edge both on the left and the right. Any suggestions? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Block text? I.E. like news paper. right & left justifie
On May 12, 10:29 am, Gord Dibben <gorddibbATshawDOTca wrote:
I believe Excel does not have this capability of left and right justify in a cell. Excel makes a very poor word processing apllication. Word is better suited to this task. Gord Dibben MS Excel MVP On Fri, 11 May 2007 13:38:02 -0700, Betababy wrote: Hi John & thank you, I tried to do what you suggested on a paragraph of text and it all went to the left and some text dissappeared. What I am after is something that I know we used to do in words, where the words are all straight on the left at the same time as all straight on the right. the words are spread out across each line to allway end at the same place on the right and the left. Any other ideas? Helene "John" wrote: select the cell, go to format cells and select alignmenthorizontaljustify -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Betababy" wrote: I am translating text which is done in Excel, I do not seem to be able to get the same news paper print look, with a straight edge both on the left and the right. Any suggestions?- Hide quoted text - - Show quoted text - I know so. From the cell with text, to easy do it, select the alignment from the icon(s) on the menu bar. This works for me when I do forms using Exel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
by default text is left justified, numbers are right justified - a specific reason for this? | Excel Discussion (Misc queries) | |||
Left justified date/time in new cell ? | Excel Discussion (Misc queries) | |||
rows top-justified & bottom-justified in same sheet looks bad | Excel Worksheet Functions | |||
how to make number as text and left justified? | Excel Worksheet Functions | |||
Can I right AND left justify to block text in excel? | Excel Discussion (Misc queries) |