Qhov wikiHow qhia koj yuav siv Avery Label Merge add-on rau Google Docs los luam cov ntawv cim npe chaw nyob los ntawm Google Sheets cov ntaub ntawv.
Cov kauj ruam
Ntu 1 ntawm 4: Txhim Kho Avery Label Merge
Kauj Ruam 1. Mus rau https://drive.google.com hauv lub vev xaib
Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google, ua raws cov lus qhia ntawm lub vijtsam kom nkag mus tam sim no.
Kauj Ruam 2. Nyem Tshiab
Nws yog lub pob xiav ntawm lub ces kaum sab saud ntawm koj li Drive.
Kauj Ruam 3. Nyem Google Docs
Qhov no qhib daim ntawv tshiab tsis muaj npe tshiab.
Kauj Ruam 4. Nyem rau Add-ons menu
Nws nyob rau sab saum toj ntawm daim ntawv.
Kauj Ruam 5. Nyem Tau Ntxiv-ons…
Ib daim ntawv teev npe ntxiv yuav tshwm.
Kauj Ruam 6. Ntaus avery daim ntawv lo sib koom ua ke rau hauv kab ntawv tshawb fawb thiab nias ↵ Enter los yog ⏎ Rov qab los.
Nws nyob ntawm kaum sab xis saum toj ntawm cov npe ntxiv.
Kauj Ruam 7. Nyem rau Tsim thiab Luam Ntawv
Nws yog lub cim xiav nrog lub logo Avery liab thiab dawb sab hauv. Qhov no teeb tsa qhov ntxiv-thiab qhia cov pop-up thaum ua tiav.
Kauj Ruam 8. Nyem Mus Ntxiv ntawm qhov pop-up
Koj yuav raug xa mus rau lub vijtsam nkag mus.
Kauj Ruam 9. Paub meej tias koj tus lej nkag mus thiab nyem NEXT
Lub qhov rai tso cai yuav tshwm sim.
Kauj ruam 10. Scroll cia thiab nyem ALLOW
Tam sim no uas tau teeb tsa ntxiv, koj tuaj yeem siv nws los luam cov ntawv los ntawm koj li Google Cov Ntawv Cov Ntaub Ntawv.
Ntu 2 ntawm 4: Tsim Chaw Sau Npe
Kauj Ruam 1. Mus rau
Yog tias tau hais kom sai, nkag mus rau hauv Google tus account uas koj tau teeb tsa Avery Label Merge.
Yog tias koj twb muaj cov npe chaw nyob hauv Ntawv, ua raws nrog txoj hauv kev no kom ntseeg tau tias hom ntawv raug
Kauj ruam 2. Nyem +
Nws yog thawj lub thawv loj nyob ze rau sab laug-laug ntawm nplooj ntawv. Qhov no tsim daim ntawv tshiab dawb paug.
Kauj Ruam 3. Ntxiv koj kab ntawv kab taub hau
Nov yog cov npe ntawm hom ntaub ntawv hauv txhua kab ntawv. Avery Label Merge xav tau lub taub hau nyob rau sab saum toj ntawm txhua kab ntawv.
Piv txwv li, yog tias koj xav kom koj daim ntawv lo muaj cov neeg nyob hauv Tebchaws Meskas lub npe, chaw nyob, nroog, xeev, thiab tus lej zip, koj tuaj yeem hu rau A1 NAME, B1 STREET, C1 nroog, D1 xeev, thiab E1 zip
Kauj Ruam 4. Ntaus lub npe rau koj daim ntawv teev chaw nyob
Txhawm rau ua qhov no, nyem Cov ntaub ntawv tsis muaj npe nyob rau sab saud sab laug ntawm cov ntaub ntawv, tom qab ntawd ntaus lub npe (piv txwv li Chaw Nyob). Google Ntawv yuav txuag koj cov ntaub ntawv cia.
Ntu 3 ntawm 4: Kev Sau Cov Ntawv Sau
Kauj Ruam 1. Mus rau https://docs.google.com hauv lub vev xaib
Yog tias tau hais kom nkag mus rau hauv koj tus lej Google, nkag mus tam sim no.
Kauj ruam 2. Nyem +
Nws yog nyob rau sab laug sab laug ntawm nplooj ntawv. Qhov no tsim cov ntawv tsis muaj dab tsi.
Kauj Ruam 3. Nyem Ntxiv-ons
Nws nyob hauv cov ntawv qhia zaub mov saum toj ntawm daim ntawv.
Kauj Ruam 4. Nyem Avery Label Merge
Kauj Ruam 5. Nyem Kev Sib Koom Tshiab
Kauj Ruam 6. Nyem Daim Ntawv Qhia Chaw Nyob
Ib daim ntawv teev cov ntawv me me yuav tshwm.
Kauj Ruam 7. Xaiv daim ntawv me me
Nyem rau txhua qhov kev xaiv kom pom ua ntej ntawm daim ntawv.
- Cov kev xaiv txhua tus pib nrog 4 tus lej uas sib haum rau Avery cov khoom lag luam-yog tias koj luam tawm rau cov ntawv tiag tiag Avery chaw nyob, xa mus rau lub ntim kom pom cov ntawv raug.
- Yog tias koj siv lwm hom npe ntawm daim ntawv lo, nrhiav qhov kev xaiv uas zoo tshaj qhov koj muaj.
Kauj Ruam 8. Nyem Xaiv
Ib daim ntawv teev cov ntawv nthuav qhia yuav tshwm.
Kauj Ruam 9. Xaiv koj daim ntawv teev npe uas muaj chaw nyob thiab nyem Xaiv
Cov ntaub ntawv hais txog koj daim ntawv yuav tshwm rau ntawm sab xis ntawm daim ntawv.
Kauj Ruam 10. Ntxiv cov ntaub ntawv rau daim ntawv lo
Koj yuav tsum tau ntxiv txhua kab ntawm kab lus ntawm kab ntawv los ntawm cov npe chaw nyob rau nws tus kheej kab hauv lub npov ntawm qhov nruab nrab ntawm daim ntawv. Txhawm rau ntxiv lawv, nyem rau txhua kab lus npe lub npe hauv kab sab xis (hauv cov ntaub ntawv hais txog koj daim ntawv nthuav dav) kom txog thaum txhua qhov tshwm sim hauv daim ntawv.
Ua kom ntseeg tau tias txhua kab npe npe nyob ntawm nws tus kheej kab lossis lwm qhov chaw nyob yuav luam tawm ua ib kab
Kauj ruam 11. Nyem Merge
Nws yog nyob rau hauv qab txoj cai kaum ntawm Docs. Qhov no ua ke cov chaw nyob los ntawm daim ntawv nthuav tawm rau hauv Google Doc, ua kom nws npaj tau luam tawm. Thaum kev sib koom ua ke tiav, qhov kev lees paub pop-up yuav tshwm.
Ntu 4 ntawm 4: Luam Ntawv Cim
Kauj Ruam 1. Ntxig koj daim ntawv lo rau hauv lub tshuab luam ntawv raws li qhia hauv lub ntim
Cov kauj ruam yuav txawv ntawm lub tshuab luam ntawv thiab cov ntawv lo.
Kauj ruam 2. Nyem rau lub cim luam tawm
Nws nyob hauv cov ntawv qhia zaub mov nyob ze rau sab saud sab laug ntawm Google Docs.
Kauj Ruam 3. Xaiv koj lub tshuab luam ntawv
Yog tias koj tsis pom lub tshuab luam ntawv koj tab tom siv ib sab ntawm "Lub Hom Phiaj" hauv kab sab laug, nyem Hloov … xaiv nws tam sim no.
Kauj Ruam 4. Kho lwm qhov chaw luam ntawv raws li qhov tsim nyog
Koj cov kev xaiv yuav txawv nyob ntawm koj cov ntaub ntawv, tshuab luam ntawv, thiab daim ntawv lo xav tau.
Kauj Ruam 5. Nyem Luam
Nws yog lub khawm xiav nyob rau sab saum toj ntawm lub vijtsam. Qhov no xa cov ntawv lo rau lub tshuab luam ntawv.
Q&A Zej Zog
Tshawb Nrhiav Ntxiv Lo Lus Nug
-
Lus Nug Thaum Kuv tsim daim ntawv lo, nws tsuas yog tshwm ntawm thawj daim ntawv lo ntawm daim ntawv. Kuv xav tau tag nrho daim ntawv ntawm tib daim ntawv lo. Kuv yuav ua li cas?
Community Answer Highlight the information on the first label you have. Then copy and paste it onto the additional labels. This should be done only if you want the same information on each label. Thanks! Yes No Not Helpful 0 Helpful 3
-
Question Where does the zip code go?
Cuireuncroco Cov Lus Teb Hauv Zej Zog Hauv koj daim ntawv nthuav tawm, tsim ib kab npe"
-
Lus Nug Kuv yuav luam daim ntawv lo nrog qhov chaw nyob rov qab rau hauv kaum sab laug thiab sau qhov chaw nyob ntau dua rau sab xis?
cuireuncroco community answer you can use the formatting options available in the sidebar to place the return address in the top left corner and the mailing address to the middle right. alternatively, use the google docs version of the add-on to create your labels in a more visual way. the google docs version will offer more formatting options. thanks! yes no not helpful 0 helpful 0
ask a question 200 characters left include your email address to get a message when this question is answered. submit