Momwe mungakhazikitsire ndi kukonza malo osindikizira mu Excel

Nthawi zambiri, mukamaliza kugwira ntchito ndi tebulo ku Excel, muyenera kusindikiza zotsatira zomaliza. Mukafuna chikalata chonse, ndizosavuta kutumiza deta yonse kwa chosindikizira. Komabe, nthawi zina pamakhala zofunikira kusankha magawo ena okha kuti asindikize kuchokera mufayilo yonse. Pankhaniyi, muyenera kugwiritsa ntchito zida zomangidwira pulogalamuyo, ikani zosintha zosakhalitsa kapena zokhazikika zosindikizira zikalata.

Njira Zosinthira Malo Osindikizira mu Excel

Pali njira ziwiri zopangira ndikusintha malo osindikizidwa a Excel spreadsheets:

1. Kukhazikitsa pulogalamu imodzi musanatumize chikalata chosindikizidwa. Pankhaniyi, magawo omwe adalowetsedwa adzabwereranso ku zoyambazo fayiloyo ikangosindikizidwa. Muyenera kubwereza ndondomekoyi musanasindikizenso.
2. Kukonza malo osindikizira nthawi zonse, kotero kuti simuyenera kusinthanso mtsogolo. Komabe, ngati mukufuna kusindikiza matebulo osiyanasiyana okhala ndi madera osiyanasiyana, muyenera kukonzanso pulogalamuyo.

Njira iliyonse idzakambidwa mwatsatanetsatane pansipa.

Kusintha kokhazikika kwa malo osindikizira

Njirayi idzakhala yoyenera ngati matebulo omwe mumagwira nawo ntchito nthawi zonse amayenera kusintha madera osindikizira.

Tcherani khutu! Sitiyenera kuiwala kuti ngati m'tsogolomu muyenera kusindikizanso chikalata choyambirira, zosintha zonse ziyenera kulowetsedwanso.

Ndondomeko:

1. Sankhani maselo onse omwe mukufuna kusindikiza. Izi zitha kuchitika ndi makiyi a kiyibodi (mabatani oyenda) kapena kugwira LMB ndikusuntha mbewa pang'onopang'ono kumalo omwe mukufuna.

2. Mukayika ma cell ofunikira, muyenera kupita ku tabu "Fayilo".
3. Mu menyu yomwe imatsegulidwa, sankhani "Print".
4. Kenako, muyenera kukhazikitsa zosindikiza zamitundu yosankhidwa yamaselo. Pali zinthu zitatu zomwe mungachite: sindikizani buku lonse lantchito, sindikizani mapepala okha, kapena sindikizani zomwe mwasankha. Muyenera kusankha njira yomaliza.
5. Pambuyo pake, gawo lowoneratu la mtundu wosindikizidwa wa chikalatacho lidzawonetsedwa.

Ngati zomwe zikuwonetsedwa zikufanana ndi zomwe zikufunika kusindikizidwa, zimatsalira batani la "Sindikizani" ndikudikirira kusindikiza komaliza kudzera pa chosindikizira. Kusindikiza kukatsirizika, zokonda zidzabwerera ku zoikamo zokhazikika.

Kukonza magawo ofanana a zolemba zonse

Mukafuna kusindikiza malo omwewo patebulo (makope ambiri nthawi zosiyanasiyana kapena kusintha zidziwitso m'maselo osankhidwa), ndikwabwino kukhazikitsa zosintha zosindikiza kuti musasinthe makonda. Kachitidwe:

1. Sankhani ma cell ofunikira patebulo wamba (pogwiritsa ntchito njira iliyonse yabwino).
2. Pitani ku tabu ya "Mapangidwe a Tsamba" pazida zazikulu.
3. Dinani pa "Print Area" njira.
4. Padzakhala njira ziwiri zochitira zina - "Funsani" ndi "Chotsani". Muyenera kusankha yoyamba.

5. Pulogalamuyo idzakonza malo omwe asankhidwa. Idzawonetsedwa nthawi iliyonse wogwiritsa ntchito akapita kugawo losindikiza.

Kuti muwone kulondola kwa data, mutha kuwoneratu kudzera pazokonda zosindikiza. Mutha kusunga magawo osankhidwa podina chizindikiro cha floppy disk pakona yakumanzere yakumanzere kapena kudzera pa menyu "Fayilo".

Kukhazikitsa madera ambiri osindikizira

Nthawi zina mumayenera kusindikiza zolemba zingapo kuchokera pamasamba omwewo mu Excel. Kuti muchite izi, muyenera kusintha pang'ono dongosolo la zochita powonjezera gawo limodzi lapakati:

1. Sankhani malo oyamba osindikizira ndi mabatani a mbewa kapena makiyi oyenda pa kiyibodi. Pankhaniyi, ndikofunikira kugwira batani "CTRL".
2. Popanda kutulutsa batani la "CTRL", sankhani madera otsala omwe mukufuna kusindikiza.
3. Pitani ku tabu "Mapangidwe a Tsamba".
4. Kuchokera pagulu la Kukhazikitsa Tsamba, sankhani chida cha Print Area.
5. Zimangowonjezeranso mizere yomwe yalembedwa kale, monga tafotokozera pamwambapa.

Zofunika! Musanayambe kusindikiza madera angapo a tebulo, muyenera kuganizira kuti aliyense wa iwo adzasindikizidwa pa pepala osiyana. Izi ndichifukwa choti kusindikiza limodzi papepala limodzi, mizere iyenera kukhala yoyandikana.

Kuonjezera Selo ku Malo Okhazikitsidwa

Chinthu chinanso chotheka ndikuwonjezera selo loyandikana ndi malo osankhidwa kale. Kuti muchite izi, palibe chifukwa chosinthira zoikamo ndikusintha kukhala zatsopano.. Mutha kuwonjezera selo yatsopano pomwe mukusunga mtundu womwe wakhazikitsidwa kale. Ndondomeko:

1. Sankhani ma cell oyandikana kuti awonjezedwe kugulu lomwe lilipo.
2. Pitani ku tabu "Mapangidwe a Tsamba".
3. Kuchokera pagawo la "Page Options", sankhani ntchito ya "Print Area".

Kuphatikiza pazosankha zokhazikika, wogwiritsa ntchito adzapatsidwa chochita chatsopano "Onjezani kudera losindikizidwa". Iwo atsala fufuzani yomalizidwa chifukwa mwa chithunzithunzi zenera.

Bwezerani

Pamene zolemba zonse zomwe zili ndi mndandanda wofunikira zasindikizidwa kapena muyenera kusintha makonda, muyenera kukonzanso zosintha. Kuti muchite izi, ingopitani ku tabu ya "Mapangidwe a Tsamba", sankhani chida cha "Print Area", dinani batani la "Chotsani". Pambuyo pake, mutha kukhazikitsa magawo atsopano molingana ndi malangizo omwe tafotokozawa.

Kutsiliza

Pophunzira njira zomwe tafotokozazi, mutha kusindikiza zikalata zofunika kapena zigawo zake kuchokera ku Excel ndi nthawi yochepa. Ngati tebulo liri lokhazikika, maselo ambiri atsopano sakuwonjezedwa, ndi bwino kuti mukhazikitse nthawi yomweyo mizere yofunikira kuti musindikize kuti muthe kusintha zambiri m'maselo osankhidwa popanda kukonzanso mtsogolo. Ngati chikalatacho chikusintha mosalekeza, zoikamo ziyenera kubwerezedwanso pa chosindikizira chatsopano chilichonse.