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”.
Step 3:
After performing the above actions in your Google Sheets mobile app on Android, the screen will look like as below.
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?
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.
- If you are using Mac, use the short cut
Option + Enter
. - 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: