Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 7 down vote accepted

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

Ctrl + down arrow

share|improve this answer
Ctrl+End too, I would think. (At least for this use case.) – Al E. Jun 28 '13 at 12:36
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

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
share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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