Malangizo a Excel 2003 - 2016
Pokhala ndi ndondomeko yoyera ndi mizere, kusankha maluso, ndi zinthu zolowera deta, Excel ikhoza kukhala ntchito yeniyeni yolowera ndi kusunga zinthu monga makalata ochezera. Mukadapanga mndandanda wambiri, mungagwiritse ntchito ndi maofesi ena a Microsoft Office chifukwa cha ntchito zambiri. Ndi makalata ophatikizira makalata ku MS Word, mukhoza kusindikiza malemba kuchokera ku Excel mu mphindi zochepa. Phunzirani kusindikiza ma labelle kuchokera ku Excel malinga ndi maofesi omwe mukugwiritsa ntchito.
Excel 2016, Excel 2013, Excel 2010 kapena Excel 2007
Konzani Tsamba Labwino
Kuti mupange makalata ochokera ku Excel, tsamba lanu lamasamba liyenera kukhazikitsidwa bwino. Lembani mutu mu selo yoyamba ya gawo lirilonse lofotokoza deta mu ndimeyo momveka ndi mwachidule. Pangani ndondomeko ya chinthu chilichonse chimene mukufuna kuyika pa malembawo. Mwachitsanzo, ngati mukufuna kupanga makalata olembera ku Excel, mukhoza kukhala ndi zigawo zotsatirazi:
- Mutu (Mr./Ms./Dr.)
- Dzina loyamba
- Dzina lomaliza
- Adilesi yamsewu
- Mzinda
- State
- Zipi Kodi
Lowani Deta
Lembani mayina ndi maadiresi kapena deta zina zomwe mukufuna pamene mumasindikiza malemba kuchokera ku Excel. Onetsetsani kuti chinthu chilichonse chili muzolondola. Pewani kuchoka pamakalata opanda kanthu kapena mzere mkati mwa mndandanda. Sungani pepala lamasewera mukamaliza.
Tsimikizani Format File
Nthawi yoyamba yomwe mumagwirizanitsa pa tsamba la Excel kuchokera ku Mawu, muyenera kukonza malo omwe amakulolani kuti mutembenuze mafayilo pakati pa mapulogalamu awiriwa.
- Mu Mawu, dinani pa tsamba la Fayilo ndipo sankhani Zosankha pansi pazanja lamanzere.
- Dinani Zowonjezera kumanzere kumanzere kwawindo Zowonjezera Mawu ndiyeno pindani pansi ku Gawo Lonse .
- Onetsetsani kuti Chitsimikizo Chotsitsimutsa Kutembenuka kwa Fayilo pa Open chimasankhidwa ndipo dinani.
Ikani Ma Labels mu Mawu
- Tsegulani chikalata chopanda kanthu.
- Pitani ku bokosi la Mailings , sankhani Yambani Macheza Kugwirizana ndipo dinani Ma Labels .
- Sankhani chizindikirocho mu Label Vendors bokosi ndikusankha chiwerengero cha mankhwala, chomwe chili pa phukusi. Mukhozanso kusankha Chitsulo Chatsopano ngati mukufuna kulowa muyeso ya zolemba.
- Dinani KULI mukakonzeka kupitiliza.
Tsegulani Pulogalamu Yopangira Ma Labels
Musanayambe kusonkhanitsa makalata a adresi kuchokera ku Excel, muyenera kugwirizanitsa chikalata cha Mawu ku tsamba lomwe muli ndi mndandanda wanu.
- Pa tabokosi la Mailings , dinani Sankhani Opezeka M'gulu la Mautumiki a Mail ndipo sankhani Gulu Lomwe Lilipo .
- Yendetsani ku tsamba la Excel lomwe liri ndi mndandanda muwindo la Select Data Source limene limatsegula ndikutsegula Open .
- Dinani OK kuti mutsimikizire kuti mukufuna kugwiritsa ntchito mndandanda ndikusakanikanso kachiwiri kuti musankhe tebulo liri ndi mndandanda wanu. Tsambali lidzadzazidwa ndi malemba omwe akuti « Next Record» .
Onjezani Masamu Ophatikiza Ma Mail
Apa ndi pamene malemba omwe mwawawonjezera pa tsamba lanu la Excel adzafika moyenera.
- Dinani pa lemba yoyamba pa pepala ndikusankha Maadiresi a Maadiresi mu gawo la Malembo Olemba & Insert a tabu ya Mailings.
- Dinani batani la Masewera pa Insert Address Block dialog box yomwe ikuwonekera.
- Onetsetsani kuti mutu wanu ukugwirizana ndi minda yoyenera. Ngati wina wa iwo sali olakwika, gwiritsani ntchito chingwe chotsitsa pansi pambali kuti chikufanane ndi malo oyenera.
- Dinani OK . Dinani KULI kachiwiri kuti mutseke bokosi la bokosilo ndiyeno dinani Ndondomeko Labels mu gawo la Write & Insert Fields la tabu ya Mailings.
Pangani Kugwirizana
Mukadakhala ndi Excel spreadsheet komanso chilemba cha Mawu, mungathe kuphatikiza mfundo ndikusindikiza malemba anu.
- Dinani Kutsirizitsa & Gwirizanitsani mu Gulu Lomalizira pa tabu ya Mailings.
- Dinani Kusintha Malemba Onse kuti muwone momwe malemba anu osindikizira awonekera. Sankhani Onse ndipo dinani OK .
Tsamba latsopano limatsegula ndi makalata otumizira kuchokera ku tsamba lanu la Excel. Mukhoza kusindikiza, kusindikiza ndi kusunga malemba monga momwe mungagwiritsire ntchito chikalata china.
Excel 2003
Ngati mukugwiritsa ntchito Microsoft Office 2003, masitepe opanga ma labele a aderesi kuchokera ku Excel ndi osiyana kwambiri.
Konzani Tsamba Labwino
Kuti mupange makalata ochokera ku Excel, tsamba lanu lamasamba liyenera kukhazikitsidwa bwino. Lembani mutu mu selo yoyamba ya gawo lirilonse lofotokoza deta mu ndimeyo momveka ndi mwachidule. Pangani ndondomeko ya chinthu chilichonse chimene mukufuna kuyika pa malembawo. Mwachitsanzo, ngati mukufuna kupanga makalata olembera ku Excel, mukhoza kukhala ndi zigawo zotsatirazi:
- Mutu (Mr./Ms./Dr.)
- Dzina loyamba
- Dzina lomaliza
- Adilesi yamsewu
- Mzinda
- State
- Zipi Kodi
Lowani Deta
- Lembani mayina ndi maadiresi kapena deta zina zomwe mukufuna pamene mumasindikiza malemba kuchokera ku Excel.
- Onetsetsani kuti chinthu chilichonse chili muzolondola. Pewani kuchoka pamakalata opanda kanthu kapena mzere mkati mwa mndandanda.
- Sungani pepala lamasewera mukamaliza.
Yambani Kuyanjana
- Tsegulani chikalata chatsopano cha Mawu.
- Pitani ku Zida zam'ndandanda, tchulani Makalata ndi Ma Mailings ndipo sankhani Maunjano a Mauthenga kuti mutsegule tsamba la Mautumiki a Masumiki .
- Sankhani Malemba ndipo dinani Pambuyo: Kuyambitsa Ndemanga .
- Dinani Zosankha Zolemba kuti mutsegule Label Options Options dialog.
Sankhani Ma Labels Anu
- Sankhani chizindikirocho mu Label Vendors bokosi ndikusankha chiwerengero cha mankhwala, chomwe chili pa phukusi. Mukhozanso kusankha Chitsulo Chatsopano ngati mukufuna kulowa muyeso ya zolemba.
- Dinani KULI mukakonzeka kupitiliza.
Sankhani Gwero Lanu
- Dinani Gwiritsani Mndandanda womwe ulipo pansi pa Sankhani Owalandila ndiyeno dinani Yang'anani .
- Yendetsani ku tsamba la Excel lomwe liri ndi mndandanda muwindo la Select Data Source limene limatsegula ndikutsegula Open . Mawindo Okulumikiza Ma Mail akuwonekera.
- Onetsetsani kuti deta yanu ikuwoneka bwino ndipo dinani.
Konzani Ma Labels
- Dinani Zotsatira: Konzani Ma Labels .
- Sankhani Adilesi Yopatsa .
- Dinani batani la Masewera pa Insert Address Block dialog box yomwe ikuwonekera.
- Onetsetsani kuti mutu wanu ukugwirizana ndi minda yoyenera. Ngati wina wa iwo sali olakwika, gwiritsani ntchito chingwe chotsitsa pansi pambali kuti chikufanane ndi malo oyenera. Dinani OK .
- Dinani Yambitsani Malemba Onse pansi pa Zobwereza Ma Labels mu Bokosi la Mailumikizano la Mail.
Onani ndi Kumaliza
- Gwiritsani ntchito mivi pansi pa Kuwonetsa Ma Labels kuti muwoneke kuti akuwonekera molondola.
- Dinani Zotsatira: Lembani Kugwirizana .
- Ngati mukufuna kupanga kusintha kulikonse, dinani Sinthani Malemba Onse.
- Mukakhutira ndi kuphatikiza, dinani Pindulani kuti muyambe makalata anu a aderesi ku Excel.