Sinthani mayina amizere kukhala nambala kukhala zilembo

Amadziwika kuti nthawi zonse, mitu yamtundu wa Excel imawonetsedwa ndi zilembo za Latin. Koma, nthawi ina, wogwiritsa ntchitoyo atha kuwona kuti mzati tsopano wawonetsedwa ndi manambala. Izi zitha kuchitika pazifukwa zingapo: mitundu yosiyanasiyana yoyipa yamapulogalamu, zochita zanu popanda cholinga, kusinthitsa chiwonetserochi kukhala chosuta china, ndi zina. Koma, ngakhale zitakhala zifukwa ziti, pazochitika zofananira, nkhani yobwezeretsa chiwonetsero cha mayina azigawo mu boma loyenera imakhala yofunikira. Tiyeni tiwone momwe angasinthire manambala ku zilembo ku Excel.

Zosintha Zosintha

Pali njira ziwiri zobweretsera gulu lolumikizana ku mawonekedwe ake. Chimodzi mwazochitidwa kudzera mu mawonekedwe a Excel, ndipo chachiwiri chimaphatikizapo kulowa lamuloli pamanja. Tiyeni tiwone njira zonse ziwiri mwatsatanetsatane.

Njira 1: gwiritsani ntchito mawonekedwe

Njira yosavuta yosinthira ndikusintha mapu a mayina ammizere kuchokera manambala kupita ku zilembo ndikugwiritsa ntchito chida cha pulogalamu.

1. Timasinthana kupita ku tabu Fayilo.



2. Timasunthira ku gawo "Zosankha".



3. Pazenera lomwe limatsegulira, makonzedwe a pulogalamuyo amapita ku gawo Mawonekedwe.



4. Pambuyo posinthira pakatikati pazenera tikuyang'ana zosintha "Kugwira ntchito ndi ma formula". Pafupifupi paramu "R1C1 Lumikizano Waumwini" osayang'anira. Dinani batani "Zabwino" pansi pazenera.

Tsopano dzina la mizati patsamba logwirizanitsa litenga mawonekedwe athu, ndiye kuti, adzawonetsedwa ndi zilembo.

Njira 2: gwiritsani ntchito zazikulu

Njira yachiwiri monga yankho lavutoli ikukhudza kugwiritsa ntchito ma macro.

1. Timayambitsa makanema otsogola pa tepi, ngati itazimitsa. Kuti muchite izi, pitani ku tabu Fayilo. Kenako, dinani mawu olembedwa "Zosankha".



2. Pazenera lomwe limatsegulira, sankhani Kukhazikika kwa Ribbon. Mu gawo loyenera la zenera, yang'anani bokosi pafupi "Wopanga". Dinani batani "Zabwino". Chifukwa chake, wopanga mapulogalamuwo ndi omwe amathandizira.



3. Pitani pa tabu "Mapulogalamu". Dinani batani "Zowoneka Zachikulu"ili kumanzere kwenikweni kwa riboni m'mazenera "Code". Simungathe kuchita izi pa tepi, koma ingolembetsani njira yaying'ono pa kiyibodi Alt + F11.



4. Mkonzi wa VBA amatsegula. Kanikizani njira yaying'ono pa kiyibodi Ctrl + G. Pazenera lomwe limatsegulira, lowetsani kachidindo:

   Ntchito.ReferenceStyle = xlA1

   Dinani batani Lowani.

Zitatha izi, zilembo zamakalatayo zidzabweza, ndikusintha manambala.

Monga mukuwonera, kusintha kosayembekezereka dzina lachigawo kukugwirizanitsa kuchokera ku alifabeti kupita ku nambala sikuyenera kusokoneza wogwiritsa ntchito. Chilichonse chophweka kwambiri chimatha kubwezeretsedwa m'machitidwe ake akale ndikusintha mawonekedwe a Excel. Kusankha kogwiritsa ntchito ma macro ndikumveka kugwiritsira ntchito pokhapokha, pazifukwa zina, simungagwiritse ntchito njira yofananira. Mwachitsanzo, chifukwa cha kulephera kwina. Mutha, mwachiwonekere, kugwiritsa ntchito njirayi pazoyesa, kuti muwone momwe kusintha kwa mtundu uwu kumagwirira ntchito.