Excel ndi processor yathunthu ya tebulo, pomwe ogwiritsa ntchito amakhala ndi ntchito zosiyanasiyana. Chimodzi mwazinthu izi ndikupanga batani papepala, ndikudina komwe kungayambitse njira inayake. Vutoli limathetseka kwathunthu mothandizidwa ndi zida za Excel. Tiyeni tiwone momwe mungapangire zomwezo mu pulogalamuyi.
Njira yolenga
Monga lamulo, batani lotere limapangidwa kuti lizigwira ntchito ngati cholumikizira, chida chothandizira kuyambira, zazikulu, ndi zina zambiri. Ngakhale muzochitika zina, chinthu ichi chikhoza kukhala chithunzi chabe, ndipo kupatula zolinga zowoneka sikupindula. Izi, komabe, ndizosowa.
Njira 1: Auto
Choyamba, lingalirani momwe mungapangire batani kuchokera ku mawonekedwe omwe adapangidwa mu Excel.
- Pitani ku tabu Ikani. Dinani pachizindikiro "Maonekedwe"yomwe imayikidwa pachifuwa "Zithunzi". Mndandanda wamitundu yonse ukuwululidwa. Sankhani mawonekedwe omwe mukuwona kuti ndi oyenera kwambiri batani la batani. Mwachitsanzo, chithunzi chotere chimatha kukhala chimphona ndi ngodya zosalala.
- Tikadina, timasunthira kudera la pepalalo (foni) komwe tikufuna kuti batani likhalepo, ndikuyendetsa malire mkati kuti chinthucho chitenge kukula komwe tikufuna.
- Tsopano muyenera kuwonjezera kanthu. Lolani kuti likhale kusintha kwa pepala lina mukadina batani. Kuti muchite izi, dinani ndi batani loyenera la mbewa. Pazosankha zomwe zakonzedwa pambuyo pa izi, sankhani malo "Pikokoyamaula".
- Pa zenera lotseguka lopanga ma hyperlink, pitani tabu "Ikani chikalata". Sankhani pepala lomwe tikuwona kuti ndilofunika ndikudina batani "Zabwino".
Tsopano, mukadina pazinthu zomwe tidapanga, zidzasunthidwa ku tsamba lolembedwako.
Phunziro: Momwe mungapangire kapena kuchotsa ma hyperlinks ku Excel
Njira 2: chithunzi chachitatu
Muthanso kugwiritsa ntchito chithunzi chachitatu monga batani.
- Timapeza chithunzi cha mbali yachitatu, mwachitsanzo, pa intaneti, ndikutsitsa kukompyuta yathu.
- Tsegulani chikalata cha Excel chomwe tikufuna kuyika chinthucho. Pitani ku tabu Ikani ndikudina chizindikiro "Zojambula"ili pa riboni m'bokosi la chida "Zithunzi".
- Zenera losankha chithunzilo limatsegulidwa. Timapita nawo ku fayilo ya hard drive pomwe chithunzicho chili, chomwe chidapangidwa kuti chizikhala ngati batani. Sankhani dzina lake ndikudina batani Ikani pansi pazenera.
- Pambuyo pake, chithunzicho chimawonjezeredwa ku ndege ya worksheet. Monga momwe zinalili kale, ikhoza kukakamizidwa pokokera malire. Timasunthira chojambulachi kupita kumalo komwe tikufuna kuti chinthucho chikayikidwe.
- Pambuyo pake, mutha kuyika cholumikizira ku digger momwe chimasonyezedwera m'njira yapita, kapena mutha kuwonjezera. Pomaliza, dinani kumanja pa chithunzichi. Pazosankha zomwe zikuwoneka, sankhani "Patani Macro ...".
- Zenera loyang'anira macro likutseguka. Mmenemo, muyenera kusankha macro omwe mukufuna kutsatira mukadina batani. Izi ziyenera kulembedwa kale ku buku. Sankhani dzina lake ndikudina batani "Zabwino".
Tsopano, mukadina pa chinthu, mawonekedwe osankhidwa ayambitsidwa.
Phunziro: Momwe mungapangire zazikulu mu Excel
Njira 3: Kuwongolera ActiveX
Kutha kupanga batani labwino kwambiri ngati mutatenga chinthu cha ActiveX pazoyambira. Tiyeni tiwone momwe izi zimachitikira.
- Kuti mutha kugwira ntchito ndi maulamuliro a ActiveX, choyambirira, muyenera kuyambitsa tsamba la mapulogalamu. Chowonadi ndi chakuti mosasinthika amalemala. Chifukwa chake, ngati simunawathandize, pitani pa tabu Fayilo, kenako nkusunthira ku gawo "Zosankha".
- Pa zenera loyendetsera, yendetsani gawo Kukhazikika kwa Ribbon. Mu gawo loyenera la zenera, yang'anani bokosi pafupi "Wopanga"ngati kulibe. Kenako, dinani batani "Zabwino" pansi pazenera. Tsopano tsamba loyambitsiralo lidzayambitsidwa mu mtundu wanu wa Excel.
- Pambuyo pake, pitani ku tabu "Wopanga". Dinani batani Ikaniili pa riboni m'bokosi la chida "Olamulira". Mu gululi ActiveX amazilamulira dinani chinthu choyambirira, chomwe chimawoneka ngati batani.
- Pambuyo pake, timadina pamalo aliwonse pa pepala lomwe timawona kuti ndilofunikira. Zitangochitika izi, chinthu chimawonetsedwa pamenepo. Monga njira zam'mbuyomu, timasintha malo ndi kukula kwake.
- Timadina pazomwe zimachitika ndikudina kawiri batani la mbewa.
- Zenera la mkonzi wamkuluwo likutseguka. Apa mutha kujambula macro aliwonse omwe mukufuna kuti aphedwe mukadina chinthu ichi. Mwachitsanzo, mutha kujambula macro kuti musinthe mawonekedwe amawu kukhala amitundu, monga chithunzi pansipa. Ma macro akajambulidwa, dinani batani kuti mutseke zenera m'makona ake akumanja akumanja.
Tsopano zikuluzikuluzo zidzalumikizidwa ndi chinthucho.
Njira 4: mawonekedwe owongolera
Njira yotsatirayi ndiofanana kwambiri muukadaulo wa kupha ndi mtundu wakale. Ikuwonetsa kuwonjezera batani kudzera mu mawonekedwe amtundu. Kuti mugwiritse ntchito njirayi, muyenera kupatsanso mwayi wopanga mapulogalamu.
- Pitani ku tabu "Wopanga" ndikudina batani lomwe tikudziwa Ikaniatakhala pa tepi mgulu "Olamulira". Mndandanda umatseguka. Mmenemo, muyenera kusankha chinthu choyamba chomwe chimayikidwa mgululi "Zolamulira Fomu". Chojambula ichi chikuwoneka ndendende chimodzimodzi ndi chinthu chofanana cha ActiveX, chomwe tidachikambirana chapamwamba pang'ono.
- Chojambulacho chikuwonekera papepala. Konzani kukula kwake ndi malo ake, monga momwe kwachitidwira kuposa kale.
- Pambuyo pake, timagawa chachikulu kwa cholengedwa, monga momwe chikusonyezedwera Njira 2 kapena ikani chopanira monga momwe tafotokozera Njira 1.
Monga mukuwonera, ku Excel, kupanga batani lantchito sikovuta monga momwe kumawonekera kwa wogwiritsa ntchito wosazindikira. Kuphatikiza apo, njirayi imatha kuchitika pogwiritsa ntchito njira zinayi mosiyanasiyana mwakufuna kwanu.
