Mukasindikiza chikalata cha Excel, nthawi zambiri pamakhala momwe mulifupi pomwe tebulo siligwirizana ndi pepala lokhazikika. Chifukwa chake, chilichonse chomwe chimapita kuposa malire aja, chosindikizira chosindikizira. Koma, nthawi zambiri, izi zitha kuwongoleredwa posintha cholembera chomwe chikalatacho ndi bukuli, chomwe chimayikidwamo mosasunthika, pa mawonekedwe. Tiyeni tiwone momwe mungachitire izi mothandizidwa ndi njira zosiyanasiyana zowonjezera.
Phunziro: Momwe Mungapangire Malo Omwe Amayendera Mu Microsoft Mawu
Tembenuzani chikalatacho
Pakufunsira bwino, pali zosankha ziwiri zokudziwitsa ma sheet posindikiza: Buku ndi mawonekedwe. Woyamba ndi woyenera. Ndiye kuti, ngati simunachite zolakwika ndi izi mu chikalatachi, ndiye posindikiza Iyo ipita ku Buku la buku. Kusiyanitsa kwakukulu pakati pa mitundu iwiriyi yokhazikitsa ndi yomwe ili pansi pa bukuli kutalika kwatsamba ndi kofanana, komanso malo osemphana.
Mwakutero, makina a njira yosinthira tsambalo ndi buku la buku la bukulo mu pulogalamu ya Excel ndi yokhayo, koma imatha kuyamba kugwiritsa ntchito imodzi mwazosankha zingapo. Nthawi yomweyo, pepala lililonse payekha lingagwiritsidwe ntchito. Nthawi yomweyo, mkati mwa pepala limodzi, gawo ili limasinthidwa kukhala zinthu zamunthu (masamba).
Choyamba, ndikofunikira kudziwa kuti mungayankhe chikalatacho. Mwakutero, mutha kugwiritsa ntchito mowonera. Kuti muchite izi, kutembenukira ku "fayilo" tabu, pitani ku gawo la "kusindikiza". Kumanzere kwa zenera pali gawo lowonetsera chikalata, popeza liziwoneka ngati kusindikiza. Ngati mu ndege yopingasa imagawidwa m'masamba angapo, ndiye kuti izi zikutanthauza kuti tebulo siligwirizana papepala.
Ngati, njirayi itachitika, tidzabweranso ku "kunyumba" kunyumba, ndiye kuti tionane ndi mzere wogawika. Pankhaniyo ikagawika tebulo, ndiye umboni wowonjezereka kuti mukasindikiza, mizati yonse patsamba limodzi silingayikidwe.
Chifukwa cha izi, ndibwino kusintha mayendedwe a chikalatacho ku malowo.
Njira 1: Kusindikiza Kusindikiza
Nthawi zambiri, ogwiritsa ntchito amagwiritsidwa ntchito pazida zomwe zili mu makina osindikiza.
- Pitani ku "Fayilo" Tab (mu Excel 2007, m'malo mwake, muyenera dinani pa Maofesi a Microsoft pakona yakumanzere kwa zenera).
- Kusunthira gawo la "chosindikizira".
- Atseguka mwachidziwikire kuti dera la chiwonetserochi. Koma nthawi ino sadzakondwera nafe. Mu "kukhazikitsa" podina batani la "buku la" buku la "buku".
- Kuchokera pamndandanda wotsika, sankhani chinthucho "makwerero".
- Pambuyo pake, mawonekedwe a masamba ochulukirapo adzasinthidwa kukhala malo, omwe amatha kuwonedwa mu chithunzithunzi cha chikalata chosindikizidwa.
Njira 2: Tsamba la Tsamba
Pali njira yosavuta yosinthira cholowa cha pepalalo. Itha kuchitidwa mu "Tsamba la Tsamba" Tab.
- Pitani ku tsamba la tabu ". Dinani pa batani la "Internation", lomwe limayikidwa mu "masamba a masamba". Kuchokera pamndandanda wotsika, sankhani "zotchinga".
- Pambuyo pake, mawonekedwe a pepala lapano lidzasinthidwa ndi mawonekedwe.
Njira 3: Kusintha kwa ma sheet angapo nthawi imodzi
Mukamagwiritsa ntchito njira zomwe zafotokozedwa pamwambapa, malangizo a malowa amawonetsedwa pokhapokha. Nthawi yomweyo, pali mwayi wogwiritsa ntchito gawo ili la zinthu zingapo zofanana nthawi yomweyo.
- Ngati mapepala omwe mukufuna kugwiritsa ntchito Gulu Kenako dinani pa zilembo zomaliza. Chifukwa chake, onse osiyanasiyana adzatsimikiziridwa.
Ngati mukufuna kusintha ma sheets pa mapepala angapo, mosapita m'mbali omwe sanapezeke pafupi, ndiye kuti algorithm yochitapo kanthu ndizosiyana pang'ono. Dinani batani la CTRL pa kiyibodi ndikudina njira yachidule iliyonse, yomwe muyenera kuchita ntchito yakale. Chifukwa chake, zinthu zofunika zija zidzafotokozedwa.
- Kusankhidwa kwapangidwa, tili odziwika kale kwa ife. Pitani ku tsamba la tabu ". Tadina batani pa tepi ya "Internation", yomwe ili mu "Zida Zamasamba". Kuchokera pamndandanda wotsika, sankhani "zotchinga".
Pambuyo pake, mapepala onse osankhidwa adzakhala ndi zomwe zatchulidwa pamwambapa.
Monga mukuwonera, pali njira zingapo zosinthira buku la bukulo. Njira ziwiri zoyambirira zomwe tafotokozazi zikugwiritsidwa ntchito kusintha magawo a pepala lapano. Kuphatikiza apo, pali njira ina yowonjezera yomwe imakupatsani mwayi kuti musinthe ma sheet angapo nthawi imodzi.