HomeGoogle DocsSpreadsheetStart New Lines Within a Cell in Google Sheets - Desktop and...

Start New Lines Within a Cell in Google Sheets – Desktop and Mobile

Published on

Do you know how to start new lines within a cell in both mobile and desktop apps in Google Sheets? Probably you may know how to do it in your Google Sheets desktop (Chrome) app. What about the Google Sheets mobile (Android) app?

Recently I have explained how to create a tabular form (table) using values within new lines in a cell. If you have missed that trending topic, read it here – How to Move New Lines in a Cell to Columns in Google Sheets.

In that Google Sheets tutorial, I have already ‘touched’ how to start new lines within a cell in Google Sheets. But that’s only related to the desktop app and doesn’t include the method to do the same in Google Sheets for Android.

So I thought to write this tutorial to detail how to start a new line in Google Sheets in both its mobile and desktop applications.

Starting New Lines within a Cell in Google Sheets Android

Let’s begin with inserting a new line within cells in Google Sheets Android mobile app.

I do have an Android mobile. So I opted for the Google Sheets Android app to elaborate the steps. It is a shortcut method.

There is also a formula-oriented method to start new lines within a cell in Google Sheets. That’s less popular but common for both mobile and desktop Google Sheets apps. I will detail that in the last part of this post.

Step 1:

Enter any text string in a cell and put an extra space at the position from where you want to start a new line.

Step 2:

In the second step, tap on the blinking cursor and tap “Select”.

Note:- In the screenshot below, you may read “tap” in the place of “long press”.

New Lines within Cell - Step 1 Mobile

Step 3:

After performing the above actions in your Google Sheets mobile app on Android, the screen will look like as below.

New Lines within Cell - Step 2 Mobile

Just tap enter to start a new line and type your text in the second line.

This way you can insert as many new lines as you want in your Google Sheets Android mobile app. It’s very simple, right?

New Lines within Cell in Android App in Google Sheets

How to Start New Lines within a Cell in Desktop App in Google Sheets

Unlike starting a new line within a Google Sheets cell in mobile, the desktop app is more convenient in this case.

Just type the text string in a cell (android app step 1), and instead of tap the enter key (android app steps 2 and 3), follow the below steps.

  1. If you are using Mac, use the short cut Option + Enter.
  2. On Windows, press Alt+Enter.

Note: If you check Docs Editors Help for keyboard shortcuts, you will notice that the above shortcuts are assigned to open Hyperlinks. Please don’t get confused. It works like this.

If you single click in a cell or use the arrow keys to move to a cell containing a hyperlink, after that, using the above shortcut will open the hyperlink in a new tab.

Formula Based New Lines

No matter which applications, whether it’s Android or desktop, you use. You can use the =CHAR(10) formula to start new a line within a cell in Sheets. See how?

The following CHAR formula will place the strings “Apple”, “Orange”, “Banana” in three lines within a cell.

="Apple"&char(10)&"Orange"&char(10)&"Banana"

Insert the &char(10)& formula between strings to start new lines within a cell in Google Sheets Android as well as desktop apps.

You May Like:

  1. Inserting Bullet Points in Google Sheets.
  2. 5-Star Rating in Google Sheets Including Half Stars.
  3. Insert Special Characters Without Add-on in Google Sheets.
Prashanth KV
Prashanth KVhttps://infoinspired.com/about-me/
Introducing Prashanth KV: Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Creating a Running Balance with Dynamic Array Formulas in Excel

For calculating a running balance, we can utilize the SCAN function, which is a...

Comparing the FILTER Function in Excel and Google Sheets

I believe comparing the differences in how the FILTER functions work in Excel and...

Quartile IF in Google Sheets

To calculate quartiles based on conditions, referred to as "Quartile IF," we will use...

Drop Rows and Columns by Index Numbers in Google Sheets

With the help of two simple custom formulas, we can drop rows and columns...

More like this

Quartile IF in Google Sheets

To calculate quartiles based on conditions, referred to as "Quartile IF," we will use...

Drop Rows and Columns by Index Numbers in Google Sheets

With the help of two simple custom formulas, we can drop rows and columns...

Reference a Column by Field Label in Google Sheets QUERY

Here we'll explore the two best methods for referencing a column by its field...

LEAVE A REPLY

Please enter your comment!
Please enter your name here