Questions tagged [google-sheets]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
13 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?
0
votes
0answers
26 views

Reliable way to send sms to google sheets

apologies if this is the wrong place. I have a temperature sensor, which every hour sends an SMS to my android phone, using IFTTT this then gets sent to a google sheet, from there I have a python ...
1
vote
0answers
22 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 ...
0
votes
1answer
36 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
0answers
95 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
1answer
747 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 ...
8
votes
4answers
4k 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
2answers
3k 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
0answers
699 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 ...
21
votes
11answers
74k 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
2answers
6k 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 ...