0

I have a Google Spreadsheets where I log some data with time stamps. It's getting really long. Every time I open it up, I have to scroll all the way to the bottom and find where I left off. I tried How to move to the last active row in a Google Spreadsheets, but it didn't work.

Is there a way to quickly jump to the last row where data was entered, so I don't have to always scroll all the way to the bottom?

2

There are shortcut navigation keys here including navigation keys for a Mac:

Move to beginning of row                Fn + Left arrow  
Move to beginning of sheet              ⌘ + Fn + Left arrow  
Move to end of row                      Fn + Right arrow  
Move to end of sheet                    ⌘ + Fn + Right arrow  
Scroll to active cell                   ⌘ + Backspace  
Move to next sheet                      ⌘ + Shift + Fn + Down arrow  
Move to previous sheet                  ⌘ + Shift + Fn + Up arrow  
Display list of sheets                  Option + Shift + k  
Open hyperlink                          Option + Enter  
Open Explore                            Option + Shift + x  
Move focus out of spreadsheet           Ctrl + ⌘ + Shift + m  
Move to quicksum
(when a range of cells is selected)     Option + Shift + q  
Move focus to popup
(for links, bookmarks, and images)      holding Ctrl + ⌘, press e then p  
Open drop-down menu on filtered cell    Ctrl + ⌘ + r  
Open revision history                   ⌘ + Option + Shift + h  
Open chat inside the spreadsheet        Shift + Esc  
Close drawing editor                    ⌘ + Esc  
                                        Shift + Esc

So maybe ⌘ + Fn + Right arrow and if that takes you too far to the right, follow up with Fn + Left arrow.

| improve this answer | |
1

this script will jump on the last empty row everytime you open your spreadsheet (or press F5)

function onOpen(e) {
  var spreadsheet = e.source;
  var sheet = spreadsheet.getActiveSheet();
  var lastRow = spreadsheet.getLastRow();
  if (sheet.getMaxRows() == lastRow) {
    sheet.appendRow([""]);
  }
  lastRow = lastRow + 1;
  var range = sheet.getRange("A" + lastRow + ":A" + lastRow);
  sheet.setActiveRange(range);
  }
| improve this answer | |
  • @user194683 take this script if you need – user0 Sep 7 '18 at 19:34
0

One solution would be to use Filter by condition. You probably have a date column in this spreadsheet. Use a filter on that column to define that only the last 30 days, or so, are shown by default. Then the last entered row would always be visible.

| improve this answer | |
0
⌘ (Command) + ↓ (Down arrow) - On Mac

^ (Ctrl) + ↓ (Down Arrow) - On Windows

To go to the edge of the data in the downward direction. You may change the arrow direction to move to the edge in any direction.

Edge of the data refers to the last row (or column) of the data (or empty) block.

| improve this answer | |
-4

Ctrl - down arrow should work.

| improve this answer | |
  • The question says "on a Mac" – user135384 Dec 20 '17 at 16:44

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.