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.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,825
Messages
6,121,787
Members
449,049
Latest member
greyangel23

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
Back
Top