Google Sheets Reference another cell or sheet

Posted by Fox on August 27, 2017
Posted in: How-To's. Leave a Comment

https://support.google.com/docs/answer/75943?co=GENIE.Platform%3DDesktop&hl=en

Get data from other sheets in your spreadsheet

  1. On your computer, go to docs.google.com/spreadsheets/.
  2. Open or create a sheet.
  3. Select a cell.
  4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 or ='Sheet number two'!B4.

Note: If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it (as in the second example). Continue Reading