6

I am using a Google Form to insert data into a Google Spreadsheet.

Is there a shortcut to move to the last row where data is entered?

8

"Is there any shortcut to move to the last row where data is entered?"

Ctrl + down arrow

| improve this answer | |
  • Ctrl+End too, I would think. (At least for this use case.) – ale Jun 28 '13 at 12:36
  • 2
    Ctrl+End doesn't seem to work, and Ctrl + down arrow does not jump to the last row where data is entered, but to the next row with a blank cell that follows. – Franck Dernoncourt Aug 3 '14 at 0:40
  • Yes, if there's a blank cell inbetween, it will stop at that row. A workaround could be to move the cursor to a column that is always filled with data, like a timestamp column. – Martin Hansen Aug 8 '15 at 9:18
1

My solution in the absence of other shortcuts:

  1. Create a new column at the very left side (Column A)
  2. Insert text in the 1st box (I use letter 'x')
  3. Drag down to the last row of your sheet to create a column of 'x's
  4. When you open the sheet, it goes auto to row 1 column A. Use the Ctrl+ keys to go to the last entry
  5. Make sure you always drag to the last row of entered values before you leave so that next time you open the shortcut works well
  6. If the x bothers you, dim it with light font
| improve this answer | |
1

Here's my simple way of going to the last row in a Google Sheet:

  1. Insert "xxx" or any other unique string of characters in the last rown of your spreadsheet (leave some empty rows above where you put the xxx).
  2. Type "CTRL F" to start up the Find dialogue box.
  3. Type "xxx" and hit Enter. Bingo you're in the last row of the spreadsheet.

As you fill in the last row with data, just move the "xxx" to a (much) lower row.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.