Reference data from other sheets
Within a single spreadsheet, you can replicate data and copy it from one sheet to another. Enter the sheet name and an exclamation mark before the cell being copied. To pull data from other spreadsheets, use the
- ='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.