Mapepala Obisika mu Excel: Momwe Mungasonyezere Kapena Kubisala

Mu Excel, wogwiritsa ntchito amatha kupanga ndikugwira ntchito pamapepala angapo nthawi imodzi. Ndipo nthawi zina, pazifukwa zosiyanasiyana, pangafunike kubisa zina mwa izo. Mwachitsanzo, poona chikhumbo chobisa chidziŵitso chamtengo wapatali kwa anthu amene akuona, chomwe chingakhale chachinsinsi ndipo, tinene, chamtengo wapatali pazamalonda. Kapena, wogwiritsa ntchito amangofuna kudziteteza ku zochitika mwangozi ndi deta pa pepala lomwe siliyenera kukhudzidwa.

Kotero, momwe mungabise pepala mu Excel? Pali njira ziwiri zochitira izi. Tiyeni tione aliyense wa iwo.

Momwe mungabisire pepala pogwiritsa ntchito menyu

Iyi ndi njira yosavuta komanso yachangu kwambiri yobisira pepala, yomwe imachitika mu masitepe awiri okha.

1. Kuti tichite izi, tifunika kuyitanira menyu yankhani ndikudina kumanja patsamba lomwe tikufuna.
2. Sankhani "Bisani" kuchokera pamndandanda womwe umawonekera.
3. Izi, kwenikweni, ndizo zonse. Tsamba lofunikira limabisika.

Kubisala pogwiritsa ntchito zida zamapulogalamu

Njira yodziwika bwino, komabe, kudziwa za izo sikudzakhala kopanda phindu.

1. Choyamba, sankhani pepala lomwe mukufuna kubisa.
2. Pitani ku tabu ya "Home", dinani "Maselo" chida, muzosankha zomwe zikuwoneka, sankhani "Format".
3. Pamndandanda womwe umatsegulidwa, sankhani "Bisani kapena onetsani" ndiyeno "Bisani pepala".

   

4. Tsamba losankhidwa lidzabisika.

Zindikirani: ngati miyeso ya zenera ndi pulogalamu ya Excel ilola, batani la "Format" liziwonetsedwa nthawi yomweyo pagawo la "Home", kudutsa bokosi la "Maselo".

Momwe mungabisire mapepala angapo

Njira yobisala mapepala angapo, kwenikweni, imakhala yosiyana kwambiri ndi yomwe yafotokozedwa pamwambapa. Komabe, musanapitirize, muyenera kusankha mapepala onse omwe akuyenera kubisika.

1. Ngati mapepalawo akonzedwa motsatira, kiyi ya Shift idzakhala yothandiza. Sankhani pepala loyamba, gwirani batani la Shift, ndipo popanda kulimasula, dinani pa pepala lomaliza, ndikumasula kiyiyo. Kusankhidwa kungathenso kuchitidwa mosiyana - kuchokera komaliza mpaka koyamba. Mwachibadwa, tikukamba za mapepala oyambirira ndi otsiriza omwe ayenera kubisika.
2. Ngati mapepala obisika sanasankhidwe motsatira, ayenera kusankhidwa pogwiritsa ntchito Ctrl kiyi (Cmd - kwa macOS). Timachigwira pansi ndikudina kumanzere pamapepala onse omwe akuyenera kubisika. Mutha kumasula fungulo la Ctrl.
3. Tasankha mapepala onse ofunikira, tsopano mutha kuwabisa pogwiritsa ntchito njira zomwe zaperekedwa kale. Zotsatira zake zidzakhala zofanana.

Kutsiliza

Chifukwa chake, tangoganizirani momwe tingabisire mapepala ku Excel m'njira ziwiri. Mosasamala kanthu komwe mumasankha, phindu la ntchitoyi nthawi zina likuwonekera, kotero chidziwitso ndi luso logwiritsa ntchito zidzathandiza ogwiritsa ntchito omwe nthawi zambiri amagwira ntchito ndi pulogalamuyi kangapo.