Google sheets jump to cell

Question

I only complete entries in e.g. columns A to R, I would then like to automatically jump back to the next free cell in column A. This is in a shared sheet. Can anyone tell me how to do this as a complete novice?

Also when I first open the sheet I would also like it to go to the first free cell in column A.

I have tried looking through many answers and can see several questions asking the same but can't seem to get anything that actually does what I want.

I would need detailed instructions.

Thanks for any help anyone can give.

If one of the posters answered your question, please select it as The Answer, @J-A. — MXMLLN, Jul 15 '19 at 09:28

score 7 · Answer 1 · answered Apr 12 '18 at 07:46

You should write custom js code in script editor.

function onOpen() {
  var spreadsheet = SpreadsheetApp.getActive();
  var menuItems = [
    {name: 'Go To End', functionName: 'goToEnd'}
  ];
  spreadsheet.addMenu('My Menu', menuItems);
}
function goToEnd() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();  
  var lastRow = sheet.getLastRow();
  var lastColumn = sheet.getLastColumn();
  var lastCell = sheet.getRange(lastRow, lastColumn);
  //Browser.msgBox('values: ' + lastRow + '-' + lastColumn);
  sheet.setCurrentCell(lastCell);
}

For more Google App Scripts

score 4 · Answer 2 · answered Jun 15 '17 at 14:40

There's a great video here that shows how you can do this.

If you're not into watching the video:

Open this Gist here.
Open Google Sheets.
Go to Tools -> Script Editor.
Enter the script (replace the text that appears there), and save it as something like goToCell.
Refresh Google Sheets. A menu appears, goToCell.
Open it, and follow prompts to authorise it.

Now you have a goToCell menu option.

score 1 · Answer 3 · answered Jul 15 '19 at 09:33

Have you tried using shortcut keys, specifically Ctrl + Left ? Ctrl + Left selects the next empty cell to the left or the final cell in the row.

Once the user has filled in columns A - R, pressing Ctrl + Left will take them to column A.
Then pressing Ctrl + Down will take them to the first row with an empty A cell.

Sometimes a simpler solution is best. This answer is ported from Doc Editor Help.

Google sheets jump to cell

3 Answers3

Linked