how to type more than one line in a cell

[elaway]

I am trying to prepare a spread sheet. My font is Arial (10) pt. I have the grid prepared and have adjusted the row height to (30).
I would like to be able to type more than one line into the cells, but when I try it jumps to the next cell below.
Is there any way to do this?

Thanks for your answer(s).

 

[jeffreybrown]

You can turn on wrap text or when you get to the end of a line select Alt + Enter (this will create a second line within the cell)

 

[T. Valko]

Type some stuff then when you want to go to a new line hold down the ALT key then hit Enter. After you've entered all the data hit Enter.

You might have to adjust the column width and row height to get it to look exactly how you want it.

Make sure the cell is formatted to wrap text. Format>Cells>Alignment tab>Wrap text>OK.

 

[elaway]

Thank you so much Jeff.
As you can probably tell, I'm new to Excel. Love the software, and try to find solutions in the (?) of the software. Just couldn't find this one.

 

[elaway]

Thank you NAME for your input. I appreciate all the help here in the forum.

Wayne

 

[T. Valko]

You're welcome!

 

[jeffreybrown]

Glad to help also

 

[Nalani]

Thank you so much Jeff.
As you can probably tell, I'm new to Excel. Love the software, and try to find solutions in the (?) of the software. Just couldn't find this one.

This link might help you along in your learning process:

http://www.mrexcel.com/forum/showthread.php?t=381508

And if you want a whole list, go here:

http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Good luck and have fun

 

[elaway]

Nalani, Thank you so much for the great list.
This will be a tremendous help.

Wayne