Excel imakupatsani mwayi wokopera masamba omwe adapangidwa kale, kuwasuntha mkati ndi kunja kwa bukhu lamakono, ndikusintha mtundu wa ma tabu kuti muzitha kuyenda mosavuta pakati pawo. Mu phunziro ili, tisanthula mbali zonsezi mwatsatanetsatane momwe tingathere ndikuphunzira kukopera, kusuntha ndi kusintha mtundu wa mapepala mu Excel.
Koperani mapepala mu Excel
Ngati mukufuna kukopera zomwe zili patsamba lina kupita ku lina, Excel imakupatsani mwayi wopanga mapepala omwe alipo.
- Dinani kumanja pa tabu ya pepala yomwe mukufuna kukopera, ndipo sankhani kuchokera pazosankha Sunthani kapena kukopera.
- Bokosi la zokambirana lidzatsegulidwa Sunthani kapena kukopera. Apa mutha kutchulanso pepala lomwe mukufuna kuyikapo. M'malo mwathu, tidzafotokozera Pitani kumapetokuyika pepala kumanja kwa pepala lomwe lilipo.
- Sankhani bokosi Pangani kopikenako dinani OK.
- Tsambalo lidzakopedwa. Idzakhala ndi dzina lofanana ndendende ndi pepala loyambirira, kuphatikiza nambala yamtundu. Kwa ife, tinakopera pepalalo ndi dzina January, kotero kuti pepala latsopanolo lidzatchedwa Januware (2). Zonse zomwe zili papepala January idzakoperanso ku pepala Januware (2).
Mutha kukopera pepala ku bukhu lililonse la Excel, bola ngati lili lotseguka. Mutha kusankha buku lofunikira kuchokera pamndandanda wotsikira m'bokosi la zokambirana. Sunthani kapena kukopera.
Sungani pepala mu Excel
Nthawi zina zimakhala zofunikira kusuntha pepala ku Excel kuti musinthe mawonekedwe a bukhuli.
- Dinani pa tabu la pepala lomwe mukufuna kusuntha. Cholozeracho chidzasanduka chithunzi chaching'ono cha pepala.
- Gwirani pansi mbewa ndikukoka chizindikiro cha pepala mpaka kavi kakang'ono kakuda kakuwonekera pamalo omwe mukufuna.
- Tulutsani batani la mbewa. Tsambalo lisunthidwa.
Sinthani mtundu wa tabu mu Excel
Mutha kusintha mtundu wa ma tabu amasamba kuti muwakonze ndikupangitsa kukhala kosavuta kuyang'ana bukhu la Excel.
- Dinani kumanja pa tabu ya tsamba lomwe mukufuna ndikusankha chinthucho kuchokera pamenyu yankhani Mtundu wa chizindikiro. Colour Picker idzatsegulidwa.
- Sankhani mtundu womwe mukufuna. Mukayang'ana pazosankha zosiyanasiyana, chithunzithunzi chidzawonekera. Mu chitsanzo chathu, tidzasankha zofiira.
- Mtundu wa chizindikirocho udzasintha.
Tsamba likasankhidwa, mtundu wa tabu umakhala wosawoneka. Yesani kusankha pepala lina lililonse mu buku la Excel ndipo muwona nthawi yomweyo momwe mtunduwo umasinthira.