How to Put Multiple Lines of Writing in Each Cell

By Kate Bluest

You can enter multiple lines into a single cell using one of two methods. The first method is using a keyboard combination. Using the keyboard combination method, not only will the text appear wrapped in the cell, it will also appear wrapped in the formula bar at the top of the page. If you format the cell using "Wrap Text," the text will be on multiple lines in the cell, but a single line in the formula bar.

Microsoft Excel

Step 1

Use ALT+ENTER to enter multiple lines of writing in a cell. Open Microsoft Excel. Double-click in the cell in which you want to enter multiple lines. Type the first line and hold down the "Alt" key and hit the "Enter" (ALT+ENTER) key and type the next line. Repeat these steps to enter additional lines into the cell.

Step 2

Format the cell using "Wrap Text." Select the cells in which you would like to put multiple lines of writing. Click the "Home" tab found at the top of the Excel spreadsheet. Click the arrow in the lower-right corner of the "Alignment" section of the "Home" tab to open the "Format Cells" dialog box.

Step 3

Click the "Alignment" tab. Place a check in the "Wrap text" check box in the "Text control" section of the "Alignment" tab in the "Format Cells" dialog box. Click the "OK" button in the lower-right corner of the "Format Cells" dialog box when you are done. Now when you type in these cells, text will automatically wrap when it reaches the right wall of the cell.

Google Docs Spreadsheet

Step 1

Go to Google Docs. Click the "Create New" button on the top-left side of the page and select "Spreadsheet" from the pull-down menu.

Step 2

Use ALT+ENTER to put multiple lines of writing in a cell. Double-click in the cell in which you want to enter multiple lines. Type the first line and hold down the "Alt" key and hit the "Enter" (ALT+ENTER) key and type the next line. Repeat these steps to enter additional lines into the cell.

Step 3

Format the cell using "Wrap Text." Select the cells in which you would like to place multiple lines of writing. Click the "Wrap Text" icon in the top menu. It has three lines and an arrow that bends to point to the left. When you hover over it, the "Wrap Text" label will appear.

Open Office Spreadsheet

Step 1

Use CTRL+ENTER to enter multiple lines of writing in a cell. Open OpenOffice Calc. Select the cell in which you want to enter multiple lines of text. Type the first line and hold down the "CTRL" key and press the "ENTER" key (CTRL+ENTER). Repeat these steps to enter additional lines into the cell.

Step 2

Format the cell using "Wrap Text." Open OpenOffice Calc. Select the cell or cells you would like to format for multiple line writing. Select "Format" from the top menu and select cells from the pull-down menu to open the "Format Cells" dialog box.

Step 3

Click the "Alignment" tab in the "Format Cells" dialog box. Place a check in check box next to the "Wrap text automatically" option in the "Properties" section of the "Alignment" tab in the "Format Cells" dialog box. Click the "OK" button at the bottom of the "Format Cells" dialog box to close the dialog box and apply the settings when you are done.