Monday, October 15, 2018

Link Directly to Individual Tabs and/or Cells in a Google Sheet

You can easily link to different tabs or even directly to individual cells within a Google Sheet.

To get the link to a Tab in your Google Sheet:
  • Click on the tab you want to link
  • Copy the url in the address bar

To get the link to an individual cell:
  • Right click (Control + click) on the cell that you want to turn into a clickable link
  • Click "Get link to this cell" in the drop down menu

How could you use this?
  • Share a specific tab within a sheet
  • Direct someone to a specific cell in a sheet
  • Add a Home button to tabs in your Sheet so you can quickly get back to the first tab
  • Create a "table of contents" for your Sheet
  • Link to important calculation cells so they can be easily accessed