Questions tagged [google-sheets]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
33 views

Script trigger works on Google Sheet but is not getting called on Android mobile app, including onEdit

I have created a simple function in google apps script which work seamless on Browser, but not working on Google sheets' Android App or iOS Tablet. After exploring, tried the onEdit(e) function too, ...
user avatar
0 votes
0 answers
8 views

Texts in some cells arent displayed fully in Android google sheets app?

I have a Google Sheet with many cells that contain a lot of text. Those cells have their formatting set to "wrap" and they display as expected in the Web Application (Chromium-based Whale ...
user avatar
1 vote
0 answers
22 views

Google Sheets on Android: frozen column can't be resized? [duplicate]

I wished to freeze the first 2 columns in Google Sheets on Android: However, after freezing, these frozen columns will get a fixed width, and I can't change it (although I have a scrollbar). I wish ...
Daniel's user avatar
  • 281
0 votes
3 answers
2k views

In Android Google Sheets, "enter key" (->|) won't move to cell below. How to fix?

I don't know when or how I changed the behavior of the "enter key" (->|) in Google Sheets for Android. It used to enter the text I was typing (if any) into the current cell and then move ...
DSlomer64's user avatar
  • 101
6 votes
1 answer
2k views

How to resize the width of several frozen columns in Google Sheets app?

I am using Google Sheets on Android and have several columns frozen on the left, but the app seems to have a fixed width for the frozen columns. Is it possible to change this width?
aronisstav's user avatar
1 vote
0 answers
394 views

Google Sheets Read Only on Android

I created a spreadsheet in Google Sheets. I shared the link with two users. They can click on the link in the e-mail and can edit the spreadsheet with no issue. However, one of the users created a ...
Dan Nick's user avatar
  • 111
1 vote
1 answer
4k views

How do you select a large number of rows in Google Sheets without endless scrolling downward after selecting the first row?

In a spreadsheet of 40,000 rows, I want to select the first 2,500 rows to copy them to another sheet. The only way I've seen is to select the first row and tediously scroll the "dot" down to include ...
user192390's user avatar
0 votes
0 answers
326 views

dd/mm date format on android in xlsx files

I'm just starting to use mobile documents using google sheets but am struggling with date formats. I am in the UK so use dd/mm/yyyy in excel, but when files are saved to drive and opened in sheets on ...
user avatar
1 vote
3 answers
5k views

Google Sheets Android - Continuing Formulas

I have the formula B6=((A6/A4)*B4)+A2 and I want to copy it throughout the rest of the column so that: B7=((A7/A4)*B4)+A2,B8=((A8/A4)*B4)+A2, and so on. I know how I would do this on a computer but I ...
user avatar
11 votes
5 answers
9k views

Insert today's date in Google Sheets

I use Ctrl+; to insert today's date since my Microsoft Excel times, but how do I do it in Google Sheets app on my Android phone, without a keyboard?
Julio Prada's user avatar
3 votes
2 answers
5k views

No decimal input on numeric field when using Google Sheets on phone

In Google Sheets, when I add a number (e.g. 1.01) using the text keyboard and hit Enter, this numeric keyboard pops up as a default because the field is numeric. However, I do not have a decimal ...
Ash's user avatar
  • 131
1 vote
0 answers
139 views

Create a range of numbers with Google Sheets

I am trying to create a simple range of numbers on Google Sheets in Android the same way you would do it on a computer: drag the corner spot down selecting 2 consecutive numbers. So I would input &...
samyb8's user avatar
  • 131
2 votes
1 answer
1k views

How can I force the Google Sheets app to update to the server?

I have been using the Google Sheets app a lot on my Android phone, and I have discovered that if I don't force the app to store the spreadsheet to the server, it sometimes loses updates. This is the ...
Steve's user avatar
  • 250
34 votes
8 answers
144k views

How do I enter a new line in a cell in Google Sheets?

When accessing a spreadsheet in Google Drive on a computer with a keyboard, I can enter a new line in a single cell by pressing alt+enter. My keyboard on my Android doesn't even have an alt key. How ...
Questioner's user avatar
  • 3,699
4 votes
2 answers
7k views

How to add new rows on a Google Docs spreadsheet?

Usually, in desktop version of Google Docs spreadsheet, I will enter a number of new rows if current document has no rows remaining, so I can extend down the document. I installed Google Drive on my ...
Abed's user avatar
  • 171