Qhov wikiHow qhia koj yuav siv IMPORTRANGE ua haujlwm li cas hauv web version ntawm Google Sheets kom xa cov ntaub ntawv los ntawm lwm daim ntawv nthuav tawm.
Cov kauj ruam
Ntu 1 ntawm 2: Tau Txais Kev Txuas rau Cov Ntaub Ntawv
Kauj Ruam 1. Mus rau https://sheets.google.com hauv lub vev xaib
Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google, nkag mus tam sim no.
Kauj ruam 2. Nyem rau cov ntaub ntawv koj xav tau cov ntaub ntawv los ntawm
Qhov no qhib phau ntawv ua haujlwm.
Kauj Ruam 3. Nco ntsoov daim ntawv npe thiab thaj tsam ntawm cov ntaub ntawv koj xav tau ntshuam
Cov ntawv txheeb hauv cov ntawv teev tseg hauv qab ntawm qhov screen. Nyem rau daim ntawv npe uas muaj cov ntaub ntawv, tom qab ntawv sau lossis cim qhov ntau (piv txwv li A2: D11). Koj yuav xav tau cov ntaub ntawv no rau IMPORTRANGE cov mis.
Kauj Ruam 4. Nyem rau File menu
Nws nyob ze ntawm lub ces kaum sab saud saum toj kawg nkaus ntawm qhov screen.
Kauj Ruam 5. Nyem Qhia…
Kauj Ruam 6. Nyem Tau txais qhov txuas tau
Tam sim no qhov txuas rau daim ntawv nthuav tawm tau theej rau daim ntawv teev npe.
Kauj Ruam 7. Nyem Ua Li Cas
Kauj Ruam 8. Nyem rau Google Sheets home icon
Nws yog lub pob ntsuab nrog lub rooj dawb ntawm lub ces kaum sab saud ntawm qhov screen. Tam sim no koj tau theej cov ntawv txuas, nws yog lub sijhawm ntxiv nws rau tus lej hauv daim ntawv uas koj xav kom cov ntaub ntawv tshwm.
Ntu 2 ntawm 2: Ntshuam Cov Ntaub Ntawv
Kauj Ruam 1. Mus rau https://sheets.google.com hauv lub vev xaib
Yog tias koj twb pom cov npe ntawm koj cov ntaub ntawv, koj tuaj yeem hla cov kauj ruam no.
Kauj Ruam 2. Nyem rau daim ntawv uas koj xav kom cov ntaub ntawv tshwm tuaj
Koj yuav nkag mus rau tus lej ntawm daim ntawv no.
Kauj Ruam 3. Nyem rau ntawm tes uas koj xav kom qhov ntau tshwm sim
Kauj Ruam 4. Hom = IMPORTRANGE
Ib daim ntawv teev cov haujlwm sib xws yuav tshwm sim.
Kauj Ruam 5. Nyem IMPORTRANGE
Tam sim no lub cell nyeem = IMPORTRANGE (.
Kauj Ruam 6. Ntaus a"
Kauj Ruam 7. Nias Ctrl+V (Windows) lub ⌘ Cmd+V (macOS).
Qhov no hla qhov txuas mus rau lwm daim ntawv nthuav tawm rau hauv qhov khoob.
Kauj Ruam 8. Ntaus lwm tus"
Kauj Ruam 9. Ntaus tus lej cim,
Kauj Ruam 10. Ntaus txoj hauv kev rau cov ntaub ntawv ntawm cov lus hais (“”)
Piv txwv, yog tias cov ntaub ntawv hauv thawj daim ntawv nthuav tawm nyob rau ntawm daim ntawv hu ua Sheet1 thiab qhov ntau yog A2: D11, ntaus "Sheet1! A2: D11".
Kauj Ruam 11. Hom)
Tam sim no koj yuav tsum pom qee yam zoo li no:
= IMPORTRANGE (“https://docs.google.com/spreadsheets/test”, “Sheet1! A2: D11”)
Kauj Ruam 12. Nias ↵ Enter los yog ⏎ Rov qab los.
IMPORTRANGE mis yuav ntshuam cov ntaub ntawv. Thaum qhov kev ntshuam tiav, cov ntaub ntawv los ntawm thawj daim ntawv nthuav tawm yuav tshwm nyob rau hauv ob.