1

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.

1
  • 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).
    – Arctiic
    Jul 1, 2019 at 7:29

1 Answer 1

1

Here is how you can select a range when using Google Sheets:

  1. Select a row or cell.
  2. Click the 3-dot on the top right, then select "Select cell or range".

  3. Enter your range. For example 1:2500 will select row 1 to row 2500.

  4. Click Ok. Done.

15
  • 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.
    – user192390
    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
  • I am using 1.19.232.06.35.
    – user192390
    Jul 2, 2019 at 15:13
  • My version seems to be a later one. Why would a later version have less functionality?
    – user192390
    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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .