Reference data from other sheets

Reference data from another sheet within the same spreadsheet.

Within a single spreadsheet, you can replicate data and copy it from one sheet to another by entering the sheet name and an exclamation mark before the cell being copied. Here are some examples:

  • =Sheet1!A1
  • ='Sheet number two'!B4

Note: If a sheet name contains spaces or other non-alphanumeric symbols, you'll need to include single quotes around it (as in the second example above).