Articles | Photoshop and Photography blog | about me |e-mail

ProjectWoman

Welcome to Helen Bradley's Microsoft Office and productivity blog. I'm a lifestyle journalist specializing in business and consumer software and here you'll find handy hints for using software such as Microsoft Office 2007 and other office applications. Elsewhere on projectwoman.com you'll find tutorials, articles, how tos and tips on photography and Photoshop CS3. My publishing credits include PC Magazine, Windows XP magazine, CNet, PC User magazine, InformIT and others.

Wednesday, January 16, 2008

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: , ,

Add to Technorati Favorites

2 Comments:

At March 30, 2008 1:09 PM , Anonymous Anonymous said...

YOU ARE MY HERO!!!!! That is WAY too easy, and I've been trying to figure it out for YEARS!!!

thanks!

KMc from Ga.

 
At September 16, 2008 11:03 AM , Anonymous Anonymous said...

Thank you, thank you, thank you...I've been racking my brain around this and you are my saviour!!!

 

Post a Comment

Links to this post:

Create a Link

<< Home