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 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.
Here is how you can select a range when using Google Sheets:


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


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


Click Ok. Done.