SubscribeUse Alt+Enter to get multiple lines in a cell [spreadcheats]
A very quick spreadcheat for Friday. If you need to type content in a cell and you want to see it in multiple lines then use alt + enter to break the content in several lines. See to the right for an example.
Bonus tip: If you are using formulas to create content in a cell by combining various text values and you want to introduce line breaks at certain points … For eg. you are creating an address field by combining house number, street name, city and zip code and you want to introduce line breaks after house number and street name then you can use CHAR(10). Like this:
=housenumber & CHAR(10) & streetname & CHAR(10) & city & zipcode
Remember when you do this, you need to enable wrap-text feature for that cell from cell formatting dailog (ctrl+1) to ensure proper display.
|
Trackbacks & Pingbacks
- Pingback by Become an Excel Guru in 31 Days | Pointy Haired Dilbert: Learn Excel Online - Chandoo.org on March 11, 2010 @ 9:52 am
Comments
RSS feed for comments on this post. TrackBack URI
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 350+ articles and tutorials on using excel, making better charts. 
@Chandoo:
One more useful trick…….
In a column you have no. of data in rows and need to copy in the next row from the previous row, no need to go for the previous rows but entering Alt + down arrow, you will get the list of data, (in asending order), entered in the previous rows…
This is another great tip. I use this all the time to make sense of some *very* long formulas. As soon as the formula is debugged I remove the break.
Great tip Chandoo!
I use this feature often and it has even gotten the, “how did you do that” response.
Thanks!
@Ketan: Alt+down arrow is an awesome tip. I never knew it and now I am using it everyday.
@Jorge, Tony: Agree…