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 breeze with the Shift key. How to accomplish something similar in Android Sheets? The keyboard doesn't open unless I'm editing a cell, so any keyboard-based solution seems to be a non-starter. Thanks.
-
Looks like someone already has an answer! I also had a couple of thoughts, but I'm an Excel user and I'm not completely sure G Sheets will have equivalent functionalities or not: 1) Pre-define the selection range up to the desired row as a named range, then select the range. 2) Utilize any keyboard app example to circumvent keyboard limitation you mention (Android Excel app also has a button to bring up the on-screen keyboard).– ArctiicJul 1, 2019 at 7:29
1 Answer
Here is how you can select a range when using Google Sheets:
-
My menu does not show Accessibility Settings and does not show Select cell or range. Why would those items be missing from the menu? Thanks. Jul 2, 2019 at 14:00
-
@ibc I am using version 1.19.232.06.34. Is the version the same as yours? Jul 2, 2019 at 14:11
-
-
My version seems to be a later one. Why would a later version have less functionality? Jul 2, 2019 at 15:25
-
Yes, yours is a newer version compared to mine, and yet those settings don't appear. Jul 2, 2019 at 15:30