Create Multiple Lines of Text in One Cell.
Posted on April 25, 2008
Filed Under Excel Tips & Tricks
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.
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.
-
And click on OK and you’re done.
I hope you found this Excel Tip & Trick a useful one. Have a nice weekend and I’ll talk to you all on Monday.
| New to the World of Office, XP and Vista Tips & Tricks? |
Here are a few posts the other readers recommend you check out. |
|
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. And if you want to subscribe to us, our full feed RSS is updated daily.
Comments
2 Responses to “Create Multiple Lines of Text in One Cell.”
Leave a Reply
-
-
-
-
-
-
Our Friends
Yes that trick I know too, but this does not work on vista Exel anymore, do you have more info
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?