Questions tagged [google-sheets]
The google-sheets tag has no summary.
21 questions
0 votes
0 answers
24 views
Google Sheets spreadsheets opened via Android app remains in read-only mode
Occasionally, spreadsheets opened via the Google Sheets Android app remain in read-only mode. I ensured that I have editing permissions. If I open the same spreadsheets using a laptop and the web ...
0 votes
1 answer
71 views
Google sheets filter not functioning on mobile
I am trying to make a calendar also automates a to do list. (why we are doing this in google sheets and not an app that does so easily for free is an excellent question that I have no answer to. Like ...
0 votes
0 answers
44 views
Is there a way to do DATA formatting for Google Sheets on a Galaxy Tablet?
I cannot find any user interface for Google Sheets on a Samsung Galaxy Tablet. There are plenty of options for changing fonts, colors, etc. but formatting DATA (date formats, currency formats, etc.) ...
2 votes
1 answer
232 views
When I freeze the first two columns of a sheet only the first column is visible in the mobile application
Google Sheets for Android only displays the first frozen column. The second and subsequent frozen columns are not visible. How can I unhide them?
4 votes
1 answer
2k views
Google Sheets cell value as a widget
I would like to have some value from a cell in a google spreadsheets that is displayed on my android phone, a little bit like a KPI that I can track. So I thought that there must be a way to add this ...
1 vote
1 answer
4k views
Cannot change number format in Google Sheets, "Cell" tab is missing
I have Pixel 7 and Google Sheets (version 1.24.062.03.90). It seems like the option to format cells is gone. This is how it looks after I tap the Format icon "A≈". It does not work like ...
1 vote
1 answer
8 views
Adding a total in a cell when a checkbox is ticked in an adjacent cell
On my budget spreadsheet, in the 'amount' column is the different direct debits going out each month, then I tick the checkbox in the 'gone out?' column when it goes from my account. I'm wanting to ...
0 votes
0 answers
42 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
53 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
3k 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
3k 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
464 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
8k 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
385 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 ...