Mtengo wowonera mavidiyo pa YouTube

Zimadziwika kuti muzochitika zachilendo mutu wa zikhomo ku Excel ndizolembedwa ndi zilembo zachi Latin. Koma, panthawi ina, wosuta angapeze kuti zipilala zalembedwa tsopano ndi ziwerengero. Izi zikhoza kuchitika pa zifukwa zingapo: zovuta zosiyanasiyana za pulogalamuyi, zochita zake zosadzichitira mwangozi, kusintha kwadongosolo kwawonetsera ndi wina wosuta, ndi zina zotero. Koma, zilizonse zifukwa, ngati vutoli likuchitika, funso lobwezeretsa maina a mndandanda ku boma likukhala mwamsanga. Tiyeni tipeze momwe tingasinthire manambala pa makalata a Excel.

Zosankha kuti musinthe mawonekedwe

Pali zinthu ziwiri zomwe mungachite kuti mubweretse magawo a makonzedwe omwe ali nawo. Mmodzi wa iwo akuchitidwa kudzera mu mawonekedwe a Excel, ndipo chachiwiri chimaphatikizapo kulowetsa mwalamulo pogwiritsira ntchito code. Tiyeni tione mwatsatanetsatane njira ziwiri.

Njira 1: Gwiritsani ntchito mawonekedwe a pulojekiti

Njira yosavuta yosinthira mawonedwe a maina a mndandanda kuchokera ku manambala kupita ku makalata ndi kugwiritsa ntchito pulojekiti yeniyeni ya pulogalamuyi.

1. Kupanga kusintha ku tab "Foni".



2. Kusunthira ku gawoli "Zosankha".



3. Muzenera zowonetsera pulogalamu yomwe imatsegulidwa, pitani ku ndimeyi "Maonekedwe".



4. Titasintha kumbali yapakati pazenera, tikuyang'ana malo ozungulira "Kugwira ntchito ndi mayendedwe". About parameter "Link Style R1C1" samasula. Timakanikiza batani "Chabwino" pansi pazenera.

Tsopano dzina la zipilala mu gulu logwirizana lidzatenga mawonekedwe omwe akupezeka, ndiko kuti, zidzatchulidwa ndi makalata.

Njira 2: Gwiritsani ntchito Macro

Njira yachiwiri monga yankho la vutoli ikuphatikizapo kugwiritsa ntchito macro.

1. Gwiritsani ntchito mawonekedwe opanga makina pa tepi ngati zikutembenuka kukhala olumala. Kuti muchite izi, sungani ku tabu "Foni". Kenaka, dinani zolembazo "Zosankha".



2. Pawindo limene limatsegula, sankhani chinthucho Kukonzekera kwa Ribbon. Kumanja komwe pawindo, fufuzani bokosi "Wotsambitsa". Timakanikiza batani "Chabwino". Potero, mawonekedwe opanga osinthika atsegulidwa.



3. Pitani ku tab "Wolemba". Timakanikiza batani "Visual Basic"yomwe ili kumbali ya kumanzere kwa riboni mu bokosi lokhalamo "Code". Simungathe kuchita izi pa tepiyi, koma ingoyanizitsa njira yowonjezera Alt + F11.



4. VBA mkonzi amatsegula. Ikani njira yomasulira Ctrl + G. Lowani code muzenera lotseguka:

   Application.ReferenceStyle = xlA1

   Timakanikiza batani Lowani.

Pambuyo pazochitikazi, kalata ya ma kalatayi idzabwerenso, kusintha mawerengedwe.

Monga mukuonera, kusintha kosayembekezereka mu dzina la mndandanda wa zigawo kuchokera ku alfabeti kupita kuzinthu zowerengeka sikuyenera kusokoneza wogwiritsa ntchito. Chilichonse chiri chosavuta kubwerera ku dziko lapitalo posintha magawo a Excel. Ndizomveka kugwiritsa ntchito njira yayikuluyi ngati mwazifukwa zina simungagwiritse ntchito njira yoyenera. Mwachitsanzo, chifukwa cha mtundu wina wa kulephera. Inde, mungathe kugwiritsa ntchito njirayi kuti muyese, kuti muwone momwe kusintha kumeneku kumagwirira ntchito.