I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald.
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
Labels:Uncategorized
Please feel free to add your comment here. Thank you!
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.
Thank you! This is a life savier 🙂
Thanks for this Helen, you saved my day!
Hi,
I am using a Mac and excel 2011. alt + enter does not work for me. Any ideas?