Questions tagged [google-sheets]
The google-sheets tag has no summary.
22 questions
0
votes
1
answer
31
views
Using CTRL key to select multiple individual cells on Android
I have an external keyboard I use on my Android devices, I need to use Google Sheets to make some spreadsheets, I need to use the CTRL key to select multiple individual cells (not a range of cells), ...
1
vote
1
answer
39
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
76
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
48
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
242
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
11
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
44
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
55
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
465
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
394
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 ...