Entering multiple lines of text in a cell
 

I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he
1 = Money
2 = Show
3 = Ready
4 = Go

I can't figure out how to enter the text in a cell so it lines up as shown
above.

Thank you for any help.
--
Charles Allen, MVP

Entering multiple lines of text in a cell
 

You should be able to get away with <Alt+Enter

1 = Money <Alt+Enter
2 = Show
etc.

"Charles Allen" wrote:

I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he
1 = Money
2 = Show
3 = Ready
4 = Go

I can't figure out how to enter the text in a cell so it lines up as shown
above.

Thank you for any help.
--
Charles Allen, MVP

Entering multiple lines of text in a cell
 

You can enter multiple lines of text in a cell by pressing ALT ENTER
at the end of each line.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 14 Jan 2009 12:02:06 -0800, Charles Allen
wrote:

I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he
1 = Money
2 = Show
3 = Ready
4 = Go

I can't figure out how to enter the text in a cell so it lines up as shown
above.

Thank you for any help.

Entering multiple lines of text in a cell
 

Beautiful! I tried Shift and Ctrl but didn't think of trying Alt. Thank you.
--
Charles Allen, MVP



"Sean Timmons" wrote:

You should be able to get away with <Alt+Enter

1 = Money <Alt+Enter
2 = Show
etc.

"Charles Allen" wrote:

I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he
1 = Money
2 = Show
3 = Ready
4 = Go

I can't figure out how to enter the text in a cell so it lines up as shown
above.

Thank you for any help.
--
Charles Allen, MVP

Entering multiple lines of text in a cell
 

Happy to help! I actually learned that one on this board a while back...

"Charles Allen" wrote:

Beautiful! I tried Shift and Ctrl but didn't think of trying Alt. Thank you.
--
Charles Allen, MVP



"Sean Timmons" wrote:

You should be able to get away with <Alt+Enter

1 = Money <Alt+Enter
2 = Show
etc.

"Charles Allen" wrote:

I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he
1 = Money
2 = Show
3 = Ready
4 = Go

I can't figure out how to enter the text in a cell so it lines up as shown
above.

Thank you for any help.
--
Charles Allen, MVP