Questions tagged [google-sheets]
The google-sheets tag has no usage guidance.
15
questions
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, ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 &...
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 ...
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 ...
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 ...