Separate lines in Excel cell

B

BobO''''''''B

How can I insert separate lines in a worksheet cell?
I'm using Excel to build a Tournament Roster ('coz it's easier to use than
Word tables) and want to enter data like:
Competitive Men
Team A vs.
Team B

in a singe cell and centre the first line, left justify the 2nd and right
justify the 3rd.
 
B

BobO''''''''B

Thanks, it IS easier, but there are other constraints in adjacent cells that
prevent using this solution.
 
G

Gord Dibben

The Alt + ENTER will give you carriage returns but I don't think you can do the
center, right and left justify as you posted without padding with spaces.


Gord Dibben MS Excel MVP
 

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

Top