Momwe mungayikitsire malo mu Excel. Kusindikiza malo mu Excel ndikuchotsa

Microsoft Office Excel nthawi zambiri imapanga matebulo okhala ndi zidziwitso zambiri zomwe zimakhala zovuta kuti zigwirizane ndi tsamba limodzi. Chifukwa cha izi, zimakhala zovuta kuti wogwiritsa ntchito afanizire deta yomwe ili kumapeto kwa chikalatacho, ndipo zimatengera nthawi yochuluka kuti mufufuze patebulo kuti mupeze zofunikira. Kuti mupewe vuto loterolo, madera ofunikira mu Excel amatha kukhazikitsidwa nthawi zonse, kukhazikika mu gawo lowoneka la chikalatacho, kuti wogwiritsa ntchito azitha kupeza mwachangu chidziwitso chomwe amamukonda. Nkhaniyi ifotokoza njira zokhomerera ndikuchotsa madera mu Excel.

Momwe mungapachike madera

Pali njira zingapo zogwirizira ntchitoyi, iliyonse yomwe ili yogwirizana ndi pulogalamu inayake. Ndondomeko yamitundu yosiyanasiyana ya Microsoft Excel idzasiyana pang'ono. Mwambiri, njira yokonza madera ofunikira mu pulogalamu yomwe ikuganiziridwa imagawidwa m'njira zotsatirazi:

• Sankhani selo loyamba patebulo. Selo iyi iyenera kukhala pansi pa malo omwe mukufuna kusindikiza mu gawo lowoneka la zenera. Kuphatikiza apo, zomwe zili pamwambapa ndi kumanzere kwa zomwe zasankhidwa zidzakhazikitsidwa ndi pulogalamuyo.

• Mukamaliza kuwongolera koyambirira, muyenera kusinthana ndi tabu "Onani". Ili m'gawo lazosankha pamwamba pa mawonekedwe a Excel.

• Kenako, mumzere wotsegulidwa wamakhalidwe, muyenera dinani LMB pa batani la "Window" kamodzi.
• Zida zingapo zidzawonetsedwa, zomwe muyenera kudina chizindikiro cha "Freeze panes". Pa zowunikira zazikulu zokhala ndi mawonekedwe apamwamba, gawo la View nthawi yomweyo limawonetsa zosankha za pinning. Iwo. Simuyenera kudina batani la Window.

• Onetsetsani kuti malo omwe mwasankha kale akhazikika pamasamba. Tsopano zonse zomwe zinali pamwamba ndi kumanzere kwa selo zidzawonetsedwa patebulo pamene mukupita pansi, ndipo sizidzawoneka.

• Wogwiritsa ntchito amathanso kubaniza ma cell onse omwe ali pamwamba pa mzere womwe wasankhidwa. Kuti achite izi, afunika kusankha selo lomwe mukufuna pakati pa tebulo, ndiyeno momwemonso kupita ku tabu "Onani", pomwe dinani batani la "Freeze areas". Njira yokonzera iyi ndiyofunika kwambiri pamene munthu akufunika kukonza mutu wa tebulo papepala lililonse.

Tcherani khutu! Kuti mukonze zambiri zomwe zili kumanzere kwa selo losankhidwa, muyenera kusankha chinthu chapamwamba cha mzere womwe uli kumanja kwa malo omwe mukufuna, ndiyeno chitani chimodzimodzi.

Momwe zigawo zimasunidwira

Ogwiritsa ntchito osadziwa a Microsoft Office Excel sadziwa momwe angatulutsire malo otsekedwa kale. Chilichonse ndi chophweka apa, chinthu chachikulu ndikutsata malingaliro ena:

1. Tsegulani chikalata cha Excel. Pambuyo pakuwonekera kwa gawo logwira ntchito mu mbale, simuyenera kusankha maselo aliwonse.
2. Pitani ku "View" tabu mu options riboni pamwamba pa pulogalamu zenera.
3. Tsopano muyenera dinani batani la "Window" kuti mutsegule kagawo kokhala ndi zolembera.
4. LMB dinani pa mawu akuti "Chotsani zigawo".
5. Yang'anani zotsatira poyenda pansi pa tebulo. Kukonzekera kwa maselo osankhidwa kale kuyenera kuthetsedwa.

Zina Zowonjezera! Kuchotsa madera mu Excel kumachitika ndendende motsatana poyerekeza ndi kukonza.

Momwe mungawunikire malo kuchokera pamizati

Nthawi zina mu Excel muyenera kuzizira osati mizere, koma mizere. Kuti muthane ndi ntchitoyi mwachangu, mutha kugwiritsa ntchito algorithm iyi:

• Sankhani pamizati yomwe ikufunika kukhazikitsidwa, fufuzani manambala awo, omwe amalembedwa pamwamba pa mndandanda wa zilembo A, B, C, D, ndi zina zotero.
• Gwiritsani ntchito batani lakumanzere la mbewa kuti musankhe ndime yomwe ikutsatira mtundu womwe mwasankha. Mwachitsanzo, ngati mukufuna kukonza mizati A ndi B, muyenera kusankha ndime C.

• Kenako, muyenera kupitanso ku tabu ya "View" ndikudina batani la "Freeze Area" kuti mukonze mizati yomwe mukufuna patsamba lililonse.

• Pawindo la mtundu wa nkhaniyo, muyenera kusankha njira yoyamba yokonza mizere ndi mizati ya matebulo.
• Onani zotsatira. Pamapeto pake, muyenera kupukuta chikalatacho ndikuwonetsetsa kuti malo omwe mwasankhidwa sakutha pamasamba, mwachitsanzo, ophatikizidwa.

Kutsiliza

Chida chokonzekera madera mu Excel chimapulumutsa nthawi kwa ogwiritsa ntchito omwe amagwira ntchito zambiri. Chinthu chosindikizidwa chidzawonekera nthawi zonse pa tsamba lothandizira pamene mukuchipukuta. Kuti muyambitse ntchitoyi mwachangu, muyenera kuwerenga mosamala zomwe zili pamwambapa.