Mukasindikiza chikalata cha Excel, nthawi zambiri pamakhala zochitika pomwe tebulo lalikulu silikukwana papepala. Chifukwa chake, chilichonse chomwe chimapitirira malire awa, chosindikizira chimasindikiza pama sheet owonjezera. Koma, nthawi zambiri, izi zimatha kuwongoleredwa ndikungosintha momwe chikalatacho chikuwonekera, chomwe chimayikidwa ndikukhazikika, ndikuwoneka. Tiyeni tiwone momwe angachitire izi pogwiritsa ntchito njira zosiyanasiyana ku Excel.
Phunziro: Momwe mungapangire mawonekedwe a pepala mu Microsoft Mawu
Kufalitsa
Pogwiritsa ntchito Excel, pali njira ziwiri zosinthira zolemba polemba: mawonekedwe ndi mawonekedwe. Choyamba ndi kusakhulupirika. Ndiye kuti, ngati simunapange zojambula zilizonse zomwe zalembedwazi, ndiye kuti mukasindikiza zidzatulukira potengera zojambula. Kusiyana kwakukulu pakati pa mitundu iwiriyi yoyikika ndikuti pakuwonekera kwa tsambalo kutalika kwa tsambalo ndikokulirapo kuposa mulifupi, ndipo kumbali yakuwonekera-mosatsata.
M'malo mwake, makina amomwe amagwiritsira ntchito njira yosinthira tsamba kuchokera pazithunzi kupita ku Excel ndi okhawo, koma akhonza kuyambitsa pogwiritsa ntchito njira zingapo. Nthawi yomweyo, mutha kuyika mtundu wanu wa mtundu uliwonse wa pepalalo. Nthawi yomweyo, mkati mwa pepala limodzi simungasinthe gawo ili pazinthu zake (masamba).
Choyamba, muyenera kudziwa ngati kuli koyenera kusintha chikalatacho konse. Pazifukwa izi, mutha kugwiritsa ntchito chiwonetsero. Kuti muchite izi, pitani ku tabu Fayilokusunthira ku gawo "Sindikizani". Kumanzere kwa zenera kuli chithunzithunzi cha momwe alembedwere, momwe angayang'anire posindikiza. Ngati yagawidwa m'masamba angapo mu ndege zoyenda, izi zikutanthauza kuti tebulo silingafanane ndi pepalalo.
Ngati njirayi itatha titha kubwerera ku tabu "Pofikira" ndiye kuti tiwona mzere wosowa wa kudzipatula. M'malo momwe zigawo zimagawanikana patebulo, uwu ndi umboni wowonjezera kuti posindikiza mizati yonse patsamba limodzi sangathe kuyiyika.
Poganizira izi, ndi bwino kusintha momwe chikalatachi chikuyendera.
Njira 1: makina osindikizira
Nthawi zambiri, ogwiritsa ntchito amatembenukira pazida zomwe zimakhala pazosindikiza kuti zisinthe tsamba.
- Pitani ku tabu Fayilo (m'malo mwake, mu Excel 2007, dinani chizindikiro cha Microsoft Office pakona yakumanzere pazenera).
- Timasunthira ku gawo "Sindikizani".
- Malo omwe tawadziwa kale akutsegulidwa. Koma nthawi ino sadzakhala ndi chidwi. Mu block "Kukhazikitsa" dinani batani "Kutengera mabuku".
- Kuchokera pamndandanda wotsika, sankhani "Zowonekera.
- Zitatha izi, mawonekedwe omwe ali patsamba latsamba lokangalika la Excel asinthidwa kukhala mawonekedwe, omwe amatha kuwoneka pazenera loyang'ana chikalata chosindikizidwa.
Njira 2: Tsamba Yokhazikitsira Tsamba
Pali njira yosavuta yosinthira zolemba. Itha kuchitika tabu Masanjidwe Tsamba.
- Pitani ku tabu Masanjidwe Tsamba. Dinani batani Zochitayomwe ili mgululi Zikhazikiko Tsamba. Kuchokera pamndandanda wotsika, sankhani "Maonekedwe".
- Pambuyo pake, mawonekedwe a pepala lomwe asinthidwa asinthidwa kukhala mawonekedwe.
Njira 3: Sinthani magawo a mapepala angapo nthawi imodzi
Mukamagwiritsa ntchito njira zomwe zili pamwambapa, pali kusintha kwa mawonekedwe pokhapokha pa pepala lapano. Nthawi yomweyo, ndizotheka kuyika chizindikiro ichi pazinthu zingapo nthawi imodzi.
- Ngati ma sheet omwe mukufuna kutsatira zochita zamagulu ali pafupi wina ndi mnzake, ndiye gwiritsani batani Shift pa kiyibodi ndipo, osamasula, dinani njira yaying'ono yoyamba yomwe ili m'munsi kumanzere kwa zenera pamwamba pazenera. Kenako dinani chizindikiro chomaliza. Chifukwa chake, lonse lonse liziwonetsedwa.
Ngati mukufunika kusintha komwe masamba azikhala pamapepala angapo omwe zilembo zawo sizili pafupi ndi inzake, ndiye kuti maalgorithm a zochita ndi osiyana pang'ono. Gwira batani Ctrl pa kiyibodi ndikudina njira yaying'ono iliyonse yomwe mukufuna kuchita ndi batani lakumanzere. Chifukwa chake, zinthu zofunikira zikuwunikidwa.
- Kusankhidwa kukapangidwa, timachita zomwe kale tikuzichita. Pitani ku tabu Masanjidwe Tsamba. Dinani batani pa riboni Zochitaili pagulu lazida Zikhazikiko Tsamba. Kuchokera pamndandanda wotsika, sankhani "Maonekedwe".
Pambuyo pake, ma sheet onse osankhidwa adzakhala ndi mawonekedwe pamwambapa pazinthu.
Monga mukuwonera, pali njira zingapo zosinthira mawonekedwe amawonekedwe kukhala mawonekedwe. Njira ziwiri zoyambirira zomwe tafotokozera zikugwiritsidwa ntchito posintha magawo a pepala lomwe lilipo. Kuphatikiza apo, pali njira inanso yomwe imakuthandizani kuti musinthe pamagetsi angapo nthawi imodzi.
