Nthawi zina popanga chikalata chowerengera, wogwiritsa ntchito amafunika kubisa njira kuti asawononge. Choyamba, chosowa ichi chimayamba chifukwa cha kusakonda kwa wogwiritsa ntchito kotero kuti wakunja amvetsetse momwe malembawo aliri. Pulogalamu ya Excel imatha kubisa njira. Tiyeni tiwone momwe izi zingachitikire m'njira zosiyanasiyana.
Njira zobisira formula
Si chinsinsi kuti ngati pali fomula mu foni yamtundu wa Excel, mutha kuiwona mu kapangidwe kake ndikungowunikira foniyi. Nthawi zina, izi ndizosayenera. Mwachitsanzo, ngati wogwiritsa ntchito akufuna kubisa zokhudzana ndi mawerengeredwe kapena safuna kuti mawerengetsowa asinthe. Poterepa, chinthu chofunikira ndikubisa ntchitoyo.
Pali njira ziwiri zazikulu zochitira izi. Woyambayo akubisala zomwe zili mu cell, njira yachiwiri ndiyosinthika. Mukamagwiritsa ntchito, chiletso chimayikidwa pakusankhidwa kwa maselo.
Njira 1: kubisa zomwe zili
Njira iyi imagwirizana kwambiri ndi zomwe zaperekedwa pamutuwu. Mukamagwiritsa ntchito, ndizomwe zili m'maselo zomwe zimabisidwa, koma palibe zoletsa zina zomwe zimakhazikitsidwa.
- Sankhani mtundu womwe mukufuna kubisa. Dinani kumanja pamalo osankhidwa. Zosankha zam'mawu zimatsegulidwa. Sankhani chinthu Mtundu Wa Cell. Mutha kuchita zosiyana. Pambuyo posonyeza mtunduwo, lembani njira yaying'ono Ctrl + 1. Zotsatira zake zidzakhala chimodzimodzi.
- Zenera limatseguka Mtundu Wa Cell. Pitani ku tabu "Chitetezo". Chongani bokosi pafupi Bisani Machitidwe. Checkmark ndi njira "Selo yotetezedwa" ikhoza kuchotsedwa ngati simukonzekera kuletsa mtunduwo pakusintha. Koma nthawi zambiri, chitetezo kuzosintha ndi ntchito yayikulu, ndipo kubisala njira ndizowonjezera. Chifukwa chake, nthawi zambiri, mawonekedwe onsewo amasiyidwa. Dinani batani "Zabwino".
- Zenera litatseka, pitani tabu "Ndemanga". Dinani batani Tetezani Mapepalaili mu chipangizo "Sinthani" pa tepi.
- Iwindo limatsegulidwa m'munda womwe muyenera kulowamo achinsinsi. Zidzafunika ngati mukufuna kuchotsa chitetezo mtsogolo. Zosintha zina zonse zimalimbikitsidwa kuti zizisiyidwa ndikusintha. Kenako dinani batani "Zabwino".
- Windo linanso limatseguka pomwe muyenera kuyikiranso mawu achinsinsi omwe adalowetsedwa kale. Izi zimachitika kuti wosuta, chifukwa chakuyambitsa achinsinsi cholakwika (mwachitsanzo, mumasinthidwe), sataya mwayi wosintha chikalatacho. Apa, komanso mutalowa mawu ofunikira, dinani batani "Zabwino".
Pambuyo pa izi, mawonekedwe ake amabisika. Mu baramu yokhotakhota ya mtundu wotetezedwa, mukasankhidwa, palibe chomwe chidzawonetsedwa.
Njira yachiwiri: kuletsa maselo
Iyi ndi njira yosinthira. Kugwiritsira ntchito kwake kumayambitsa choletsa osati kungowona mawonekedwe kapena maselo osinthika, komanso ngakhale posankha.
- Choyamba, muyenera kuyang'ana ngati chekiyo ayendera pafupi ndi paramu "Selo yotetezedwa" pa tabu "Chitetezo" ozolowera kale momwe amatidziwitsira zenera la mitundu yosankhidwa. Mwachidziwikire, gawo ili liyenera kuti lidapatsidwa mwayi, koma kuyang'ana momwe silili. Ngati, komabe, palibe cholembera mundime iyi, ndiye kuti iyenera kufufuzidwa. Ngati zonse zili bwino ndipo zaikidwa, ndiye dinani batani "Zabwino"ili pansi pazenera.
- Kenako, monga momwe zinalili kale, dinani batani Tetezani Mapepalaili pa tabu "Ndemanga".
- Momwemonso ndi njira yapita, zenera lolowera achinsinsi limatseguka. Koma nthawi ino tikuyenera kusankha njira "Sankhani maselo otsekeka". Chifukwa chake, tikuletsa kuchita njirayi pamitundu yosankhidwa. Pambuyo pake, lowetsani mawu achinsinsi ndikudina batani "Zabwino".
- Pazenera lotsatira, monga nthawi yomaliza, bwerezani mawu achinsinsi ndikudina batani "Zabwino".
Tsopano, mu gawo lomwe lasankhidwa kale la pepalali, sitingangoona zomwe zili m'maselo, ngakhale kungosankha. Mukayesa kusankha, uthenga umawoneka kuti mtunduwo watetezedwa pakusintha.
Chifukwa chake, tapeza kuti mutha kuletsa kuwonetsa kwa ntchito mu baramu yodutsa ndikuwonekera mwachindunji mu cell m'njira ziwiri. Pobisala zomwe zili mumtunduwu, mafomula okha ndiwo obisika, ngati mwayi wowonjezera mungathe kuletsa zoletsa. Njira yachiwiri ikutanthauza kukhalapo kwa zoletsa zolimba kwambiri. Mukamagwiritsa ntchito, osati luso loona zomwe zilimo kapena kuzisintha zatsekeredwa, komanso kusankha khungu. Ndi iti mwa njira ziwiri zomwe mungasankhe zimatengera, choyamba, zimagwira ntchito zomwe zidakhazikitsidwa. Komabe, nthawi zambiri, njira yoyamba imatsimikizira chitetezo chokwanira, ndipo kutsekereza kagawidwe kake nthawi zambiri kumakhala kofunika kusamala.
