Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell

VBA/Macros Course (80% Discount): https://www.teachexcel.com/vba-course...


Excel Forum: https://www.teachexcel.com/talk/micro...
More help: https://www.teachexcel.com
More, including Excel Consulting, Macros, and Tutorials.

Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel.

This method of entering text into cells allows you to avoid using the text box to enter large amounts of text in Excel.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!