text wrap

Megavision

New Member
Joined
Feb 8, 2005
Messages
5
:devilish: Happy Mardi Gras!
After reading 100 posts ... simple question is how can I text wrap and have text left justify rather than center across cells? Using edit and justify doesn't serve my purpose. Is there any way to use the alignment feature and left justify therefrom. A dinosaur comment ... we could do that in 123 without any problem, but I haven't even seen 123 in years.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
If you use the Centre Across Selection from the Format Menu, Excel will do exactly that, centre the text. If the text has to be across multiple cells, you could try the merge cells option, which has its own issues. If the text is only in one column, selecting wrap text should automatically left justify.

Richard
 

Megavision

New Member
Joined
Feb 8, 2005
Messages
5
Thanks for the posted reply. One would think that a smart Microsoft Excel original programmer would have just added options below the "center across columns" that would allow for left justifying or filling the row ... but that may be assuming that they somewhere along the line actually talked to the users. Or maybe my expectations are just too hign. Thanks again for the reply.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,958
Messages
5,627,850
Members
416,276
Latest member
kbhoops15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top