Pageidaujamas puslapis šiuo metu nepasiekiamas jūsų kalba. Puslapio apačioje galite pasirinkti kitą kalbą arba iškart išversti bet kurį tinklalapį į pasirinktą kalbą naudodami „Google Chrome“ įtaisytąją vertimo funkciją.

Reference data from other sheets

Want to get more out of Google Docs for work or school? Sign up for a free Google Workspace trial.

Within a single spreadsheet, you can replicate data and copy it from one sheet to another.

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

Get data from other spreadsheets

Important: To reference a cell or range of cells in another spreadsheet, you must use the IMPORTRANGE function. 

To pull data from other spreadsheets, use the IMPORTRANGE function.

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Paieška
Išvalyti paiešką
Uždaryti paiešką
Google Apps
Pagrindinis meniu
Search Help Center
true
35
false