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

Visit http://www.TeachMsOffice.com for 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!

Category:

Education

Tags:

• excel
• text
• multiple
• lines
• enter
• alt
• cells
• paragraph
• formatting

[jammiemantis]

You are a lifesaver. Thank you.. I'm just a total noob at this

[TheMissionette]

Just what I needed to know! Thank you~

[adel4017]

Thanks!!



[Whisperland]

Thanks! On the Mac, I found out you have to hold down both the OPTION and COMMAND keys and press Return (Enter).

[yaseen638]

Thank you very much

[ufidaf815]

Thank you. This vid will help.

[mstabspeople]

Thanks for the vid, i never had to do this before today and i needed it done very quickly. This vid saved me time i didn't have!