Related Articles
- 1 Make a Break in Excel
- 2 Find the Y-Intercept of a Line of a Graph in Excel on a Mac
- 3 Add Paragraph Breaks in Cells in Excel for OS X
- 4 Keep a Word on a Line in MS Word
Often when you're entering data into a Microsoft Excel spreadsheet, you want certain cells to span multiple lines, either for addresses, multiline pieces of information or just for readability. But if you press enter in an Excel cell, it will move you to the next cell down rather than inserting a line break.
Start a new line of text inside a cell. You can start a new line of text or add spacing between lines or paragraphs within a cell in Excel Mobile for Windows 10, Excel for Android devices, and Excel for iPad, Note. Press and hold the return key to view the line break key, and then drag your finger to that key.
Tip
To create a new line in an Excel cell, hold down the alt key on your keyboard while hitting enter.
Insert Line Break in Excel
To move to a new line in an Excel cell, simply type text in the cell as normal and then press enter while holding down the alt key. If you need to move to a specific place in the cell to enter a new line, double-click the cell with your mouse and then click the specific place you want to enter the line break. Then hit enter while holding down alt.
If you need to have a formula output break onto a new line to go into an Excel cell, you can do this as well. To do so, include in the formula the bit '& CHAR(10) &' wherever you want the formula's output to break lines if you're using Windows. That tells Excel to insert the character numbered as 10 in the computer's character set, which on Windows is a line break character. If you're using a MacOS computer, use the number 13 rather than 10 for the same effect.
Wrapping Text in Excel
In some cases, you may have too much text in an Excel cell to fit on one line. In this case, you may want the text to wrap onto another line automatically. To enable this feature, select the cells that you want to automatically wrap. Then, on the 'Home' tab in the ribbon menu, click 'Alignment,' then the 'Wrap Text' button.
My mac keeps asking for my facebook password. It says to enter it in Internet accounts. It was the correct one and then I even changed it. It won't accept it. Go back to the Mail app Preferences by pulling down the Mail menu and choosing “Preferences”. Select the “Accounts” panel from preferences window. Choose the mail account that is throwing password errors. Under the ‘Account Information’ tab, click on “Outgoing Mail Server (SMTP)” and choose “Edit SMTP Server List”. Click the ‘Advanced’ tab. 
If the cell's height is not fixed, the text will automatically wrap from line to line and all the text should be visible. If you need to adjust the cell's height, you can physically drag the edges of the cell using your mouse or using the Cell Size menu.
To do that, select the cells you're interested in and click the 'Home' tab.' Click the 'Cells' group, then click 'Format' and under 'Cell Size,' click 'AutoFit Row Height' to make the cell automatically adjust its height.
If you'd prefer to have a fixed height that might not contain all the text, click 'Row Height' instead of 'AutoFit Row Height' and enter your desired height.
References (4)
About the Author
Steven Melendez is an independent journalist with a background in technology and business. He has written for a variety of business publications including Fast Company, the Wall Street Journal, Innovation Leader and Business BVI. He was awarded the Knight Foundation scholarship to Northwestern University's Medill School of Journalism.
Cite this ArticleChoose Citation Style
