New lines in an Excel 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.

Thanks a lot, it came as first result of google :). Thanks a lot again!!!!!!!!

Thanks a million, you\'re a lifesaver!

thanks
wasted one hour in excel help doc

Thanks you!

Your a legend! thx

On a mac you need to hold down the apple key and press option then press enter.

I LOVE YOU!!!! Thanks

Thank you! This has made my life much sunnier.

Can you imagine just how many people have been helped by this such a simple and single explanation. Not every one replies with a Thank you post. Wonder if Microsoft\'s complex minds would someday provide answers in such a straight way instead of going through 7 or 8 wizzard steps.

Micro$oft help was pretty useless (online and offline). Wth Bobby, 4 years down the line your blog is STILL helpin folks! Now THAT\'S a good reason for keeping the internet free

Thanks, this is a very helpful tip.

Bang on the target!
Saved my day!
Thank You!

My hero!

Thanks so much. I\'m using a Mac (and fairly new to it) and couldn\'t figure it out for the life of me!

woowwwww.........thank yoooo
it is great, I have been looking and asking how to do it...yoo cool dude

Man Oh Man...
You know, there is Microsoft (with their online help blabla) and there is you (one line is worth more than ... whatever!!! you know what I mean)...

THANK YOU MAN

Great job done...
You blog is 5 years old and still very helpful.
Thanks.

Thanks bob. That helps a lot.

Wow,. This is a time saver for me! :D

Great help. Thanks Bob.

You da man, cheers Bob!

Thanks Bob!

Just what I needed! Cheers man.

haha lol.
Thanks from me too :)_

Thanks, you are the man!!