Kuphatikiza kwa makiyi otentha ndi njira yomwe imatheka kuyimba kwina pa kiyibodi, pomwe mungathane ndi mawonekedwe ena a Eksel mkonzi. Munkhaniyi, lingalirani njira zochotsera mizere mu tebulo la mkonzi pogwiritsa ntchito makiyi otentha.
Kuchotsa chingwe ndi kiyibodi yokhala ndi makiyi otentha
Njira yochotsera bwino kwambiri ndiyogwiritsidwa ntchito zingapo ndikugwiritsa ntchito makiyi otentha. Pofuna kuchotsa mzere pogwiritsa ntchito zophatikizira, mumangofunika dinani mabatani 2, imodzi mwa "CTRL", ndi yachiwiri "-".
Tiyeneranso kudziwa kuti mzerewo (kapena zinthu zingapo) zikuyenera kugawidwa pasadakhale. Lamuloli lidzachotsa mitundu yomwe yatchulidwa. Kugwiritsa ntchito kumapereka mwayi kuti muchepetse nthawi yomwe imagwiritsidwa ntchito ndikusiya machitidwe osafunikira omwe bokosi la zokambirana limatchedwa. Ndikotheka kuthamangitsa njira zochotsera zingwe pogwiritsa ntchito hotkeys, koma chifukwa cha cholinga ichi. Choyamba, sungani macro, kenako imaphatikizanso kuphedwa kwake kophatikiza mabatani.
Kusunga macroPogwiritsa ntchito pulogalamu ya Macro Pulogalamu Yothandizira kuti muchotse mzere, ndizotheka kuichotsa popanda kuyenda pansanja. Ntchitoyo ithandizanso kudziwa kuchuluka kwa mzere komwe chizolowezi chodzipatula chilipo ndikuchotsa mzerewo. Kuti mukwaniritse zomwe zachitika, simudzafunikira kugawa gawo lokha. Kusamutsa Khodi yoterewa ku PC, muyenera kuti muwakope ndikumatira mwachindunji mu gawo la polojekiti.
2 Kupereka Kuphatikizira Kuphatikizira MacroNdikotheka kutchulanso mabatani awo, kuti njira yochotsa kuchotsetsa zitheke, koma chifukwa cha cholinga 2. Poyamba, muyenera kupulumutsa Macro mu bukulo, kenako ndikuphatikiza kuphatikiza kwakukulu kwa kuphedwa kwake. Njira yochotsera zingwe ndizoyenera kwambiri ogwiritsa ntchito zapamwamba kwambiri za Eksel mkonzi.
Kuphatikiza apo, mkonzi amasiyanitsidwa ndi zilembo za kalata yomwe yatchulidwa, chifukwa kusagogomezera pamapangidwe a macro, ndikotheka kuti muwakoze ndi dzina lodziwika bwino ndikugwiritsa ntchito batani lofananira .
Macro kuti achotse zingwe
Palinso zida zokulira pakukhazikitsa njira yomwe ikuwunika, pogwiritsa ntchito zomwe sizifunikira kuyang'ana pa kupeza mizere kuti ichotsedwe. Mwachitsanzo, mutha kutenga macro omwe amayang'ana ndikuchotsa zinthu zochepa zomwe zili ndi zomwe wogwiritsa ntchitoyo adatchulapo, ndi zowonjezera. Imachotsa mizere yokhala ndi zinthu zosiyanasiyana komanso kuthekera kuziyika mu bokosi la zokambirana.Mapeto
Kuti muchotse zinthu zazing'ono zomwe zili mkonzi wa Excel pali zida zingapo zosavuta. Mutha kugwiritsa ntchito makiyi otentha kuti mugwire opaleshoni imeneyi, komanso kupangira macro kuti muchotse zinthu zochepa pagome, chinthu chachikulu ndikutsatira algorithm machitidwe.
Uthengawo "Chotsani mzere" mu tebulo la Excel lidawoneka koyamba kuzaukadaulo.