Zolinga zina, ogwiritsa ntchito akufunikira mutu wa tebulo kuti uwonekere, ngakhale pepala likupitirira kutali. Kuonjezera apo, nthawi zambiri zimafunika kuti chikalata chikasindikizidwire pamasamba (mapepala), patebulo likuwonekera pa tsamba lililonse. Tiyeni tipeze njira zomwe mungagwiritsire ntchito mutu wa Microsoft Excel.
Ikani mutu pamzere wapamwamba
Ngati mutu wa tebulo uli pamtunda, ndipo wokha sungagwiritse ntchito mzere umodzi, ndiye kuti kukonzekera kwake ndi ntchito yoyamba. Ngati pali mzere umodzi kapena zingapo zopanda pamwamba pamutu, ndiye kuti amafunika kuchotsedwa kuti agwiritse ntchito njirayi.
Kuti mukonze mutu, pokhala mu "View" tab ya Excel, dinani pa "Pin areas" batani. Bulu ili lili pavalo muwindo la gulu lawindo. Kenako, m'ndandanda yomwe imatsegulidwa, sankhani malo "Yesani mzere wapamwamba."
Pambuyo pake, mutu, womwe uli pamzere wapamwamba, udzakhazikitsidwa, nthawi zonse kukhala pamalire a chinsalu.
Malo a Pinning
Ngati pazifukwa zina wosuta sakufuna kuchotsa maselo omwe alipo pamwamba pa mutu, kapena ngati ali ndi mzere woposa umodzi, ndiye kuti njira yowonjezerayi isagwire ntchito. Tiyenera kugwiritsa ntchito njira yokonzekera dera, lomwe, silovuta kwambiri kuposa njira yoyamba.
Choyamba, pita ku tabu "Onani". Pambuyo pake, dinani selo lakumanzere pansi pa mutu. Kenaka, timakani pa batani "Konzani dera", lomwe talitchula kale. Kenaka, muzinthu zosinthidwa, pewani chinthucho ndi dzina lomwelo - "Konzani madera".
Pambuyo pazochitikazi, mutu wa tebulo udzakhazikitsidwa pa pepala laposachedwapa.
Tsekani mutu
Mulimonse mwa njira ziwiri zomwe zafotokozedwa pamwambapa, mutu wa tebulo sukanakhazikitsidwa, kuti uwone, pali njira imodzi yokha. Kachiwiri, timangodutsa pa batani pa "Malo Ophatikizidwa" mpiringidzo, koma nthawi ino timasankha malo "Chotsani zitsulo" zomwe zikuwonekera.
Pambuyo pake, mutu wotsatiridwawo udzasintha, ndipo pamene mupukuta pansi pepala, sudzawoneka.
Pindani pamutu mukasindikiza
Pali zochitika pamene, pamene mukusindikiza chikalata, akufunikira kuti mutu ukhalepo pa tsamba lililonse losindikizidwa. Inde, mungathe "kupasula" tebulo palimodzi, ndikulowetsani malo abwino. Koma, njira iyi ikhoza kutenga nthawi yochuluka, ndipo, kuonjezera, kusintha koteroko kungathe kuwononga kukhulupirika kwa tebulo, ndi dongosolo la kuwerengera. Pali njira yosavuta komanso yowonjezera yosindikiza tebulo ndi mutu pa tsamba lirilonse.
Choyamba, pita ku tabu la "Tsamba". Tikuyang'ana bokosi la zolemba za "Mapepala". M'ngodya yake ya kumanzere kumanzere ndi chizindikiro chokhala ngati chingwe chotsekeka. Dinani pa chithunzi ichi.
Mawindo omwe ali ndi tsamba angatsegule. Pitani ku tati "Tsamba". Kumunda pafupi ndi kulembedwa "Lembani mapepala otsiriza kumapeto pa tsamba lirilonse" muyenera kufotokoza zigawo za mzere umene mutu ulipo. Mwachidziwikire, kwa wosakonzekera wosuta sikumakhala kosavuta. Choncho, dinani pa batani yomwe ili kumanja kwa gawo lolowera deta.
Mawindo omwe ali ndi mapangidwe a tsamba akuchepetsedwa. Pa nthawi yomweyi, pepala ndi tebulo likugwira ntchito. Sankhani mzere (kapena mizere ingapo) yomwe mutu umayikidwa. Monga mukuonera, makonzedwe amalowa muwindo lapadera. Dinani pa batani kumanja kwawindo ili.
Apanso, zenera zimatsegula ndi tsamba lokhazikitsa. Tiyenera kungodinkhani pakani "OK" yomwe ili m'munsimu.
Zochita zonse zoyenera zakwaniritsidwa, koma zowonekera simudzawona kusintha kulikonse. Kuti muwone ngati dzina la tebulolo lidasindikizidwa pakanema lirilonse, pita ku tchati "Fayilo" ya Excel. Kenako, pitani ku "Magazini".
Mu gawo labwino lazenera lotseguka pali malo oyang'anitsitsa a zolembedwazo. Lembani pansi, ndipo onetsetsani kuti kusindikiza pa tsamba lirilonse la chikalata lidzasonyeza mutu wotchulidwa.
Monga mukuonera, pali njira zitatu zothetsera mutu mu tebulo la Microsoft Excel. Zambiri mwazigawozi zimakonzedwa kuti zikhazikike mu editor spreadsheet yokha, pakugwira ntchito ndi chikalata. Njira yachitatu imagwiritsidwa ntchito kusonyeza mutu pa tsamba lirilonse la zolembedwa. Ndikofunika kukumbukira kuti n'zotheka kukonzekera mutu kupyolera mndandanda wa mzere kokha ngati uli pa umodzi, ndi mzere wapamwamba wa pepala. Mulimonsemo, muyenera kugwiritsa ntchito njira yokonzekera.
