Modified 23 August 2018 by Ian Weatherhogg

With this simple tip you can open a Sheet on a specific tab using a unique URL of an individual worksheet

https://youtu.be/uB1x0mtu080

Because in G Suite everything is accessed via a web link we can use some clever tricks to access and share our Drive docs and sheets etc.

In this simple tip we use the unique URL of an individual worksheet in a Google Sheet to find a link directly to it.

Our Example Sheet is:

G Suite Tips -  Open a Sheet on a specific tab - Demo
https://docs.google.com/spreadsheets/d/1CxZexDFlxHiUyfb4xbAcMFXvccpiSAftdrWf0pmmA1k/edit#gid=0

We can break down the URL into its constituent parts:


Standard first part: https://docs.google.com/spreadsheets/d/

Sheet Unique ID: 1CxZexDFlxHiUyfb4xbAcMFXvccpiSAftdrWf0pmmA1k

Worksheet ID: /edit#gid=0

 

If you have a Spreadsheet with multiple sheets, you’ll see the ID at the end of the URL changes as you move to different sheets.

 

If we select the second worksheet: Sheet2 

we can see that the final part of the URL has changed to give us

Worksheet ID: /edit#gid=1183988251

Further to this, if you use Filter Views in your Sheet they also get a unique URL, adding a further part:

Filter View ID: &fvid=1287889739


If you want to link someone to a specific sheet you can copy and paste the URL so it will open on your chosen sheet.
You can use these URLs in an email or chat message to a colleague to send them exactly where you want, creating a customised view for different users.