Nthawi zambiri, zinthu zimachitika pamene, tikasindikiza chikalatacho, tsamba limasoweka pamalo osayenera kwambiri. Mwachitsanzo, gawo lalikulu la tebulo limatha kuwoneka patsamba limodzi, ndipo mzere womaliza patsamba lachiwiri. Poterepa, nkhani yosuntha kapena kuchotsa kusiyana kumeneku ikuyenera. Tiyeni tiwone momwe zingachitikire pogwira ntchito ndi zikalata mu purosesa ya purosesa ya Excel.
Onaninso: Momwe mungachotsere kapangidwe ka masamba mu Excel
Mitundu ya zigawo za pepala ndi njira yochotsera
Choyamba, muyenera kudziwa kuti masamba osweka akhoza kukhala amitundu iwiri:
- Mothandizidwa ndi manja ndi ogwiritsa ntchito;
- Yodziyika yokha ndi pulogalamuyo.
Momwemo, njira zopewera mitundu iwiriyi yamafuta ndizosiyana.
Yoyamba yaiwo imapezeka m'chikalata chokhacho ngati wosuta adawonjezera pogwiritsa ntchito chida chapadera. Itha kusunthidwa ndikuchotsedwa. Mtundu wachiwiri wa magawidwe amakanikidwa ndi pulogalamuyo. Sangathe kuchotsedwa, koma ingasunthidwe.
Kuti muwone komwe zigawo zamasamba ziriri pa polojekiti, popanda kusindikiza chikalatacho palokha, muyenera kusinthira ku tsamba. Izi zitha kuchitika podina chizindikiro. "Tsamba", womwe ndi chithunzi cholondola pakati pa zithunzi zitatu zoyenda pakati pa mitundu yazowonera masamba. Zithunzizi zili mgulu lamanzere kumanzere kwa chida chosakira.
Palinso njira yolowera mumasamba ndikupita pa tabu "Onani". Pamenepo mufunika dinani batani, lotchedwa - Makonda Tsamba ndi kuyikidwa pa tepiyo Mitundu Yowonera.
Mukasinthira kumachitidwe azosamba, masamba azowonekera. Zomwe zimakhazikika pa pulogalamuyi zimawonetsedwa ndi mzere wa dontho, ndipo zomwe zimayendetsedwa ndi ogwiritsa ntchito zimawonetsedwa ndi chingwe cholimba cha buluu.
Tikubwereranso ku mtundu wamba wa wogwirira ntchito ndi chikalatacho. Dinani pachizindikiro "Zachizolowezi" pa bar kapena ngati muli ndi chithunzi chomwechi m'chigwayo "Onani".
Mukasinthira njira yofananira yoonera kuchokera patsamba, kuyika mipata kumaonekeranso pa pepalalo. Koma izi zidzachitika pokhapokha ngati wosuta asinthira patsamba lolemba. Ngati sanatero, ndiye kuti mwanjira yofananira, sangakhale wowonekera. Chifukwa chake, mumawonekedwe abwinobwino, zotayidwa zimawonetsedwa mosiyana. Zomwe zimapangidwa ndi pulogalamuyi ziziwoneka ngati chingwe chokhala ndi mawotchi, ndikuchita kupanga ogwiritsa ntchito ngati mizere yayikulu ikulu.
Kuti muwone momwe chikalata “chong'ambika” chimawonekera posindikiza, pitani ku tabu Fayilo. Kenako, pitani pagawo "Sindikizani". Kumanja kwazenera kudzakhala malo owonera. Mutha kuwona chikwangwani posunthira mpukutuwo pansi ndi pansi.
Tsopano tiyeni tiwone njira yothetsera vutoli.
Njira 1: chotsani mipata yonse yoikidwa pamanja
Choyamba, tiyeni tikambirane zochotsa masamba omwe adalowetsedwa.
- Pitani ku tabu Masanjidwe Tsamba. Dinani pazithunzi cha riboni Zophulikaitayikidwa Zikhazikiko Tsamba. Mndandanda wotsitsa ukuwoneka. Pazosankha zomwe zikuperekedwa, sankhani Bwezeretsani Zoswa patsamba.
- Pambuyo pa izi, masamba onse akusweka patsamba lokhalokha la Excel lomwe limayikidwa pamanja ndi ogwiritsa ntchito lidzachotsedwa. Tsopano, ndikusindikiza, tsamba limangotuluka pomwe pulogalamuyo imangosonyeza.
Njira 2: chotsani mipata yomwe ikupezeka pamanja
Koma kutali ndi zonsezo, ndikofunikira kufufuta zonse zowonongeka zomwe zimayikidwa ndi ogwiritsa ntchito. Nthawi zina, gawo limodzi limayikidwa kuti ichoke, ndikuchotsedwapo. Tiyeni tiwone momwe izi zingachitikire.
- Sankhani khungu lililonse lomwe lili pansi mwachindunji lomwe likufunika kuchotsedwa papepalalo. Ngati gawoli likutsatira, pamenepa timasankha chinthu kumanja kwake. Pitani ku tabu Masanjidwe Tsamba ndikudina chizindikiro Zophulika. Pakadali pano muyenera kusankha njira kuchokera pamndandanda wotsika. "Fufutani tsamba".
- Pambuyo pa izi, ndi gawo lokhalo lomwe linali pamwamba pa selo losankhidwa lomwe lidzachotsedwa.
Ngati ndi kotheka, momwemonso, mutha kuchotsa mabala otsala papepala, momwe mulibe vuto.
Njira 3: chotsani malire ogwidwa mwamanja posuntha
Mutha kuchotsanso mipata yomwe mwayiyendetsa mwakusunthira kumalire a chikalatacho.
- Pitani patsamba la bukulo. Khazikitsani cholozera pazopanga zojambula zokumbidwa ndi chingwe cholimba cha buluu. Poterepa, chidziwitso chiyenera kusinthira kukhala muvi-wolowera-mbali ziwiri. Gwirani batani lakumanzere ndikukokera mzere wolimbawu kumalire a pepalalo.
- Mukafika kumalire a chikalatacho, masulani batani la mbewa. Gawoli lidzachotsedwa papepala lamakono.
Njira yachinayi: kusunthika kopumira
Tsopano tiyeni tiwone momwe masamba omwe amapangika okha ndi pulogalamuyo amatha kuchotsera, ngati sangachotsedwe, osunthidwa momwe wosuta amafunira.
- Pitani pamafilimu. Yendani pamwamba pa gawo lomwe lasonyezedwa ndi mzere wosemedwa. Chopata chimasinthidwa kukhala muvi woongolera mbali ziwiri. Tsitsani batani lakumanzere. Kokani mbali yomwe tikuwona kuti ndi yofunika. Mwachitsanzo, zotayidwa zimatha kupita kumalire a pepalalo. Ndiye kuti, timachita njira yofanana ndi yomwe idachitidwa kale momwe timachitiramu.
- Pankhaniyi, yopuma yodzidzimutsa mwina idzatulutsidwa kumalire a chikalatacho, kapena kupita kumalo oyenera kwa wogwiritsa ntchito. Mwanjira yotsirizira, imasinthidwa kukhala disgment yochita kupanga. Tsopano ndi nthawi iyi pomwe kusindikiza kudzaswa tsamba.
Monga mukuwonera, musanayambe njira yochotsera, muyenera kudziwa mtundu wa zinthu zake: zokha kapena zopangidwa ndi ogwiritsa ntchito. Njira yakuchotsera kwake kumadalira kwambiri izi. Kuphatikiza apo, ndikofunikira kuti mumvetsetse zomwe zikufunika kuchita ndi izi: zichotsani kapena ingosunthirani kumalo ena olembedwa. Mfundo ina yofunika ndi momwe chinthucho chafotokozedwacho chikugwirizana ndi mabala ena omwe alembedwa. Kupatula apo, mukachotsa kapena kusuntha chinthu chimodzi, malo pa pepalalo ndi mipata ina imasinthira. Chifukwa chake, izi zachidziwitso ndizofunikira kuganizira nthawi yomweyo isanayambe njira yochotsa.
