aligning text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
1. Merge the cells
2. Align left
3. Manually adjust row height to give best results
 
Sorry, I forgot to mention that I cant merge the cells. Is there another way
to do this?
 
Can you insert a Text box, size it to the correct area, and put your text in
there?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't see all text in Excel Cell 4
centre across selection shortcut 3
Change Alignment Defaults 4
Why won't text show in SOME cells? 3
force alignment? 7
Add "left align across selection" cell formatting 3
Why does "Show Formulas" in Excel 2007 lock column alignment 1
Forcing Alignment Options 2

Back
Top