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.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Use the following short cuts.
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)
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.
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)
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.
On Firefox used Alt + Up and Alt + Down to move the worksheet and avoid conflicts with moving the browser tab.
Download better touch tool to replace that ugly shortcut with a pretty one. I use the excel shortcut alt up and down :]