Google Sheets on the Web now let’s you create a “table of contents” for your spreadsheet.
You also can now direct others to specific content within the spreadsheet and retain links to cells when you import spreadsheets from other applications.
So now linking has never been easier!
You can now simply select “Insert Link” > “Select a range of cells to link” and type or highlight the desired range.
Just one more way that Google Sheets is becoming more link Excel.
Coming by February 21st, 2017.