Get our new Windows 7 eBook (PDF) for $7 with 70+ Tips. Download Now!
Add A Line Break To A Cell In Excel 2007
- 8
- Add a Comment
- No Related Post
In most word applications, pressing Enter moves the cursor to the next line. This is not the case in Excel, which at times seems to have a mind of its own. When you press Enter in Excel, it does not add a line break within a cell. Instead, it moves the cursor to the cell below.
If you’re rather new to Excel, this can become a bit of an annoyance as you try to enter in data. The trick to this is that if you want to add a line break within a cell, press Alt + Enter, instead of just Enter.
[tags]Microsoft Office, Excel, Microsoft Excel, Excel 2007[/tags]
8 Comments
Bill Ardis
May 18th, 2007
at 10:30am
great excel tip, thank you!
Trevel
May 22nd, 2007
at 7:14am
A lot of programs are like that — or Ctrl-Enter. Any time you want to put in a line break, try one of those. I tend to use it a lot in instant messaging.
Glenn
October 18th, 2007
at 1:36am
Thanks!!!
I was setting up a weekly report and could not figure it out!!
You saved me a lot of time and my keyboard
Lobo1969
November 7th, 2007
at 10:03am
Your just saved my day. Thank you very much for the great tip.
Stephanie
December 18th, 2007
at 10:30am
This kind of works, but it doesn’t if that cell spans multiple columns. Try it out. It will force the Wrap Text property on the cell, then when you go to take that off, it takes away the line break as well. Anyone know the work around? It’s only in Excel 2007 as far as I can tell.
Emily
September 11th, 2008
at 11:04am
Press cntrl + option + enter. This worked for me.
Michael
March 17th, 2009
at 8:00pm
Thank you, this was exactly what i was looking for.
Pete
July 7th, 2009
at 3:43pm
Thank you Emily, Cntrl+Option+Enter worked, but I swear I could hit Alt+Enter in the past in 2007. And the cell I’m trying to use doesn’t go across columns… thoughts?