Excel imapereka zida zambiri zowongolera mawonekedwe a buku lantchito. M'phunziro lapitali, taphunzira kale momwe mungasinthire mizere ndi mizati. Mu izi, tiwona zida zingapo zomwe zimakulolani kugawa pepala mu magawo angapo, komanso kuwona chikalata m'mawindo osiyanasiyana.
Ngati bukhu la Excel lili ndi deta yambiri, zingakhale zovuta kupanga mapu a magawo osiyanasiyana. Excel ili ndi zina zowonjezera zomwe zimapangitsa kuti zikhale zosavuta kumvetsetsa ndikufanizira deta. Mwachitsanzo, mutha kutsegula buku pawindo latsopano kapena kugawa pepala m'malo osiyanasiyana.
Kutsegula buku lapano pawindo latsopano
Excel imakulolani kuti mutsegule buku lofananalo m'mawindo angapo nthawi imodzi. M'chitsanzo chathu, tigwiritsa ntchito gawoli kuti tifanizire mapepala awiri osiyana mu bukhu lothandizira lomwelo.
- Dinani View pa Riboni, ndiyeno sankhani lamulo Zenera latsopano.
- Zenera latsopano lidzatsegulidwa la bukhu lapano.
- Tsopano mutha kufananiza masamba a bukhu lomwelo m'mawindo osiyanasiyana. Mu chitsanzo chathu, tidzasankha lipoti la malonda a 2013 kuti tifanizire malonda mu 2012 ndi 2013.
Ngati muli ndi mawindo angapo otseguka, mutha kugwiritsa ntchito lamulo Konzani Chilichonse kwa gulu mwachangu mawindo.
Kugawa pepala m'madera osiyana
Excel imakupatsani mwayi wofananizira magawo atsamba lomwelo popanda kupanga mawindo owonjezera. Gulu Kugawa amakulolani kugawa pepalalo m'madera osiyana omwe angathe kupukuta popanda wina ndi mzake.
- Sankhani selo komwe mukufuna kugawa pepala. Ngati musankha selo mu gawo loyamba kapena mzere woyamba, ndiye kuti pepalalo lidzagawidwa m'magawo a 2, mwinamwake lidzagawidwa mu 4. Mu chitsanzo chathu, tidzasankha selo C7.
- Dinani View pa Riboni, ndiyeno dinani lamulo Kugawa.
- Tsambali lidzagawidwa m'madera angapo. Mukhoza kuyendayenda m'dera lililonse padera pogwiritsa ntchito scrollbar. Izi zikuthandizani kuti mufananize magawo osiyanasiyana a pepala limodzi.
Mutha kukoka zolekanitsa zoyima ndi zopingasa kuti musinthe kukula kwa gawo lililonse. Kuti muchotse magawano, dinani lamulo kachiwiri Kugawa.