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?

4 Answers 4


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

Ctrl + down arrow

  • Ctrl+End too, I would think. (At least for this use case.)
    – ale
    Commented Jun 28, 2013 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. Commented Aug 3, 2014 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. Commented Aug 8, 2015 at 9:18

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

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.


If you have lots of gaps in the column

ctrl + end - takes you to the far right lowest cell

followed by

ctrl + left - takes you to the far left lowest cell ( Optional right to the column you want, if it is not the first.)


ctrl + up - takes you to the far left lowest cell with a value.

then down - takes you to the next empty cell.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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