Search
Clear search
Close search
Google apps
Main menu

We've gotten reports about some users being signed out of their accounts unexpectedly. We're investigating, but not to worry: there is no indication that this is connected to any phishing or account security threats. Please try to sign-in again at accounts.google.com and if you cannot remember your password, please use this link to recover your password. If you use 2-Step Verification, there may have been a delay in receiving your SMS code. Please try again or use backup codes.

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 IMPORTRANGE function.

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?
How can we improve it?