How to start new line in a spreadsheet cell

Updated: 03/01/2018 by Computer Hope
An example of a newline ing a spreadsheet cell.

It is possible to start a newline in a cell in nearly all spreadsheet programs. However, the process has a bit more to it than pressing Enter and varies a bit depending on the software you are using. The following sections detail how to start a new line in a cell in several of the different spreadsheet programs available to users. To proceed, locate the spreadsheet program you'd like instructions for and follow the directions.

Microsoft Excel

In the Microsoft Excel spreadsheet program, press Alt+Enter to create a new line in the same cell. You can create many new lines in a cell by repeatedly pressing the Alt+Enter key combination.

For early versions of Excel, Apple computers, and other devices using Excel, see the link below for further information and help with moving down a line in Excel.

Google Sheets

In Google Sheets, press Ctrl+Enter to create a new line in the same cell. You can create many new lines in a cell by repeatedly pressing the Ctrl+Enter key combination.

OpenOffice Calc

In the OpenOffice Calc spreadsheet program, press Ctrl+Enter to create a new line in the same cell. You can create many new lines in a cell by repeatedly pressing the Ctrl+Enter key combination.

Additional information