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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
My solution in the absence of other shortcuts:
Here's my simple way of going to the last row in a Google Sheet:
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
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.