How to Create a New Line in Excel Cell (Alt + Enter!)

Yes, you can create a new line in the same cell by holding down the Alt key and pressing Enter. This is the new line combination inside a single cell in Microsoft Excel. It will allow you to start a new line within a single cell in your Excel Spreadsheet.
Go ahead, try it!

How to Create a New Line in Excel Cell
How to Create a New Line in Excel Cell?

However, if you have already typed a very long sentence in a cell, it will run over the other cells.

How to Create a New Line in Excel Cell


To make it fit inside the A1 cell, you have to click the Wrap Text icon. It is just below the Data tab in Microsoft Excel 2010. This will start a new line after every word in the sentence if it doesn't fit in the cell.

How to Create a New Line in Excel Cell with Wrap Text
Microsoft Excel 2010 Wrap Text button.

After clicking the Wrap Text button, the content of the highlighted cell will fit inside the cell. The height of the cell will expand though to accommodate all the text or any other data.

If you want to apply this setting to a lot of cells, just highlight all of them and hit the Wrap Text button again.









Daniel Gubalane Written by Daniel Gubalane - tech blogger, freelance web developer and former Physics teacher. Connect with me on Google+, Facebook and Twitter.
Published on Wednesday, July 10, 2013. Creative Commons License


Post a Comment



Pinoy Techno Guide