Monga mukudziwa, mu buku la Excel muli mwayi wopanga ma sheet angapo. Kuphatikiza apo, makonda osinthika amawonetsedwa kuti chikalatacho chikapanga kale zinthu zitatu. Koma, pali milandu yomwe ogwiritsa ntchito ayenera kuchotsa ma sheet ena kapena opanda kanthu kuti asasokoneze. Tiyeni tiwone momwe izi zingachitike m'njira zosiyanasiyana.
Njira Zochotsa
Pulogalamu ya Excel imatha kuchotsa pepala limodzi komanso zingapo. Ganizirani momwe zimachitikira pochita.Njira 1: Kuchotsa Mumembala
Njira yosavuta komanso yofunikira kwambiri yogwiritsira ntchito njirayi ndikugwiritsa ntchito mwayi kuti muthe kuti mndandandawo uzipereka. Timapanga batani lamanja pa mzere, lomwe silikufunikanso. Mu mndandanda woyambitsa, sankhani "Chotsani" chinthu.
Pambuyo pa izi, pepalalo lizitha pamndandanda wazinthu zomwe zili pamwamba pa bar.
Njira 2: Kuchotsa Zida za Temp
Ndikotheka kuchotsa chinthu chosafunikira pogwiritsa ntchito zida zomwe zili pa tepi.
- Pitani pa pepala lomwe tikufuna kuchotsa.
- Tili mu "Home", dinani batani pa batani "Chotsani" pa "zida zam'manja". Mumenyu zomwe zikuwoneka, dinani chithunzi mu mawonekedwe a makongwa pafupi ndi batani la "Chotsani". Pazakudya zotseguka, siyani kusankha kwanu pa "Chotsani tsamba".
Pepala logwira lidzachotsedwa nthawi yomweyo.
Njira 3: Kuchotsa zinthu zingapo
Kwenikweni, njira yochotsa kuchotsedwa pakokha ndizofanana ndendende monga momwe zinthu ziwiri zomwe zafotokozedwazi. Kungochotsa ma sheet angapo musanayambe kuyendetsa mwachindunji, tidzawagawira.
- Kugawa zinthu zomwe zili mu dongosolo, gwiritsitsani kiyi yosinthira. Kenako dinani pa chinthu choyamba, kenako chomaliza, chogwirizira batani likukanikizidwa.
- Ngati zinthu zomwe mukufuna kuchotsa sizili limodzi, koma kubalalitsidwa, ndiye kuti mufunika kukanikiza batani la CTRL. Kenako dinani dzina lililonse la mapepala omwe adzafunika kuchotsedwa.
Zinthu zitawunikiridwa, ndikofunikira kugwiritsa ntchito njira imodzi mwanjira ziwiri zochotsedwa, zomwe zidakambidwa pamwambapa.
Phunziro: Momwe mungawonjezere pepala mu Exale
Monga mukuwonera, chotsani ma sheet osafunikira mu pulogalamu ya Excel ndi yosavuta. Ngati mukufuna, ndizothekanso kuchotsa zinthu zingapo nthawi imodzi.