Zimadziwika kwambiri kuti m'buku limodzi (fayilo) Excel ili ndi ma sheet atatu osasinthika, omwe mungawasinthe. Chifukwa chake, ndizotheka kupanga zikalata zingapo zokhudzana ndi fayilo imodzi. Koma choti ndichite, ngati palibe chiwerengero chokwanira cha ma tabu owonjezerawa? Tiyeni tichite ndi momwe mungaonjezera gawo latsopano.
Njira Zowonjezera
Momwe mungasinthire pakati pa ma sheets, amadziwa ogwiritsa ntchito ambiri. Kuti muchite izi, dinani pa chimodzi mwazinthu zawo, zomwe zili pamwamba pa bar yakumanzere.
Koma si aliyense amene amadziwa kuwonjezera ma sheet. Ogwiritsa ntchito ena sadziwa ngakhale kuti pali mwayi womwewo. Tiyeni tichitene ndi momwe mungapangire njira zosiyanasiyana.
Njira 1: Gwiritsani ntchito batani
Njira yogwiritsidwa ntchito nthawi zambiri yowonjezera ndikugwiritsa ntchito batani yotchedwa "Itket Let". Izi ndichifukwa choti njirayi ndi yofunika kwambiri kuposa onse. Batani lowonjezera limapezeka pamwamba pamtunda kumanzere kwa mndandanda wazinthu zomwe zilipo kale.
- Kuti muwonjezere pepala kungodina batani lomwe latchulidwa pamwambapa.
- Dzina la pepala latsopanolo limawonetsedwa nthawi yomweyo pazenera pamwamba pa bar, ndipo wosuta asintha.
Njira 2: Menyu
Ndizotheka kuyika chinthu chatsopano pogwiritsa ntchito mndandanda wazomwe zili.
- Dinani kumanja pa mapepala aliwonse omwe alipo m'bukuli. Muzosankha zomwe zikuwoneka, sankhani "phala ...".
- Windo latsopano limatsegulidwa. Mmenemo, tiyenera kusankha zomwe tikufuna kuti tiikemo. Sankhani "pepala". Dinani pa batani la "OK".
Pambuyo pake, pepala latsopanolo liwonjezedwa pamndandanda wazinthu zomwe zili pamwamba pa bar.
Njira 3: Chida pa nthiti
Mwayi wina wopanga pepala latsopano umaphatikizapo kugwiritsa ntchito zida zomwe zayikidwa pa tepi.
Tili mu "kunyumba" tabu, dinani chithunzi mu mawonekedwe a Triangle yolumikizidwa pafupi ndi batani la "phala", lomwe limayikidwa pa tepi mu chidole. Mumenyu yomwe imawoneka, sankhani "Ikani pepala".
Pambuyo pa zochita izi, kulowetsedwa kwa chinthu kumene.
Njira 4: makiyi otentha
Komanso, kuchita ntchitoyi, mutha kugwiritsa ntchito, otchedwa hotskey. Ingolembani makiyi + a F11 pa kiyibodi. Pepala latsopano silidzangowonjezeredwa, komanso kukhala achangu. Ndiye kuti, mukatha kuwonjezera wosuta nthawi yomweyo amangopita kwa iwo.
Phunziro: Makiyi otentha kwambiri
Monga mukuwonera, pali zosankha zinayi zosiyana zowonjezera pepala latsopano m'buku la Excel. Wogwiritsa aliyense amasankha njira yomwe imawoneka yosavuta, chifukwa palibe njira yogwirira ntchito pakati pa zosankha. Zachidziwikire, Hotkeys ndiosavuta kugwiritsa ntchito zolinga izi, koma si munthu aliyense yemwe angasungidwe m'mutu, chifukwa chake ogwiritsa ntchito ambiri amagwiritsa ntchito moyenera njira zokwanira zowonjezera.