How do I start new line in cell?

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

Microsoft Excel
Google Sheets
OpenOffice Calc

Microsoft Excel

In the Microsoft Excel spreadsheet program, press Alt + Enter to create a new line within 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 device users 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 within 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 within the same cell. You can create many new lines in a cell by repeatedly pressing the Ctrl + Enter key combination.





PinIt
submit to reddit

Leave a Reply

Your email address will not be published. Required fields are marked *

Top
Web Design BangladeshWeb Design BangladeshMymensingh