Create Multiple Lines of Text in One Cell.

Posted on April 25, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Create Multiple Lines of Text in One Cell.

And today I have another Excel Tip and Trick for you, well Tips and Tricks since we have several. There are actually 2 easy ways to create multiple lines of text in one cell.

 

The easiest way is to press Alt+Enter when you’re done typing.

 

Excel-Tips-Tricks-Pic1

 

The second option for creating multiple lines of text in one cell is.

 

  • Type your data.
  • Select the Cell.
  • Right Click
  • Select Format Cells
  • Click on the Alignment tab
  • And enable Wrap text.

 

Excel-Tips-Tricks-Pic2

 

  • And click on OK and you’re done.

 

Excel-Tips-Tricks-Pic3

 

I hope you found this Excel Tip & Trick a useful one. Have a nice weekend and I’ll talk to you all on Monday.

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

2 Responses to “Create Multiple Lines of Text in One Cell.”

  1. Silvia Feuerbach on June 25th, 2008 3:59 pm

    Yes that trick I know too, but this does not work on vista Exel anymore, do you have more info

  2. Vincent on June 25th, 2008 4:34 pm

    It does work in Vista, I made these Printscreens in Vista and Excel 2007. What Excel version are you using because I don’t know Vista Excel?

Leave a Reply