Excel ndi pulojekiti yowonjezera spreadsheet, yomwe omwe amagwiritsa ntchito ntchito zosiyanasiyana. Imodzi mwa ntchitozi ndikupanga batani pa pepala, ndikudalira zomwe zingayambitse njira yeniyeni. Vutoli lasinthidwa bwinobwino ndi chithandizo cha Excel zida. Tiyeni tiwone momwe mungapangire chinthu chomwecho pulogalamuyi.
Chilengedwe
Monga lamulo, batani iyi yapangidwa kuti igwirizane, chida choyambitsa ndondomeko, macro, ndi zina zotero. Ngakhale kuti nthawi zina, chinthu ichi chikhoza kukhala chiwerengero chokhachokha, ndipo kuwonjezera pa zowonetseratu sizimapindulitsa. Njirayi, komabe, ndi yochepa.
Njira 1: Autoshape
Choyamba, ganizirani momwe mungapangire batani kuchokera ku maonekedwe a ma Excel omangidwa.
- Pitani ku tabu "Ikani". Dinani pazithunzi "Ziwerengero"yomwe imayikidwa pa tepi mu zida za zipangizo "Mafanizo". Mndandanda wa mitundu yonse ya ziwerengero ukuwululidwa. Sankhani mawonekedwe omwe mukuganiza kuti ndi ofunika kwambiri pa gawo la batani. Mwachitsanzo, chiwerengero choterocho chingakhale rectangle ndi ngodya zosalala.
- Pambuyo podutsa, pititsani kuderalo la pepala (selo) kumene tikufuna batani kuti tipeze, ndi kusuntha malire mkati kuti chinthucho chikhale ndi kukula komwe timafunikira.
- Tsopano muyenera kuwonjezera chinthu china. Lolani kukhala kusintha kwa pepala lina pamene mutsegula pa batani. Kuti muchite izi, dinani ndibokosi lamanja la mouse. M'masewera a nkhani zomwe zatsekedwa pambuyo pa izi, sankhani malo "Hyperlink".
- Muwonetseredwe kawonekedwe yowonekera, pitani ku tab "Ikani mu chikalata". Sankhani pepala lomwe tikuwona kuti ndilofunika, ndipo dinani pa batani "Chabwino".
Tsopano mukamangogwiritsa ntchito chinthu chomwe chinapangidwa ndi ife, mudzasamukira ku pepala losankhidwayo.
Phunziro: Momwe mungapangire kapena kuchotsa ma hyperlink ku Excel
Njira 2: fano lachitatu
Monga batani, mungagwiritsenso ntchito fano lachitatu.
- Timapeza fano lachitatu, mwachitsanzo, pa intaneti, ndikumakopera ku kompyuta yanu.
- Tsegulani chikalata cha Excel chimene tikufuna kuyikapo. Pitani ku tabu "Ikani" ndipo dinani pazithunzi "Kujambula"yomwe ili pa tepiyi mu zida za zipangizo "Mafanizo".
- Zithunzi zosankhidwa zosankhidwa zimatsegula. Pogwiritsira ntchito, pitani ku bukhu la hard disk kumene chithunzicho chili, chomwe cholinga chake ndi kuchita batani. Sankhani dzina lake ndipo dinani pa batani. Sakanizani pansi pazenera.
- Pambuyo pake, chithunzichi chikuwonjezeka ku ndege ya tsamba. Monga momwe zinalili kale, zingatheke kuponderezedwa ndi kukokera malire. Chotsani zojambula kumalo kumene tikufuna kuti chinthucho chiyike.
- Pambuyo pake, mukhoza kulumikiza hyperlink kwa kukumba, mofanana ndi momwe anawonetsera mu njira yapitayi, kapena mukhoza kuwonjezera macro. Pachifukwa chotsatirachi, dinani botani lamanja la mbewa pachithunzichi. M'ndandanda wamakono imene ikuwonekera, sankhani chinthucho "Sankhani Macros ...".
- Mawindo olamulira aakulu amatsegula. M'menemo, muyenera kusankha zazikulu zomwe mukufuna kuzigwiritsa ntchito mukamapanikiza batani. Izi zazikulu ziyenera kulembedwa kale m'bukuli. Ndikofunika kusankha dzina lake ndikutani pa batani. "Chabwino".
Tsopano mukamalemba pa chinthu, majekiti osankhidwa adzatulutsidwa.
Phunziro: Momwe mungapangire macro ku Excel
Njira 3: ActiveX Element
Zidzatheka kukhazikitsa batani yoyenera kwambiri ngati mutenga chinthu cha ActiveX monga maziko ake. Tiyeni tiwone momwe izi zikuchitidwira.
- Kuti mukhoze kugwira ntchito ndi machitidwe a ActiveX, choyamba, muyenera kuyambitsa tabu yothandizira. Chowonadi ndi chakuti mwachinsinsi izo zalemala. Choncho, ngati simunaperekepo, pita ku tab "Foni"kenako pita ku gawolo "Zosankha".
- Muzenera yowonjezera, yendani ku gawolo Kukonzekera kwa Ribbon. Kumanja komwe pawindo, fufuzani bokosi "Wotsambitsa"ngati akusowa. Kenako, dinani pakani. "Chabwino" pansi pazenera. Tsopano tabu yowonjezera idzayankhidwa muyeso lanu la Excel.
- Pambuyo pake kusamukira ku tabu "Wotsambitsa". Dinani pa batani Sakanizaniili pa tepi muzitali za zida "Controls". Mu gulu "ActiveX Elements" Dinani pa chinthu choyamba, chomwe chiri ndi mawonekedwe a batani.
- Pambuyo pake, dinani pamalo aliwonse pa pepala limene tikuwona kuti ndilofunikira. Pambuyo pake, chinthu chidzawonekera pamenepo. Monga momwe tinayambira kale, timasintha malo ndi kukula kwake.
- Dinani pa chotsatiracho mwachinthu chojambulidwa pang'onopang'ono pa batani lamanzere.
- Wowona makina a zowonjezera amatsegula. Pano mungathe kulembetsa chilichonse chimene mukufuna kuti chichitike pamene mutsegula pa chinthu ichi. Mwachitsanzo, mungathe kulemba zambiri zomwe zimatembenuza mawu pamasom'pamaso, monga mu chithunzi pansipa. Pambuyo pa zolembedwazo, dinani pa batani kuti mutseke pawindo kumbali ya kumanja.
Tsopano macro idzaphatikizidwa ku chinthucho.
Njira 4: Kuwongolera Fomu
Njira yotsatirayi ikufanana kwambiri ndi zamakono zamakono kumasulira. Ndi Kuwonjezera kwa batani kupyolera mu mawonekedwe a mawonekedwe. Kugwiritsa ntchito njirayi kumafunikanso kuphatikizidwa ndi mawonekedwe osintha.
- Pitani ku tabu "Wotsambitsa" ndipo dinani pa batani lodziwika bwino Sakanizanianayika pa tepi mu gulu "Controls". Mndandanda umatsegulidwa. Momwemo muyenera kusankha choyamba choyikidwa mu gululo. Mawonekedwe a Fomu. Chinthu ichi chikuwonekera chikufanana chimodzimodzi ndi chinthu chomwecho cha ActiveX, chomwe tinalankhula chokwera pang'ono.
- Chinthucho chikuwonekera pa pepala. Timasintha kukula kwake ndi malo, monga momwe zakhalira kale.
- Pambuyo pake timapereka chinthu chachikulu ku chinthu cholengedwa, monga momwe chikuwonetseredwera Njira 2 kapena perekani hyperlink monga momwe tafotokozera Njira 1.
Monga mukuonera, mu Excel, kupanga phokoso la ntchito silovuta monga momwe zingakhalire ngati wosadziwa zambiri. Kuonjezerapo, njirayi ikhoza kuchitidwa pogwiritsa ntchito njira zinayi zosiyana pa luntha lake.
