Excel, Libre Office and Google Sheets - How to write multiple lines in a cell

May 2017


Excel, Libre Office and Google Sheets - How to write multiple lines in a cell


Although spreadsheet programs are not originally designed to contain lengthy text, in some situations you might need to write multiple lines in a single cell. Here's how to proceed:

Excel

  • Press Alt + Enter to move the cursor to another another line.

Libreoffice

  • Press CTRL + Enter to move the cursor to another another line.

Google Sheets

  • Press ALT + Enter to move the cursor to another another line.

Related


Published by jak58. Latest update on September 26, 2014 at 08:24 AM by jak58.
This document, titled "Excel, Libre Office and Google Sheets - How to write multiple lines in a cell," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).