30

Does anyone know if there´s a shortcut to switch between tabs in Google Spreadsheets?

If you use CTRL+PgUp / CTRL+PgDown like in Excel you switch between Chrome or Firefox's tabs instead.

35

Use the following short cuts.

Shotcuts

Ctrl + Shift + PageDown ==> Move to next sheet (Option + Down arrow on a Mac)

Ctrl + Shift + PageUp ==> Move to previous sheet (Option + Up arrow on a Mac)

Screenshot

enter image description here

Reference

Keyboard Accelerators

  • 1
    Is it possible to change that shortcut somewhere? That's really cumbersome as is. – Joel Glovier Feb 21 '14 at 18:30
  • 2
    Aha - you can also use cmd+Shift+PageDown or cmd+Shift+PageUp on Mac. – Joel Glovier Feb 21 '14 at 18:40
  • 3
    But Ctrl + Shift + PageDown is move tabs in Chrome... – bigOmega Feb 23 '14 at 7:04
  • 1
    Ugh, that is a really nasty shortcut on Mac. – James Duffy Oct 29 '14 at 2:03
  • 1
    @PeteAlvin fn + Up-arrow is the combo for page-up on a laptop keyboard - (annoyingly requiring two hands on its own). External keyboards have dedicated pagination keys, so it's not so painful. – scipilot Nov 24 '17 at 2:08
4

Here's my approach. Open a new browser tab for the same google sheet (in Firefox, you can right click on the browser tab and select "Duplicate Tab"). In the new browser tab, select the spreadsheet tab you want to toggle back and forth to. Now you can use your standard shortcut to toggle between browser tabs.

  • This is super valuable insight! I spent 30+ minutes searching for the shortcut weak, and it never came to me that I can simply get all "sheets" displayed through a separate browser tab! [I came across similar problem with Firefox on Windows: <kbd>Ctrl<\kbd>+<kbd>Shift+</kbd>+<kbd>PgDn</kbd> should move my tabs around. – llinfeng Feb 3 at 17:00
3

Adding to Jacob's correct answer, I noticed there's also a pop-up selector list of all sheets.

This allows "random access" which is quicker if you have a lot of sheets and want to switch between two distant sheets. (Sadly it doesn't have predictive typing for selecting the sheet which I feel it should.)

It's also an easier shortcut for Mac laptops.

Navigate spreadsheet

    Display list of sheets  Option + Shift + k . (mac)
    Display list of sheets  Alt + Shift + k      (pc)

Keyboard shortcuts for Google Sheets

2

option up/down arrow works for me on my mac ( as of today ) Before it was the clumsy Cmd + Shift + Fn + Down arrow as described by Jacob. that combo was unusable for me.

2

On Firefox used Alt + Up and Alt + Down to move the worksheet and avoid conflicts with moving the browser tab.

0

Download better touch tool to replace that ugly shortcut with a pretty one. I use the excel shortcut alt up and down :]

0

Prayers answered on Mac: To switch between tabs/sheets, you can just use:

Option+↑ and Option+↓

keyboard shortcuts

Or Option+Shift+K for the dropdown selector

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.