How to move to the last active row in a Google Spreadsheets

Question

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?

Answer 1

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

Ctrl + down arrow

Answer 2

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

Answer 3

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.

Answer 4

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.)

then

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

then down - takes you to the next empty cell.