Questions tagged [google-sheets]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
158 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 ...
0
votes
0answers
691 views

How to select multiple individual cells in Google Sheets Android app on mobile phone?

How to select multiple individual cells in Google Sheets Android app on mobile phone? Example: On Windows it is possible by using the CTRL button + left mouse button and select multiple cells, but I ...
2
votes
1answer
720 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
0answers
216 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
1answer
1k 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
285 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
3answers
3k 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 ...
9
votes
5answers
7k 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
4k 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
122 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 &...
1
vote
0answers
961 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 ...
29
votes
8answers
124k 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
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 ...