3

I really need to create a keyboard shortcut to move from one sheet to the next in Google Sheets in Chrome OS. In Mac this exists, but does not on Chrome OS. There is an extension called Shortcut Manager (Chrome web store) that allows you to create a javascript app to activate a shortcut, but I have no idea how to do this.

On a Mac the shortcuts are theses:

Ctrl + Shift + PageDown → Move to next sheet (Cmd + Shift + Fn + Down arrow on a Mac)

Ctrl + Shift + PageUp → Move to previous sheet (Cmd + Shift + Fn + Up arrow on a Mac)

It would be nice to have something simpler on Chrome OS. Any help would be appreciated.

2
  • 1
    @Rubén It's borderline: the answer below is specific to Google Sheets. There is some overlap between sites.
    – user79865
    Jun 19, 2015 at 1:01
  • @HomegrownTomato: You are right. I'll delete my previous comment.
    – Rubén
    Jun 19, 2015 at 3:32

2 Answers 2

3

Without installing a Chrome extension, you can use these three key combinations to go to the next sheet on Chrome OS.

  1. Alt+Shift+K (Display list of sheets)

  2. up/down key (Highlight sheet)

  3. Enter (Go to sheet)

Source.

1
  • This does work, but it's a bit tedious. The thing is that I have about 40 sheets and I need to copy something to all of them, so even though this might work, it would still take me some time to use. We really need a faster way to move from one sheet to another. If there is no way, I will have to find a script to copy something to all 40 at once. Jun 20, 2015 at 2:02
2

I found out that Search+Shift+Ctrl+Up/Down key combination on a Chromebook will go from one sheet to another.

You just have to make sure that the search button on the Chromebook is not set to Caps Lock (but rather to Search) and it will work perfectly. I found this out completely by accident. Hope it helps others.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.