2

Say I am on A1, and I want to instantly go to/highlight/focus Z99. How would I go to that cell ID (or row/column) with a keyboard shortcut or within the menu or context menu?

There is Ctrl+G for Excel but that only opens a find box in Google Sheets. It doesn't seem like this feature exists as I have searched for a bit now, but hopefully it does.

3

Google Sheets doesn't have a similar shortcut.

You could create a macro / script, a URL query, or use an add-on that add this feature.

URL query

Maybe the easiest is to use a URL query, on the browser address bar just add &range=Z99 to the spreadsheet URL and press enter.

Macro / Script

Please read Extending Google Sheets and Google Sheets Macros

Here is a simple script. Adopters could add the validations that works best for them.

If we add it as a macro we could assign a keyboard shortcut to call it in the form Ctrl + Alt + Shift + Number (Tools > Macros > Import then Tools > Macros > Manage Macros).

function GoTo() {
  var spreadsheet = SpreadsheetApp.getActive();
  var Ui = SpreadsheetApp.getUi();
  var buttons = Ui.ButtonSet.OK_CANCEL;
  var response = Ui.prompt('Go to', 'Where do you want to go?', buttons);
  if(response.getSelectedButton() === Ui.Button.OK){
    var address = response.getResponseText();
    spreadsheet.getRange(address).activateAsCurrentCell();
  } 
};

Gist

Reference

  • Thanks, the URL query is doable for now. I am still quite surprised that they don't have this feature. Can I really be one of the few who would use this feature? Now I am wondering if a macro do a pop up? And can a macro do a keyboard shortcut? – Elijah Lynn May 2 '18 at 1:16
  • Macros do pop ups, but you should edit the macro to add the pop up, and the do a keyboard shortcut – Rubén May 2 '18 at 2:32
  • @ElijahLynn I added the code of a macro. – Rubén May 2 '18 at 2:50
  • Thanks, this is very useful until their is native goto! I got it working and now ctrl + alt + shift + 1 brings up the popup, enter the cell, then tab, enter and done. – Elijah Lynn May 3 '18 at 4:38

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.