How to Write Paragraphs in Excel & Google Sheets
Written by
Reviewed by
This tutorial demonstrates how to write paragraphs in Excel and Google Sheets.
Write Paragraphs With Line Breaks
When you type text into a cell that runs over into the adjacent cell, and the right adjacent cell is empty, then the text usually flows into the empty space. To confine the text to a single cell, size the cell accordingly and wrap the text.
To continue typing in the same cell with a second paragraph, insert a line break into the cell.
- Type the first paragraph, then press ALT + ENTER to insert a line break. If you wish to insert a blank line between the paragraphs, press ALT+ENTER again.
- Type in the second paragraph in your cell.
- Press ALT + ENTER twice once again and then type the third paragraph into your cell.
- When you press ENTER, the height of the cell changes automatically.
Note: Instead of typing directly into the cell, you can expand the formula bar by dragging the bottom of the formula bar down, and then type directly into the formula bar.
Paragraphs in a Text Box
An alternative way to create paragraphs in Excel is to insert a text box and type into the box.
- In the Ribbon, go to Insert > Text > Text Box.
- Click and drag to draw a text box in your worksheet.
- You can now type in the text box using just the ENTER key to separate individual paragraphs.
- If there’s too much text to fit, size the text box using the handles around the box.
- You can also use a right-side handle to increase the width of the text box.
Write Paragraphs in Google Sheets
Google Sheets also uses ALT + ENTER to put multiple lines into a cell and create paragraphs.
As with Excel, if you wish to view the entire paragraph in the formula bar, increase the size of the formula bar by dragging the bottom cell border down.
Text Box
To insert a text box into Google Sheets, create a Drawing.
- In the Menu, go to Insert > Drawing.
- Select the Text box icon and drag to create a text box.
- Type the paragraphs.
- Click Save and Close to return to the worksheet.