How to Transition for Starting a New Paragraph in Excel

By Kirk Bennet

Microsoft Office Excel 2010 enables you to create complex spreadsheets for your clients, employees and investors and also enables you to open and edit existing spreadsheets. You can insert large amounts of plain text into cells in your Excel spreadsheet. You can also start new paragraphs in the same cell, if you know how to transition to another paragraph. Pressing "Enter" will create a new paragraph in most text editors, but not in Excel. In Excel, if you press "Enter" to transition to a new paragraph, you'll select the next cell in the spreadsheet.

Launch Microsoft Office Excel 2010 and create a new spreadsheet or open the spreadsheet that you want to edit.

Double-click the cell where you want to insert the new paragraph and position the insertion cursor at the end of the first paragraph.

Hold the right "Alt" key -- the one located at the right of the "Space" key -- and press "Enter" to transition to another paragraph in the same cell. You can press "Enter" multiple times to insert blank lines between your paragraphs.

Type or paste the second paragraph and press "Ctrl-S" to save the spreadsheet.


Press "Ctrl-Shift-U" to expand the formula bar and view all the paragraphs.