Reference data from other sheets

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. For example:

  • =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).

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?