Zamkatimu
Kuphatikizika kwa kiyi yotentha ndi njira yomwe mungathe kuyitanitsa kuphatikiza kwina pa kiyibodi, komwe mutha kupeza mwachangu mbali zina za mkonzi wa Excel. M'nkhaniyi, tiwona njira zochotsera mizere patebulo la mkonzi pogwiritsa ntchito makiyi otentha.
Kuchotsa mzere pa kiyibodi ndi hotkeys
Njira yachangu kwambiri yochotsera mzere kapena zingapo ndikugwiritsa ntchito makiyi otentha. Kuti muchotse chinthu chamkati pogwiritsa ntchito njira yachidule ya kiyibodi, muyenera kungodina mabatani 2, imodzi mwazomwe ndi "Ctrl" ndipo yachiwiri ndi "-".
Tiyeneranso kukumbukira kuti mzere (kapena zinthu zingapo) ziyenera kusankhidwa pasadakhale. Lamuloli lichotsa mndandanda womwe watchulidwa ndi chotsitsa chokwera. Ntchitoyi ipangitsa kuti zitheke kuchepetsa nthawi yogwiritsidwa ntchito ndikukana zochita zosafunikira mothandizidwa ndi zomwe bokosi la zokambirana limatchedwa. Ndizotheka kufulumizitsa njira yochotsa mizere pogwiritsa ntchito makiyi otentha, komabe, pachifukwa ichi, muyenera kuchita masitepe awiri. Choyamba, sungani ma macro, ndiyeno perekani machitidwe ake pamabatani enaake.
Kupulumutsa macro
Pogwiritsa ntchito macro code kuchotsa chinthu chamkati, ndizotheka kuchichotsa popanda kugwiritsa ntchito pointer ya mbewa. Ntchitoyi ithandiza kudziwa kuchuluka kwa chinthu chomwe chili pamizere pomwe cholembera chili ndikuchotsa mzerewu ndikusintha kokwera. Kuti muchitepo kanthu, simuyenera kusankha chinthucho chokha musanachite. Kusamutsa kachidindo kotereku ku PC, muyenera kuyikopera ndikuyiyika mwachindunji mugawo la polojekiti.
Kupereka njira yachidule ya kiyibodi ku macro
Ndizotheka kukhazikitsa ma hotkey anu, kuti njira yochotsera mizere ifulumire, komabe, pachifukwa ichi, zochita ziwiri zimafunikira. Poyamba, muyenera kusunga macro m'buku, ndiyeno konzekerani machitidwe ake ndi kuphatikiza makiyi osavuta. Njira yomwe ikuganiziridwa yochotsa mizere ndiyoyenera kwambiri kwa ogwiritsa ntchito apamwamba kwambiri a Excel editor.
Zofunika! Zindikirani kuti ndikofunikira kusankha makiyi otentha kuti muchotse mizere mosamala kwambiri, popeza kuphatikiza zingapo zimagwiritsidwa ntchito kale ndi pulogalamu ya Excel yokha.
Kuphatikiza apo, mkonzi amasiyanitsa zilembo za chilembo chomwe chatchulidwa, chifukwa chake, kuti musayang'ane pa masanjidwewo mukamayendetsa macro, ndizotheka kuyikopera ndi dzina lina ndikusankha kuphatikiza kofunikira pogwiritsa ntchito batani lofananalo.
Macro pochotsa mizere malinga ndi chikhalidwe
Palinso zida zapamwamba zogwiritsira ntchito ndondomeko yomwe ikufunsidwa, kugwiritsa ntchito zomwe simukuyenera kuyang'ana pakupeza mizere yomwe ikuyenera kuchotsedwa. Mwachitsanzo, titha kutenga macro omwe amafufuza ndikuchotsa zinthu zamkati zomwe zili ndi mawu odziwika ndi ogwiritsa ntchito, komanso chowonjezera cha Excel. Imachotsa mizere yokhala ndi zinthu zambiri zosiyana komanso kuthekera koziyika mu bokosi la zokambirana.
Kutsiliza
Kuchotsa zinthu zamkati mu mkonzi wa Excel, pali zida zingapo zothandiza. Mutha kugwiritsa ntchito ma hotkeys kuti muchite izi, ndikupanga ma macro anu kuti muchotse zinthu zomwe zili patebulo, chinthu chachikulu ndikutsata algorithm yochita bwino.