New lines in an Excel cell
I just figured out how to enter a new line in an Excel cell. The trick is to use Alt+Enter to create a new line. Also, when you do that, Excel automatically enables text wrap for the cell.
Tips List
----------
Alt+Enter: Enter new line in a cell
F2: Edit a cell

Thanks Bobby. It works!
How such a simple posting can save a day! :-) Thanks, Bobby.
and how to remove a new line in all the cells of a entore column?
A simple post that can save a lot of work. Goood Post Bobby. Thanks.
I guess it works for Windows, but how about when using an eMac? This would help a bunch!
I knew there was a way! Thanks!
Thanks, dude!
easy way to save the day!
This was annoying me so much...THANK YOU!
Life saving..
Thanks a ton..
well..as far as i know..on mac, hold down Option with either ctrl or apple key and then press the enter..you should get the same thing..
I've always wanted to know how to do that! How perfect!
I love you. Seriously. I do.
cool man...cool, thx a lot
Radical dude!!
Great! Thanks. MS Excel Help does not help.
amesegnalehu, anta akuay.
you saved my ...
Dude...I love you!
Dude, i needed this feature also, cause my boss does not know how to read. Life sucks and I wished I was dead. But hey anyway thanks.
many thanks for this. has been trying literally for years to figure how to do that :)
I know alot about excel, but didn't know that one! Thanks for the tip!
Two tumbs up!
Thats great!
Hi Bobby,
Looks like you have been imortalised. I think you will get hits on this blog for the rest of the century. Thanks heaps
Thank you,
This issue has been bugging me for some time now.
CTRL+ALT+ENTER may also be required (instead) in some versions of OSX and Excel in order to enter lines within cells.
Just great...I previously used spacebar key to go to the new line and it was very frustrating...Thank you very much!
Thanks! just what I was looking for!
Thanks Bobby - you're my Excel hero!
Thanks a lot for this. Saved a lot of time for me :)
Thanks, great info :)
Small, but very helpful.
Lol you saved the day, thanks :) Damn excel.
merci!
\"Excel\"lent Bobby!
you guys are all funny. This is basic functionality - look in Excel help, Keyboard shortcuts. Spend 10 min and it\'ll save you a lot more.
Merci! I am dying for it!
Thanks dude. This is a great help.
Great tip, I had been looking for it for so long.
Saved the day, thanks.
Very helpful
thanks man.. this problem was killing me for long time. Stupid Micrsoft!
Thanks! Very useful.
Jacob
Thanks!
Thanks a ton Bobby! You have no idea how much this was annoying the hell outta me... :D
if \"iva\" uses Help so much, I wonder why she/he is reading this.
Thanks alot! I was trying to figure that out for my job project.
Exactly what I needed! Thanks!
Truly appreciated, i have been trying to find this out for ever.
Thanks from Sweden
Wow...I am so glad I googled this. Thanks for the tip. I spent 2 hours trying to find the feature in Excel. Will use keyboard tips in the future.