Imiyalo ye-Excel 2003 - 2016
Ukuba namakholomu afanele nemigqa, ukuhlunga amakhono, nokufaka idatha kwedatha, i-Excel ingaba isicelo esiphelele sokungena nokugcina ulwazi olufana nezinhlu zoxhumana nabo. Uma usungule uhlu oluningiliziwe, ungayisebenzisa nezinye izinhlelo zokusebenza ze-Microsoft Office imisebenzi eminingi. Ngesici sokuhlanganiswa kweposi ku-MS Word, ungaphrinta amalebula eposi kusuka ku-Excel ngendaba yamaminithi. Funda ukuthi ungaphrinta amalebula kusuka ku-Excel kuye ngokuthi yiyiphi inguqulo yeHhovisi oyisebenzisayo.
Excel 2016, Excel 2013, Excel 2010 noma i-Excel 2007
Lungisa Iphepha Lokusebenzela
Ukwenza amalebula weposi kusuka ku-Excel, ispredishithi sakho kufanele isethiwe ngokufanele. Thayipha isihloko esitokisini sokuqala sekholomu ngayinye echaza idatha kuleyo kholomu ngokucacile nangesifushane. Yenza ikholomu yento ngayinye ofuna ukuyifaka kumalebula. Isibonelo, uma ufuna ukudala amalebula weposi kusuka ku-Excel, ungase ube nezihloko ezilandelayo zekholomu:
- Isihloko (Mr./Ms./Dr.)
- Igama
- Isibongo
- Ikheli lesitaladi
- Idolobha
- Isimo
- Ikhodi ye-ZIP
Faka Idatha
Thayipha amagama namakheli noma enye idatha oyifunayo uma uprinta amalebula kusuka ku-Excel. Qiniseka ukuthi into ngayinye ikukholomu efanele. Gwema ukushiya amakholomu angenalutho noma imigqa ngaphakathi kohlu. Londoloza ishidi lokusebenzela uma usuqedile.
Qinisekisa ifomethi yefayela
Ngesikhathi sokuqala uxhuma kwi-Excel sheet yokusebenzela kusuka eZwini, kufanele unike amandla ukulungiselelwa okukuvumela ukuba uguqule amafayela phakathi kwalezi zinhlelo ezimbili.
- EZwini, chofoza kuthebhu yefayela bese ukhetha Izinketho ezansi kwesobunxele besobunxele.
- Chofoza Okuthuthukile kusigqoko sesokunxele sewindi lezinketho ze-Word bese ugoqa phansi kwesigaba esijwayelekile .
- Qinisekisa ukuthi Ukuqinisekisa Ukuguqulwa Kwefomethi Yefayela kuvuliwe kukhethiwe bese uchofoza OK .
Setha Amalebula NgeZwi
- Vula idokhumenti yeZwi elingenalutho.
- Yiya kuthebhu ye- Mailings , khetha u- Qala Imeyili Yokuhlanganisa bese uchofoza kumalebula .
- Khetha umkhiqizo ebhokisini le- Label Vendors bese ukhetha inombolo yomkhiqizo, ebhalwe ohlwini lwephakheji yelebula. Ungaphinda ukhethe Ilebula elisha uma ufuna ukungena ubukhulu belebuli yangokwezifiso.
- Chofoza OK uma usulungele ukuqhubeka.
Xhuma Iphepha Lokusebenzela kumalebula
Ngaphambi kokwenza ukuhlanganisa ukuphrinta amalebuli ekheli kusuka ku-Excel, kufanele uxhume idokhumenti yeWho kuphepha lokusebenzela eliqukethe uhlu lwakho.
- Kumathebhu we- Mailings , chofoza Khetha Abamukeli kuqoqo le-Mail Merge bese ukhetha Sebenzisa uhlu olukhona .
- Zula kuphepha lokusebenzela le-Excel eliqukethe uhlu lwakho ku-window ye-Khetha Data Source evula futhi uchofoze i- Open .
- Chofoza OK ukuze uqinisekise ukuthi ufuna ukusebenzisa uhlu bese uchofoze Kulungile futhi ukhethe ithebula equkethe uhlu lwakho. Ikhasi manje lizogcwaliswa ngamalebula athi " Okulandelayo" .
Engeza Amasimu Wokuhlanganiswa Kwemeyili
Yilapho lezo zihloko ozifakayo kuphepha lakho lokusebenzela lase-Excel lizofika ngokuzenzekelayo.
- Chofoza kulebula lokuqala ekhasini bese ukhetha ikheli lekheli kwi-Write & Insert Fields ingxenye yethebhu ye-Mailings.
- Chofoza inkinobho ye- Match Fields ebhokisini lebhokisi le-Insert Block dialog elivela.
- Qiniseka ukuthi izihloko zakho zihambelana nezinkambu ezidingekayo. Uma omunye wabo engalungile, sebenzisa umcibisholo wokudonsa eceleni kwawo ukuze uhambelane nendawo efanele.
- Chofoza OK . Chofoza u- Kulungile futhi ukuze uvale ibhokisi lengxoxo bese uchofoza u- Update Labels kusigaba se-Writ & Insert Fields sethebhu ye-Mailings.
Yenza ukuhlanganisa
Uma usuphethe i-spreadsheet ye-Excel futhi idokhumenti ye-Word isethiwe, ungahlanganisa ulwazi futhi uphrinte amalebula akho.
- Chofoza Qedela & Hlanganisa eqenjini eliqedile kuthebhu ye-Mailings.
- Chofoza u- Hlela Amadokhumenti Omunye ukuze ubone ukuthi amalebula akho aphrintiwe azovela kanjani. Khetha Konke bese uchofoza OK .
Idokhumenti entsha ivula ngamalebula weposi kusuka kuphepha lakho lokusebenzela le-Excel. Ungahlela, uprinte futhi ulondoloze amalebula njengoba nje ungathanda noma iyiphi enye idokhumenti yeZwi.
Excel 2003
Uma usebenzisa i-Microsoft Office 2003, izinyathelo zokwenza amalebula ekheli kusuka ku-Excel zihlukile kancane.
Lungisa Iphepha Lokusebenzela
Ukwenza amalebula weposi kusuka ku-Excel, ispredishithi sakho kufanele isethiwe ngokufanele. Thayipha isihloko esitokisini sokuqala sekholomu ngayinye echaza idatha kuleyo kholomu ngokucacile nangesifushane. Yenza ikholomu yento ngayinye ofuna ukuyifaka kumalebula. Isibonelo, uma ufuna ukudala amalebula weposi kusuka ku-Excel, ungase ube nezihloko ezilandelayo zekholomu:
- Isihloko (Mr./Ms./Dr.)
- Igama
- Isibongo
- Ikheli lesitaladi
- Idolobha
- Isimo
- Ikhodi ye-ZIP
Faka Idatha
- Thayipha amagama namakheli noma enye idatha oyifunayo uma uprinta amalebula kusuka ku-Excel.
- Qiniseka ukuthi into ngayinye ikukholomu efanele. Gwema ukushiya amakholomu angenalutho noma imigqa ngaphakathi kohlu.
- Londoloza ishidi lokusebenzela uma usuqedile.
Qala ukuhlanganisa
- Vula idokhumenti yeZwi elisha.
- Yiya kumenyu yamathuluzi , ukhomba ku- Letters and Mailings bese ukhetha ukuhlanganisa iMeyili ukuvula iwindi lokusebenzela le-Mail Merge.
- Khetha Amalebula bese uchofoza Okulandelayo: Ukuqala Idokhumenti .
- Chofoza Izinketho Ze-Label ukuze uvule ibhokisi lebhokisi lezinketho zelebuli.
Khetha Amalebula Wakho
- Khetha umkhiqizo ebhokisini le-Label Vendors bese ukhetha inombolo yomkhiqizo, ebhalwe ohlwini lwephakheji yelebula. Ungaphinda ukhethe Ilebula elisha uma ufuna ukungena ubukhulu belebuli yangokwezifiso.
- Chofoza OK uma usulungele ukuqhubeka.
Khetha Umthombo Wakho
- Chofoza Sebenzisa uLuhlu Olukhona ngaphansi Kokukhetha Abamukeli bese uchofoza Phequlula .
- Zula kuphepha lokusebenzela le-Excel eliqukethe uhlu lwakho ku-window ye-Khetha Data Source evula futhi uchofoze i- Open . Iwindi le-Mail Merge Abamukeli livula.
- Qinisekisa ukuthi idatha yakho ibonakala ilungile bese uchofoza OK .
Hlela amalebula
- Chofoza Okulandelayo: Hlela Amalebula Wakho .
- Khetha ikheli lekheli .
- Chofoza inkinobho ye- Match Fields ebhokisini lebhokisi le-Insert Block dialog elivela.
- Qiniseka ukuthi izihloko zakho zihambelana nezinkambu ezidingekayo. Uma omunye wabo engalungile, sebenzisa umcibisholo wokudonsa eceleni kwawo ukuze uhambelane nendawo efanele. Chofoza OK .
- Chofoza u- Update All Labels ngaphansi Kwamalebula Aphindaphindiwe ebhokisini lengxoxo ye-Mail Merge.
Buka kuqala futhi Qedela
- Sebenzisa imicibisholo ngaphansi kokuhlola amalebula akho ukuze uqiniseke ukuthi ivela kahle.
- Chofoza Okulandelayo: Qedela ukuhlanganiswa .
- Uma ufuna ukwenza noma yiziphi izinguquko, chofoza u- Hlela Amalebula Ayehlukene.
- Uma unelisekile ngokuhlanganiswa, chofoza Phrinta ukuze uprinte amalebula akho ekheli kusuka ku-Excel.