New lines in an Excel cell

| | Comments (49)

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

Categories




49 Comments

Harry Wood said:

Thanks Bobby. It works!

AartJ said:

How such a simple posting can save a day! :-) Thanks, Bobby.

jpcansa said:

and how to remove a new line in all the cells of a entore column?

Joe said:

A simple post that can save a lot of work. Goood Post Bobby. Thanks.

Tammy said:

I guess it works for Windows, but how about when using an eMac? This would help a bunch!

Mai said:

I knew there was a way! Thanks!

Adnan said:

Thanks, dude!

Mihai said:

easy way to save the day!

Ray said:

This was annoying me so much...THANK YOU!

Suresh said:

Life saving..
Thanks a ton..

Tex said:

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..

Lila said:

I've always wanted to know how to do that! How perfect!

Tom said:

I love you. Seriously. I do.

mann said:

cool man...cool, thx a lot

Rudy said:

Radical dude!!

Riccardo said:

Great! Thanks. MS Excel Help does not help.

elma said:

amesegnalehu, anta akuay.
you saved my ...

Sarang said:

Dude...I love you!

dude said:

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.

elena said:

many thanks for this. has been trying literally for years to figure how to do that :)

John said:

I know alot about excel, but didn't know that one! Thanks for the tip!

sam said:

Two tumbs up!

John said:

Thats great!

BuckofromBruthen said:

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

Stephan said:

Thank you,

This issue has been bugging me for some time now.

Tony said:

CTRL+ALT+ENTER may also be required (instead) in some versions of OSX and Excel in order to enter lines within cells.

Kirit said:

Just great...I previously used spacebar key to go to the new line and it was very frustrating...Thank you very much!

Surya said:

Thanks! just what I was looking for!

Excel Novice said:

Thanks Bobby - you're my Excel hero!

Sachin Sharma said:

Thanks a lot for this. Saved a lot of time for me :)

Rocko said:

Thanks, great info :)
Small, but very helpful.

diablomx said:

Lol you saved the day, thanks :) Damn excel.

Lalal said:

merci!

Prasanth said:

\"Excel\"lent Bobby!

iva said:

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.

Gary said:

Merci! I am dying for it!

kamnan said:

Thanks dude. This is a great help.

Sajjad said:

Great tip, I had been looking for it for so long.

Jordan said:

Saved the day, thanks.

Prerana said:

Very helpful

billhates said:

thanks man.. this problem was killing me for long time. Stupid Micrsoft!

Jacob said:

Thanks! Very useful.

Jacob

Adumb said:

Thanks a ton Bobby! You have no idea how much this was annoying the hell outta me... :D

ruth said:

if \"iva\" uses Help so much, I wonder why she/he is reading this.

Micheria said:

Thanks alot! I was trying to figure that out for my job project.

Bjorn said:

Exactly what I needed! Thanks!

Lars said:

Truly appreciated, i have been trying to find this out for ever.

Thanks from Sweden

TJ said:

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.

Leave a comment

About this Entry

This page contains a single entry by Bobby published on March 2, 2005 12:24 PM.

First Tennessee Bank Redesign was the previous entry in this blog.

Yahoo turns 10 today is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.0