How to Enter Multiple Lines in a Single Excel Cell?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
Many times you may have used word wrap to arrange the lines in an Excel cell so that it occupies the correct cell width you prefer. But what if you don’t like the way it wraps the text or you want to forcefully word wrap after a particular word in a sentence in an Excel Cell?
For example, in the picture below, in the first cell the text is word wrapped automatically and in the second cell it is word wrapped after the ‘Lyte Byte –‘ forcefully.
So here is the tip, wherever you want to manually insert word wrap or to write in more than one line within Excel cell, use keyboard shortcut Alt + Enter. This will allow to enter multiple lines within a single Excel cell with ease and on the go.
I always enjoy your excel tips, you are the excel guru, I always turn to search your posts when I face some difficulties using excel
@Keith Dsouza, Nice to hear that. I write tips as i face some issues and challenges when i work with excel.
[...] How to Enter Multiple Lines in a Single Excel Cell? [...]
Great Tips, Thanks for sharing even after working on Unix/Linux still need Windows Excel for work
To be honest, i was looking for something similar, and i have found it
thank you very much 
THANK YOU!, this was very helpful and exactly what I was searching for. Its amazing how easy something is, but how difficult it can be if you dont know the steps to take
You Rock!
Hey Thanks for the Help.
O Man…u r just a boss!!! thank u buddy.
So happy that was exactly was I was looking for, it was starting to really frustrate me! Thanks thanks thanks
I have a MAC and this does not work? any tips?
thank you
I’ve been using alt+enter for years on Excel 2003, today it decided to stop working and I can’t find any way to get it to do as it should. It seems to make no difference if I’m editing in the Formula Bar or in the cell itself. What does happen when alt+enter is used is the cursor just jumps to the next cell. I’ve tried this with text wrapping switched on for the cell as well as having it switched off – still no joy! Any thoughts on how to get this short-cut working again?
thanks thanks………….u r the best…
@ Omar : for mac, please try Ctrl+alt+Enter.
Thanks.
Really very useful tip, I also was looking for the solution.
Thanks, Thanks a lot.
Really useful. Thanks for these little ‘bigs’ tips…
Ctrl+alt+Enter
WORKS FOR MAC!!!!! Thank u so much!!!
Man hitting enter to try and do multiple lines was annoying as heck. Thanks for the quick and easy tip!