There are three main ways of linking to a document in SharePoint:

  1. By using the Copy Link control
  2. By copying the URL when viewing the spreadsheet in the browser
  3. By using a hard link to the document using its path

The following method only works for the two first types of links, that looks like this:



For both of these, if we add &ActiveCell=Sheetname it will open the sheet we specify. We can also specify a cell in that sheet if we want to. Example:!C3


Pretty neat!