Android Enthusiasts Stack Exchange
Android Enthusiasts Stack Exchange

Questions tagged [google-sheets]

19 questions
36
votes
8 answers

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 do I enter a new line on my Android device? For a…
Questioner
  • 3,789
  • 23
  • 64
  • 89
11
votes
5 answers

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?
Julio Prada
  • 111
  • 1
  • 3
6
votes
1 answer

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?
aronisstav
  • 163
  • 1
  • 5
4
votes
2 answers

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 Gingerbread and has a spreadsheet file in it. When…
Abed
  • 171
  • 1
  • 4
  • 6
4
votes
1 answer

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 as a widget. Only thing I found that seemed to be…
mikibok
  • 63
  • 6
3
votes
2 answers

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 option, so I switch back to text keyboard, and we…
Ash
  • 131
  • 3
  • 11
2
votes
1 answer

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 sequence I currently use to force the app to save…
Steve
  • 250
  • 2
  • 3
  • 12
1
vote
1 answer

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?
peterK88
  • 111
  • 1
1
vote
1 answer

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 described here, because at point 4. there just is no…
Lester
  • 133
  • 1
  • 5
1
vote
1 answer

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 add up the the different amounts in the 'amount' in…
Tom James
1
vote
0 answers

Google Sheets on Android: frozen column can't be resized?

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 to expand the frozen columns so that I can see…
Daniel
  • 291
  • 3
  • 9
1
vote
0 answers

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 shortcut on their Android Phone (LG G7 ThinQ). When…
Dan Nick
  • 111
  • 1
1
vote
1 answer

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 all 2,500 rows. On a computer, this would be a…
user192390
  • 11
  • 1
  • 3
1
vote
3 answers

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 do not have access to one. Any help?
Austin Griner
1
vote
0 answers

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", "2", and then extend to 80 by dragging down to…
samyb8
  • 141
  • 3
1
2