Momwe mungakonzere mutu wa tebulo mu Excel. Kukonzekera kwa mzere wapamwamba, kapu yovuta

Mukamagwira ntchito ndi matebulo aatali omwe sakugwirizana ndi zenera komanso kukhala ndi mizati yambiri, nthawi ndi nthawi pamafunika kupukuta chophimba kuti muwonetse mzere wapamwamba wokhala ndi mitu. Kuti zikhale zosavuta, pulogalamu ya Excel imapereka mwayi wokonza mutu wa tebulo pamwamba pa chinsalu nthawi yonse yomwe fayilo imatsegulidwa. Zosankha zokwaniritsa izi zikukambidwa pansipa.

Mzere umodzi wokha wa pamwamba uyenera kusindikizidwa

1. Pamzere wapamwamba wa riboni ya pulogalamuyo, pitani ku tabu "Onani".
2. Mu gawo la "Window" (mayina agawo akuwonetsedwa pansi pa riboni), pezani chinthucho "Ikani madera" ndikudina pamakona atatu kumanja kwake.
3. Pamndandanda womwe umatsegulidwa, sankhani "Khomani mzere wapamwamba" podina batani lakumanzere. Chotsatiracho chidzakhala kupezeka kosatha pawindo la mzere wamutu wa tebulo, womwe umapitirirabe ngakhale fayilo itatsekedwa.
   

   

Kulumikiza mutu ku mizere ingapo

Ngati mukufuna kukonza mizere ingapo, ndiye kuti muyenera kuchita mosiyana:

1. Kumanzere kwenikweni kwa tebulo, dinani pa selo la mzere woyamba lomwe silili gawo lamutu. Pankhaniyi, ndi selo A3.
   

   

2. Pitani ku tabu ya "Onani", dinani "Magawo Ozizira" ndikusankha chinthu cha "Freeze Area" pamndandanda wotsikirapo. Zotsatira zake, mizere yonse yomwe ili pamwamba pa yomwe selo yosankhidwayo ili nayo idzakhazikika pamwamba pa chinsalu.
   

   

"Smart table" - njira ina yokonza mutu

Ngati mumadziwa ma spreadsheets anzeru a Excel, pali njira ina yothandiza yowasindikiza. Zowona, njirayi imagwira ntchito pokhapokha pamutu wa mzere umodzi.

1. Pa tabu Yanyumba ya riboni, sankhani tebulo lonse.
2. Mu gawo la "Masitayelo" (pamunsi pa riboni), dinani chinthu cha "Format as Table". Zenera lokhala ndi masitayelo a tebulo lidzatsegulidwa. Mmenemo muyenera alemba pa njira yabwino kwambiri.
   

   

3. Zenera la "Table Formatting" likuwonekera, momwe malire a tebulo lamtsogolo amasonyezedwa, ndipo bokosi la "Table with Headers" lilinso. Onetsetsani kuti chomalizacho chafufuzidwa.
4. Tsekani zenera podina batani "Chabwino".
   

   

Mutha kupanga "smart table" mwanjira ina:

1. Mukasankha malo omwe mukufuna, pitani ku tabu ya "Insert" ndikudina "Matebulo".
2. Mu pop-up list, dinani "Table" chinthu.
3. Pambuyo pa "Pangani Table" zenera limapezeka ndi zomwe zili chimodzimodzi monga "Format Table" zenera, muyenera kutsatira njira zofanana ndi zomwe tafotokozazi kale. Chotsatira chake, "tebulo lanzeru" lidzawonekeranso ndi kapu yokhazikika pamwamba.
   

   

Momwe mungasindikize tebulo lokhala ndi mutu patsamba lililonse

Mukasindikiza tebulo lokhala ndi masamba angapo, ndikofunikira kukhala ndi mutu patsamba lililonse. Izi zimakupatsani mwayi wogwira ntchito ndi tsamba lililonse losindikizidwa padera. Mu Excel, mwayi uwu umaperekedwa ndipo ukhoza kukhazikitsidwa motere.

1. Pitani ku riboni ya "Mapangidwe a Tsamba" ndi gawo la "Kukhazikitsa Tsamba" (pamunsi pa riboni) dinani pabokosi lomwe lili ndi muvi kumanja kwa zolembedwazo.
   

   

2. Pazenera la Kukhazikitsa Tsamba lomwe limatsegulidwa, pitani ku tabu ya Mapepala.
3. Dinani pa bokosi la "Kupyolera mu mizere" (lachiwiri kuchokera pamwamba).
4. Bwererani ku tebulo ndipo, posuntha cholozera, chomwe chatenga mawonekedwe a muvi wakuda wolozera kumanja, pamodzi ndi mzere wokhala ndi manambala a mzere, sankhani mzere kapena mizere yomwe mutu wa tebulo uli.
   

   

5. Pa izi, zochita zonse zatha, koma zotsatira zake sizimawonetsedwa pazenera.
   

   

Zofunika! Kuti muwonetsetse kuti cholingacho chakwaniritsidwa, muyenera kupita ku tabu ya "Fayilo" ndikudina "Sindikizani". Pawindo lomwe limatsegulidwa, mtundu wa chikalatacho chifukwa cha kusindikiza kwake udzawonetsedwa.

Apa, podina pamakona atatu pansi pazenera kapena kusuntha gudumu la mbewa, ndi cholozera patsamba la tebulo, mutha kuwona masamba onse kuti muwone ngati pali mutu pa chilichonse cha iwo.

Mawuwo

Mu Excel, pali njira ziwiri zowonetseratu mutu wa tebulo pazenera. Chimodzi mwa izo chimaphatikizapo kugwiritsa ntchito kukonza malo, chachiwiri - kutembenuza tebulo kukhala "wanzeru" pokonza malo osankhidwa a kuika tebulo mmenemo. Njira zonse ziwiri zimathandizira kusindikiza mzere umodzi, koma yoyamba yokha imakulolani kuchita izi ndi mutu wokhala ndi mizere yambiri.. Excel imakhalanso ndi mwayi wowonjezera - kukwanitsa kusindikiza chikalata chokhala ndi mutu pa tsamba lililonse, zomwe zimawonjezera mphamvu yogwira ntchito nayo.