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

September 2016


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 :

This document entitled « Excel, Libre Office and Google Sheets - How to write multiple lines in a cell » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.