Khazikitsani ndi kukonza malo osindikizira mu Excel

Gawo lomaliza polemba zolemba za Excel nthawi zambiri ndikuzitumiza kwa osindikiza. Pamene muyenera kusindikiza deta yonse pa pepala, nthawi zambiri palibe mavuto ndi izi. Koma choti tichite pamene tikuchita ndi tebulo lalikulu, ndipo mbali yake yokha ndiyofunika kusindikizidwa.

Mutha kusintha malo osindikizira mu Excel m'njira zosiyanasiyana:

• khalani nthawi iliyonse chikalata chitumizidwa kwa chosindikizira;
• konzani malo enieni m'makonzedwe a zolemba.

Tiyeni tiwone njira zonsezi ndikuwona momwe zimagwiritsidwira ntchito mu pulogalamuyi.

Njira 1: Sinthani malo nthawi iliyonse musanasindikize

Njirayi ndi yoyenera ngati tikufuna kusindikiza chikalata kamodzi kokha, kotero palibe chifukwa chokonzekera madera ena amtsogolo. Komabe, ngati titasankha kusindikiza chikalata chomwechi, zokonda ziyenera kuchitidwanso.

Algorithm ya zochita ndi izi:

1. Munjira iliyonse yabwino (mwachitsanzo, pogwiritsa ntchito batani lakumanzere lokanikiza), sankhani ma cell angapo omwe tikufuna kutumiza kuti asindikize. Tiyerekeze kuti tikufunika kusindikiza malonda okhawo oyamba ndi achiwiri. Pambuyo kusankha, dinani pa menyu "Fayilo".
2. Pamndandanda womwe uli kumanzere, pitani ku gawolo "Chisindikizo". Kumanja kwa zenera, dinani pazosindikiza zomwe zilipo (zomwe zili pansi pa dzina la block "Parameters").
3. Mndandanda wazomwe mungasindikize utsegulidwa:
   • mapepala ogwira ntchito;
   • bukhu lonse;
   • chidutswa chosankhidwa (tichifuna).
4. Zotsatira zake, gawo lokha la tebulo lomwe lasankhidwa ndi ife lidzawonetsedwa m'malo owoneratu zolemba, zomwe zikutanthauza kuti batani likakanikiza. "Chisindikizo" mfundo zimenezi zokha zidzasindikizidwa papepala.

Njira 2: Konzani Malo Osindikiza Nthawi Zonse

Pamene ntchito ndi chikalata ikuchitika mosalekeza kapena nthawi ndi nthawi (kuphatikizapo kutumiza izo kusindikiza), ndi bwino kukhazikitsa nthawi zonse kusindikiza dera. Nazi zomwe timachita pa izi:

1. Monga njira yoyamba, choyamba sankhani malo omwe mukufuna ma cell. Kenako sinthani ku tabu "Kupanga tsamba"kumene ife dinani batani “Print area” m'bokosi la zida "Makonda atsamba". Dongosololi lidzatipatsa zosankha ziwiri: kukhazikitsa ndi kuchotsa. Timayima pa yoyamba.
2. Choncho, tinatha kukonza malo a maselo, omwe amasindikizidwa nthawi zonse mpaka titasankha kusintha. Mutha kuyang'ana izi m'malo owoneratu pazosankha zosindikiza (menu "Fayilo" - gawo "Chisindikizo").
3. Zimangotsala kuti musunge zosintha mu chikalatacho podina batani loyenera pa menyu "Fayilo" kapena podina chizindikiro cha floppy disk pakona yakumanzere kwa pulogalamuyo.

Kuchotsa phini pa malo osindikizika

Tiyerekeze kuti tikufunika kusintha malo osindikizira okhazikika kapena kuwachotsa palimodzi. Kuti muchite izi, bwererani ku tabu "Kupanga tsamba" muzosankha zomwe zimatsegulidwa mukangodina batani “Print area” sankhani nthawi ino "Chotsani". Pamenepa, sikuli kofunikira kuti musankhiretu ma cell amtundu uliwonse patebulo.

Timabwereranso ku zoikamo zosindikizira ndikuonetsetsa kuti zabwereranso ku zoyambazo.

Kutsiliza

Chifukwa chake, palibe chovuta pakukhazikitsa malo osindikizira mu Excel, ndipo njirayi idzangotenga mphindi zingapo ndikudina kuti kumalize. Pa nthawi imodzimodziyo, ngati tikukonzekera kugwira ntchito nthawi zonse ndi chikalatacho ndikuchisindikiza, tikhoza kukonza malo enieni omwe adzatumizidwa kuti asindikize nthawi zonse, ndipo sitidzasowanso nthawi yochita izi m'tsogolomu.