Nthaŵi zina pamene mukupanga chikalata ndi kuwerengera, wogwiritsa ntchito amafunika kubisa mawonekedwe poyang'ana maso. Choyamba, chosowa choterocho chimayambidwa chifukwa chosakhudzidwa kwa wogwiritsa ntchito kwa wosadziŵa kumvetsetsa kapangidwe kake. Mu Excel, mukhoza kubisa mafomu. Tidzadziwa mmene izi zingathere ndi njira zosiyanasiyana.
Njira zobisala mawonekedwe
Si chinsinsi kwa aliyense kuti ngati pali ndondomeko mu selo la tebulo la Excel, ndiye kuti likhoza kuwonedwa mu bar lachonde pokha posankha selo ili. Nthaŵi zina, izi sizili zoyenera. Mwachitsanzo, ngati wogwiritsa ntchito akufuna kubisala zambiri zokhudza kapangidwe ka mawerengero, kapena sakufuna kuti mawerengedwewa asinthe. Pankhani iyi, ndizomveka kubisa ntchitoyi.
Pali njira ziwiri zazikulu zogwirira ntchitoyi. Yoyamba ndiyo kubisa zomwe zili mu selo, njira yachiwiri ndi yovuta kwambiri. Mukagwiritsiridwa ntchito, lamulo likuletsedwa kugawa maselo.
Njira 1: Bisani Chilichonse
Njirayi ikugwirizana kwambiri ndi ntchito zomwe zili pamutu uno. Kugwiritsa ntchito kumangobisa zomwe zili m'kati mwa maselo, koma sizimapereka malamulo owonjezera.
- Sankhani mtundu umene muli nawo womwe mukufuna kubisala. Dinani botani lamanja la mouse pamalo osankhidwa. Mndandanda wamakono umatsegulidwa. Sankhani chinthu "Sezani maselo". Inu mukhoza kuchita chinachake chosiyana. Mutasankha mtunduwu, ingoyimitsani njira yachinsinsi Ctrl + 1. Zotsatira zidzakhala zofanana.
- Window ikutsegula "Sezani maselo". Pitani ku tabu "Chitetezero". Ikani nkhuni pafupi ndi chinthucho "Bisani mawonekedwe". Sungani chizindikiro cha parameter "Selo lotetezedwa" akhoza kuchotsedwa ngati simukukonzekera kuti musiye kusintha kuchokera kusintha. Koma, kawirikawiri, kutetezedwa ku kusintha ndi ntchito yaikulu, ndipo kubisala mafomu ndizosankha. Choncho, nthawi zambiri magulu awiri ochezera amatsalira. Timakanikiza batani "Chabwino".
- Pambuyo pazenera kutsekedwa, pitani ku tab "Kubwereza". Timakanikiza batani "Tetezani Tsamba"ili m'bokosi la zida "Kusintha" pa tepi.
- Mawindo amawonekera m'munda umene muyenera kutsegula mawu achinsinsi. Mudzasowa ngati mukufuna kuchotsa chitetezo m'tsogolomu. Zokonza zina zonse zikulimbikitsidwa kuti musiye zosasintha. Kenaka dinani pa batani. "Chabwino".
- Fina ina yatsegula yomwe muyenera kubwezeretsamo mawu achinsinsi omwe munalowetsamo kale. Izi zachitika kotero kuti wogwiritsa ntchito, chifukwa cha kufotokoza kwachinsinsi cholakwika (mwachitsanzo, muzithunzi zosinthidwa), sataya mwayi pa kusintha kwa pepala. Pano, komanso pambuyo poyambira mawu ofunika, dinani batani "Chabwino".
Zitatha izi, mayendedwe adzabisika. Palibe chomwe chidzasonyezedwe muzenera zamtundu wazinthu zotetezedwa pamene zisankhidwa.
Njira 2: Musasankhe maselo
Iyi ndi njira yowonjezereka kwambiri. Kugwiritsiridwa ntchito kwake kumapangitsa kuletsa kokha pakuwona mawonekedwe kapena kusintha maselo, koma ngakhale pa kusankha kwawo.
- Choyamba, muyenera kufufuza ngati bokosili likufufuzidwa "Selo lotetezedwa" mu tab "Chitetezero" tidziwa kale ndi njira yapitayi kutiwonetsera mawindo a zosankhidwazo. Mwachikhazikitso, chigawo ichi chiyenera kukhala chothandizidwa, koma kuwona malo ake sikukupweteka. Ngati, pambuyo pa zonse, palibe chongopeka pa mfundoyi, ndiye kuti iyenera kutengedwa. Ngati chirichonse chiri bwino, ndipo chimaikidwa, ndiye dinani basi "Chabwino"ili pansi pazenera.
- Komanso, monga momwe zinalili kale, dinani pa batani "Tetezani Tsamba"ili pa tabu "Kubwereza".
- Mofananamo, njira yapitayo imatsegula mawindo olowa pazinsinsi. Koma nthawi ino tifunika kusinthanso kusankha "Kugawidwa kwa maselo otsekedwa". Potero, tidzatsutsa njirayi pamtundu wosankhidwa. Pambuyo pake lowetsani mawu achinsinsi ndipo dinani pa batani "Chabwino".
- Muzenera yotsatira, komanso nthawi yotsiriza, timabwereza mawu achinsinsi ndikusindikiza pa batani "Chabwino".
Tsopano pa gawo losankhidwa kale la pepala, sitidzatha kungoona zomwe zili m'kati mwa maselo, koma ingozisankha. Mukayesa kusankha, uthenga udzakhala wosonyeza kuti mtunduwu watetezedwa ku kusintha.
Kotero, tapeza kuti mutha kutsegula mawonetsedwe a ntchito mu bar lachonde komanso mwachindunji mu selo m'njira ziwiri. Mwachizoloŵezi chobisala, zowonjezera zokha zimabisika, monga mbali yowonjezera yomwe mungaletsere kusinthidwa kwawo. Njira yachiwiri imatanthawuza kupezeka kwa zovuta zowonjezereka. Kugwiritsa ntchito sikulepheretsa kuwona zomwe zilipo kapena kusintha, koma sankhani selo. Chomwe mwazinthu ziwiri zomwe mungasankhe chimadalira, choyamba, pa ntchito. Komabe, nthawi zambiri, njira yoyamba imatsimikiziranso chitetezo chodalirika, ndipo kutseka kusankhidwa nthawi zambiri kumakhala kosafunikira kwenikweni.
