Start a new line of text inside a cell in Excel Excel 2013 Click the location inside the cell where you want to break the line or insert a new line and press Alt+Enter. Replied on October 16, 2017. In reply to Praveena S S's post on October 16, 2017. Try this one: - Windows Key + ALT + ENTER. If my reply answers your question then please mark as 'Answer', it would help others to find their solution easily from your experience. 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. How to move down a line in a cell within Microsoft Excel. In Google Sheets, press Ctrl+Enter to create a new line in the same cell. You can create many new lines in a. I am trying to create a new line of text inside a cell, but the Alt + Enter shortcut isn't working for some reason? I suspect my setup may be part of the issue. I'm using Citrix to remote access my work computer and running the Excel 2016 application in Windows 10. My host computer is a Macbook! Start a new line of text inside a cell in Excel. To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break. Click the location inside the selected cell where you want to break the line.

This is a bit of a quickie tip but I scratched my head on it for a few hours one day.

If you use Office:Mac Excel, you may from time to time need to capture multiple lines of information into a cell. If you come from the Windows world, you will quickly come to realize that Alt+Enter doesn’t work.

If you want to insert a new line in Excel for the Mac, select the cell, type your first line and press Alt+Cmd+Enter.

There you have it, insanely easy.

It’s your turn!
If you have questions on how to do things in Excel ask them in the comments and I’ll try to answer them for you.

It is possible to start a newline in a cell in nearly all spreadsheet programs. However, there's 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 want 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.

Microsoft Excel Enter New Line In Cell

Google Sheets

Microsoft Excel New Line In Cell

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.

Microsoft Excel New Line In Cell Number

Additional information

See our cell and new line definitions for further information and related links.