Multiple Paragraphs of text in an Excel cell
Multiple paragraphs of text in an Excel cell sound good, they look good but how the heck do you create them? If you press the Enter key you enter the current text into the cell and move away from it - obviously, pressing the Enter key isn't the answer.
The solution is to press Alt + Enter to create a new line of text in the current cell. Do this as often as you need to. You might have to make the row taller to fit the text if Excel doesn't make the adjustment for you.
Labels: Excel 2003, paragraphs of text in a cell, Wrap text
posted by Jane @ 9:21 AM
11 Comments:
YOU ARE MY HERO!!!!! That is WAY too easy, and I've been trying to figure it out for YEARS!!!
thanks!
KMc from Ga.
Thank you, thank you, thank you...I've been racking my brain around this and you are my saviour!!!
I love you
Thank you, thank you -- I have a new job. The people here adore excel and I have only a basic knowledge. This was enormously helpful!
Thanks man, i've been hasslin wit this prob 4 decades :-)
OK - It was totally fantastic. Now, how do you indent the newly formed paragraph?
Thank you so much! You just ended years of frustration!
You just saved my job applicaiton from looking like a 3rd grader wrote it.
Mike
Woo hooo! Thanks!!
If anyone is still answering questions off this thread, can you program some kind of code to just use the enter key to move to a new paragraph in the same cell without using the alt enter keystroke?
You could program the Enter key but it would be counter productive, I think, as the Enter key is used to commit data entry in the cell so it wouldn't function that way any longer.
Post a Comment
Please feel free to add your comment here. Thank you!
Subscribe to Post Comments [Atom]
<< Home