Mukati
Iyo inopisa kiyi musanganiswa isarudzo kuburikidza iyo inogoneka kutaipa imwe musanganiswa pane keyboard, iyo iwe unogona kukurumidza kuwana mamwe maficha eExcel mupepeti. Muchinyorwa ichi, tichaona nzira dzekudzima mitsara mutafura yekupepeta uchishandisa hot keys.
Kudzima mutsara kubva pane keyboard nema hotkeys
Iyo inokurumidza nzira yekudzima mutsara kana akati wandei kushandisa musanganiswa wemakiyi anopisa. Kuti udzime inline element uchishandisa nzira yekudimbudzira kiibhodhi, unongoda kudzvanya mabhatani maviri, rimwe riri "Ctrl" uye rechipiri "-".
Izvo zvinofanirwa kucherechedzwa kuti mutsara (kana akati wandei zvinhu) unofanirwa kusarudzwa pachine nguva. Murairo uchadzima iyo yakatarwa neinokwira kumusoro. Iko kushandiswa kuchaita kuti zvikwanise kuderedza nguva yakashandiswa uye kuramba zviito zvisingakoshi nerubatsiro rwekuti dialog box inodaidzwa. Zvinokwanisika kukurumidza nzira yekudzima mitsetse uchishandisa makiyi anopisa, zvisinei, nekuda kweichi chinangwa, iwe uchafanirwa kuita 2 matanho. Kutanga, chengetedza iyo macro, uye wozopa kuita kwayo kune chaiyo musanganiswa wemabhatani.
Kuchengetedza macro
Nekushandisa macro kodhi kubvisa inline element, zvinokwanisika kuibvisa pasina kushandisa mbeva pointer. Basa racho rinobatsira kuona huwandu hweiyo inline chinhu panowanikwa chiratidzo chekusarudza uye kudzima mutsara nekuchinja kumusoro. Kuti uite chiito, haufanire kusarudza chinhu pachacho pamberi pemaitiro. Kuti uendese kodhi yakadaro kuPC, unofanirwa kuikopa uye nekuiisa zvakananga mupurojekiti module.
Kugovera nzira yekudimbudzira keyboard kune macro
Izvo zvinokwanisika kuseta yako hotkeys, kuitira kuti nzira yekudzima mitsetse iwedzere kukurumidza, zvisinei, nekuda kweichi chinangwa, 2 zviito zvinodiwa. Pakutanga, iwe unofanirwa kuchengetedza iyo macro mubhuku, uye wozogadzirisa kuita kwayo neimwe yakanakira kiyi musanganiswa. Iyo inofungidzirwa nzira yekudzima mitsara inonyanya kukodzera kune vashandisi vepamusoro veExcel mupepeti.
Zvinokosha! Izvo zvinofanirwa kucherechedzwa kuti zvinodikanwa kusarudza makiyi anopisa ekudzima mitsara zvakanyatsonaka, sezvo akati wandei masanganiswa atoshandiswa neExcel application pachayo.
Pamusoro pezvo, mupepeti anosiyanisa alfabheti yetsamba yakatsanangurwa, saka, kuti usatarise pane dhizaini paunenge uchimhanyisa macro, zvinokwanisika kuikopa neimwe zita uye sarudza kiyi musanganiswa wayo uchishandisa bhatani rakafanana.
Macro yekudzima mitsetse nemamiriro
Kune zvakare maturusi epamberi ekuita maitiro ari mubvunzo, uchishandisa izvo zvausingade kutarisa pakutsvaga mitsara yekudzimwa. Semuenzaniso, tinogona kutora macro inotsvaga uye inobvisa inline zvinhu zvine mavara-akatsanangurwa nemushandisi, uye yekuwedzera yeExcel. Inobvisa mitsetse ine zvakawanda zvakasiyana-siyana mamiriro uye kukwanisa kuzviisa mubhokisi rebhokisi.
mhedziso
Kubvisa inline zvinhu muExcel mupepeti, kune akati wandei maturusi anoshanda. Iwe unogona kushandisa hotkeys kuita basa rakadaro, pamwe nekugadzira yako macro kubvisa inline zvinhu mutafura, chinhu chikuru ndechekutevera algorithm yezviito nenzira kwayo.