Mukamagwira ntchito ndi matebulo otalika omwe sanayikidwe pazenera komanso kukhala ndi mizati yambiri, kufunika kopukusa chophimba kuti atulutse mzere wapamwamba ndi mituyo idzachitika nthawi ndi nthawi. Kuti mumveke bwino pulogalamu ya Excel, ndizotheka kukonza zipilala pamwamba pazenera kwa nthawi yonse mpaka fayilo itatsegulidwa. Pansipa pali njira zokwaniritsira izi.
Ndikofunikira kuteteza chingwe chimodzi chokha.
- Panjira yapamwamba ya pulogalamuyi, muyenera kupita ku "Onani" tabu.
- Mu gawo la "zenera" (mayina ogawana amalembedwa pansi pamzere wa tepi) kuti mupeze chinthucho "cholumikizira m'deralo" ndikudina pa atatu mbali yake yabwino.
- M'ndandanda womwe umatsegula, sankhani "chitetezo cham'mwamba" pokakamiza batani lakumanzere. Zotsatira zake zidzakhala kupezeka kwamuyaya pazenera la chingwe, kupulumutsidwa ndikutseka fayilo.
Kukonza mizere ingapo
Ngati mizere ingapo imafunikira, ndiye kuti kachitidwe ndi kosiyana:- Pakuyenda kumanzere kwa tebulo, dinani khungu la chingwe choyambirira chomwe sichiri gawo la kapu. Pankhaniyi, ili ndi khungu la A3.
- Pitani ku "View" tabu, dinani pa "kukonza" ndi mndandanda wazomwe mungasankhe zomwe zawonetsedwa kuti ziwonekere kuti "muitole m'deralo". Zotsatira zake, mizere yonse yomwe ili pamwamba pa yomwe ili ndi foni yomwe yasankhidwa imajambulidwa pamwamba pa zenera.
"Wanzeru" - Njira ina yolumikizira chipewa
Yemwe amadziwa bwino matebulo anzeru omwe angathe kugwiritsa ntchito njira ina yothandiza yogogowika. Zowona, kusankha kumeneku kumagwiritsidwa ntchito pokhapokha ngati chipewa cha mzere umodzi.
- Pa ritibobon tabu "kunyumba" ikuwonetsa tebulo lonse.
- Gawo la "masitaelo" (pamzere pansi pa tepi), dinani pamtundu wa "chinthu ngati tebulo". Zenera limatsegulidwa ndi masitayilo a tebulo. Imafunika kudina njira yoyenera kwambiri.
- Khomo la "Kupanga Mawonekedwe" la "Masamba" la "Malire a tebulo lam'tsogolo akuwonetsedwa, ndipo checkbox" ndi mutu "ili. Muyenera kuwonetsetsa kuti izi ndi zomaliza.
- Tsekani zenera ndikukanikiza batani la "OK".
Pangani tebulo lanzeru mwanjira ina:
- Pambuyo posankha malo omwe mukufuna, pitani ku riti ya ritibon ndikudina pa "tebulo".
- Pa mndandanda wa pop-up, dinani pa "tebulo".
- Pambuyo pa mawonekedwe a "Kupanga zenera" patebulo la "kuwonekeranso ndi zithunzi zofanana ndi" mawonekedwe a tebulo ", muyenera kuchita zomwe zikufanana ndi zomwe tafotokozazi. Pomaliza, "tebulo lanzeru" lidzaonekera ndi chipewa pamwamba.
Momwe mungasindikizire tebulo ndi kapu pa tsamba lililonse
Mukasindikiza tebulo lokhala masamba angapo, ndikofunikira kukhala ndi mutu uliwonse patsamba lililonse. Izi zimakuthandizani kuti muzigwira ntchito ndi tsamba lililonse mosiyana. Pa pulogalamu yapamwamba, izi zimaperekedwa ndipo zimakhazikitsidwa motere.
- Pitani ku tabu ya riboni ya Tsamba la Tsamba ndi patsamba la "Tsamba" (m'ndime yapansi) Dinani pazenera ndi muvi kumanja kwa cholembedwacho.
- Mu "masamba a masamba" omwe amatsegulira, pitani ku "pepala" tabu.
- Dinani pa "mizere ya" Tsomba "(yachiwiri pamwambapa).
- Bweretsani patebulopo ndipo, kusunthira cholosera chomwe chidayang'ana pa muvi wakuda kulowa kumanja, pamzere wokhala ndi manambala kapena zingwe zomwe chipewa cha patebulo chimakhala.
- Pa machitidwe onsewa akumalizidwa, komabe, zotsatira zake siziwonetsedwa pazenera.
Pano ndikukanikiza ma piangles pansi pazenera kapena ndikupukutira gudumu la mbewa, pomwe cholembera chimayikidwa patsamba la tebulo, mutha kuwona masamba onse kuti muwone zipewa pa aliyense wa iwo.
chidule
Kupambana, pali njira ziwiri zosonyezera nthawi zonse pagome la tebulo. M'modzi mwa iwo amaphatikizapo kugwiritsa ntchito kumenyedwa kwa derali, lachiwiri ndikusintha tebulo kulowa "anzeru" pogwiritsa ntchito mawonekedwe a malo osankhidwa a kuyikamo. Njira zonsezi zimaloledwa kukonza mzere umodzi, koma kokha koyamba imalola kuti zigwirizane ndi chipewa chomwe chimakhala ndi mizere yambiri. Excel ili ndi mwayi wowonjezera - kuthekera kosindikiza chikalata ndi kapu patsamba lililonse, lomwe, mwachidziwikire, limawonjezera mphamvu yogwira ntchito nazo.
Mauthenga Momwe mungapangire mutu wa tebulo pa Excel. Kukhazikitsa mzere wapamwamba, chipewa chovuta chidawoneka choyamba ku ukadaulo wazomwezi.