Momwe mungapangire batani pa Excel

Excel ndi purosesa yovuta, yomwe ogwiritsa ntchito amagwira ntchito zosiyanasiyana. Ntchito imodzi yotere ndikupanga batani pa pepala, kanikizani zomwe zingayendetse njira inayake. Vutoli limathetsedwa pogwiritsa ntchito chidole cha Excel. Tiyeni tichitepo ndi njira ziti zomwe mungapangire chinthu chomwecho pulogalamuyi.

Ndondomeko Yopanga

Monga lamulo, batani ili lakonzedwa kuti lizinena monga cholembera, chida choyambitsa njirayi, Macro, ndi zina. Ngakhale nthawi zina, chinthu ichi chitha kukhala chithunzi cha geometric, ndipo kuwonjezera pa zowoneka, palibe ntchito yomwe siyitengedwa. Komabe, njirayi siili wosowa.

Njira 1: Chithunzi cha Auto

Choyamba, lingalirani momwe mungapangire batani kuchokera ku mawonekedwe ophatikizika.

1. Timasuntha ku "kuyika" tabu. Dinani pa "Zojambula", zomwe zili pa tepi mu "chithunzi" cholembera. Mndandanda wa mitundu yonse ya ziwerengero zawululidwa. Sankhani chiwerengero chomwe mukuganiza kuti ndi choyenera gawo la batani. Mwachitsanzo, chithunzi choterocho chikhoza kukhala makona akona okhala ndi makona owotcha.



2. Mukakanikiza, timasunthira kudera la pepalalo (khungu), komwe tikufuna kukhala batani, ndikusuntha malirewo kuti atenge kukula komwe timafunikira.



3. Tsopano muyenera kuwonjezera chochitika china. Lolani kuti ikhale yosinthira ku pepala lina mukadina batani. Kuti muchite izi, dinani batani la mbewa. Muzosankha zomwe zalembedwa, zomwe zimayambitsidwa pambuyo pa izi, sankhani malo oti "Hyperlink".



4. Pawindo lotsegula la hyperlink, pitani ku "malo mu chikalata" tabu. Sankhani pepalalo lomwe tikuona kuti ndizofunikira, ndikudina batani la "OK".

Tsopano, mukadina zinthu zomwe zapangidwa ndi ife, chinthucho chidzasunthidwa ku pepala losankhidwa.

Phunziro: Momwe mungapangire kapena kuchotsa hyperlinks mu Excel

Njira 2: Chithunzi cha mbali

Monga batani, mutha kugwiritsanso ntchito njira yachitatu.

1. Mwachitsanzo, timapeza chithunzi cha chipani chachitatu, mwachitsanzo, pa intaneti, ndikutsitsa kompyuta yanu.
2. Tsegulani chikalata cha Excel momwe timafunira kukonza chinthucho. Pitani ku "Ikani" tabu ndikudina chithunzi cha "Chithunzi", chomwe chimapezeka pa tepi mu "chithunzi" cha chida.



3. Zenera losankha zithunzi limatseguka. Pitani mukagwiritse ntchito chikwatu chimenecho cha hard disk, pomwe chithunzicho chilipo, chomwe chimapangidwa kuti chithandizireni kuti mugwire. Gawani dzina lake ndikudina batani la "phala" pansi pazenera.



4. Pambuyo pake, chithunzicho chimawonjezedwa ku ndege ya pepala logwira ntchito. Monga momwe zidayambira kale, imatha kuphatikizidwa, ndikukoka malire. Sinthani chojambulacho kudera lomwe tikufuna kuyika chinthucho.



5. Pambuyo pake, mawu osilira amathamangitsidwa ku Coppe, momwemonso monga momwe zimasonyezedwera mu njira yapita, ndipo mutha kuwonjezera macro. Pomaliza pake, podina batani la mbewa lamanja pa zojambulazo. Muzosankha zomwe zikuwoneka, sankhani "garro ..." chinthu.



6. Windo la Macro limatseguka. Iyenera kuwunikira kuti macro omwe mukufuna kutsatira batani likanikizidwa. Macro uyu amayenera kulembedwa kale m'buku. Ndikofunikira kuwonetsa dzina lake ndikudina batani la "OK".

Tsopano kukanikiza chinthucho chidzakhazikitsidwa macro osankhidwa.

Phunziro: Momwe Mungapangire Macro pa Excel

Njira 3: ElementX

Batani logwirira ntchito kwambiri lidzapangidwa mumwambowu kuti ndi gawo loyambira. Tiyeni tiwone momwe izi zikuchitikira.

1. Kuti athe kugwira ntchito ndi zinthu za Activex, Choyamba, muyenera kuyambitsa tabu ya wopanga. Chowonadi ndi chakuti mwa kusinthika ndi wolumala. Chifukwa chake, ngati simunatsegule, kenako pitani ku "fayilo" tabu, kenako ndikusamukira ku "magawo".



2. Pazenera loyambitsidwa, timasamukira ku gawo la "ritibon Selep". Kumbali yakumanja kwa zenera, timakhazikitsa chojambula pafupi ndi "wopanga" ngati akusowa. Kenako, dinani batani la "OK" pansi pazenera. Tsopano tabu ya proser idzayambitsidwa mu mtundu wanu wa Excel.



3. Pambuyo pake, timasamukira ku tabu yopanga. Dinani pa batani la "Ikani", lomwe lili pa tepi mu "olamulira" chida. Mu gulu la Activex, dinani chinthu choyamba, chomwe chimakhala ndi batani.



4. Pambuyo pake, dinani malo aliwonse pa pepala lomwe timaona kuti ndizofunikira. Zitatha izi, anthuwo adzawonekera pamenepo. Monga njira zapita, kukonza malo ndi kukula kwake.



5. Dinani pa electiment ya element Stuck Dinani kumanzere kwa mbewa.



6. Mkonzi wa Macro amatsegula. Mutha kujambula macro aliwonse omwe mukufuna kuphedwa mukadina chinthu ichi. Mwachitsanzo, mutha kujambula malembawo kuti Macro mu mtundu wa manambala, monga m'chithunzichi pansipa. Pambuyo pa Macro atalembedwa, dinani batani lotseka pakona yakumanja.

Tsopano macro adzamangidwa ku chinthucho.

Njira 4: Pangani zinthu zowongolera

Njira yotsatirayi ndi yofanana kwambiri ndi ukadaulo wowonongeka pa mtundu wakale. Ili ndi batani kuti muwonjezere batani kudzera pa mawonekedwe a mawonekedwe. Kuti mugwiritse ntchito njirayi, mawonekedwe opanga masewera amafunikiranso.

1. Pitani ku "wopanga" ndikudina batani labwino "Ikani", kuyikidwa pa tepiyo. Mndandandawo umatsegulidwa. Iyenera kusankha chinthu choyamba chomwe chili mu "mawonekedwe oyang'anira mawonekedwe". Chinthu ichi chikuwoneka chimodzimodzi ndi chinthu chofananiracho, tidakambirana pamwambapa.



2. Chinthucho chimawonekera pa pepalalo. Konzani kukula kwake ndi malo ake, monga momwe adachitikira mobwerezabwereza.



3. Pambuyo pake, timapereka macro ku chinthu chopangidwa, monga momwe akuwonetsera mu njira 2 kapena kupatsa mawu osiyidwa monga tafotokozera mu njira 1.

Monga mukuwonera, kuposa, pangani batani la ntchito silovuta monga momwe zingawonekere ngati wogwiritsa ntchito osadziwa. Kuphatikiza apo, njirayi imatha kuchitika pogwiritsa ntchito njira zinayi zosiyanasiyana.