Momwe mungachepetse kukula kwa fayilo

Mukamagwira ntchito zopambana, matebulo ena amakwaniritsa kukula kochititsa chidwi. Izi zimatsogolera pakuti kukula kwa chikalatacho kumawonjezeka, nthawi zina ngakhale megabytes ndi zina zambiri. Kuwonjezeka kwa buku la Excel Kumatsogolera ku chiwonjezeke kokha pamalo ake okhala pa hard disk, koma ndikofunikira kwambiri, kusanthula kuthamanga kwa zochita ndi njira zake. Mwachidule, pogwira ntchito ndi chikalata chotere, pulogalamu ya Excel imayamba kuchepa. Chifukwa chake, funso la kukhathamiritsa ndi kuchepetsedwa kwa mabukuwa kumakhala koyenera. Tiyeni tiwone momwe mungachepetse kukula kwa fayilo.

Njira Kukula Kuchepetsa

Sinthani fayilo yobadwa iyenera kukhala mbali zingapo. Ogwiritsa ntchito ambiri sazindikira, koma nthawi zambiri buku la Exaryl lili ndi zambiri zosafunikira. Fayiloyi ikakhala yocheperako pa izi, palibe amene amalabadira izi mwapadera, koma ngati chikalatacho chakhala chovuta, ndikofunikira kuti mukonzekere magawo onse.

Njira 1: Kuchepetsa ntchito

Mitundu yogwiritsira ntchito ndiderali, zomwe ndimakumbukira za Exp. Ngati chikalatacho chikuwerengera, pulogalamuyi imawerengera maselo onse a malo ogwirira ntchito. Koma sizimagwirizana ndi mitundu yomwe wogwiritsa ntchito amagwira ntchito. Mwachitsanzo, kusiyana kosayenera kutali ndi tebulo kudzakulitsa kukula kwa malo ogwiritsira ntchito ku chinthu kumeneku komwe kumapezeka. Zimapezeka kuti ku Excall poyambiranso nthawi iliyonse ukagwira mulu wa maselo osowa. Tiyeni tiwone momwe vutoli lingathe kuchotsedwedwa pa tebulo linalake.

1. Poyamba, yang'anani kunenepa kapena kufanizira zomwe zingachitike pambuyo pochita. Izi zitha kuchitika posunthira ku "fayilo" tabu. Pitani ku "Zambiri". Kumbali yakumanja kwa zenera lomwe limatsegula zofunikira za bukuli. Zoyambirira ndizofanana ndi chikalatacho. Monga tikuonera, monga tanena kuti ndi 56.5 kilobytes.



2. Choyamba, ziyenera kupezeka momwe malo enieni enieni amakhala osiyana ndi omwe amafunikira kwenikweni ndi wogwiritsa ntchito. Ndiosavuta kuchita izi. Timakhala mu khungu lililonse la tebulo ndikuyimira CTRL + yomaliza. Excel nthawi yomweyo imasunthira ku khungu lomaliza, yomwe pulogalamuyo imaganizira gawo lomaliza la malo ogwirira ntchito. Monga mukuwonera, makamaka, mlandu wathu ndi mzere 913383. Popeza kuti matebulo amapeza mfundo zisanu ndi zisanu zokha, ndizotheka kunena kuti mizere ya 913377 ilipo, yomwe siyikukulitsa kukula kwa fayilo , koma chifukwa chobwezeretsanso ndalama zonse za pulogalamuyo mukamachita chilichonse chimabweretsa kuchepa kwa chikalatacho.

   

   Zachidziwikire, kupezeka kwenikweni, kusiyana kwakukulu kotere pakati pa ntchito zenizeni komanso kuti Excel imavomereza, ndipo tidatenga mizere yayikulu ngati imeneyi. Ngakhale, nthawi zina pamakhala milandu yomwe tsamba lonse la tsamba limawonedwa ngati lolemba.

3. Pofuna kuthetsa vutoli, muyenera kuchotsa mizere yonse yoyambira kuchokera kulibe kanthu ndipo mpaka kumapeto kwa pepalalo. Kuti muchite izi, sankhani foni yoyambayo, yomwe ili pansi patebulopo, ndipo lembani ctrl + yosinthira mkaka.



4. Monga tikuwonera, zitatha izi zinthu zonse za mzati woyamba, kuyambira kuchokera ku selo lodziwika ndi kumapeto kwa tebulo lidagawidwa. Kenako dinani batani lamanja la mbewa. Munkhani yankhani yomwe imatsegulidwa, sankhani "chotsani".

   

   Ogwiritsa ntchito ambiri amayesa kufufuta podina batani la Delete pa kiyibodi, koma silolondola. Kuchita uku kumayambiranso zomwe zili m'maselo, koma osachichotsa. Chifukwa chake, kwa ife sizingathandize.

5. Tikasankha "Chotsani ..." Chosankha pazakudya, zenera laling'ono lam'malo limatseguka. Ndakhazikitsa kusinthira ku "chingwe" mkati mwake ndikudina batani la OK.



6. Mizere yonse ya omwe adagawidwa idachotsedwa. Onetsetsani kuti mukuwumitsa bukulo podina chithunzi cha floppy pakona yakumanzere kwa zenera.



7. Tsopano tiwone momwe zidatithandizira. Timagawana khungu lililonse la tebulo ndikulemba ctrl + yomaliza. Monga mukuwonera, Excel adapereka khungu lomaliza la tebulopo, lomwe limatanthawuza kuti tsopano ndi gawo lomaliza la tsamba la masamba.



8. Tsopano tikusamukira ku "tsatanetsatane" wa "fayilo" tabu kuti mudziwe kuchuluka kwa kuchuluka kwa chikalata chathu chachepa. Monga mukuwonera, muno tsopano ndi 32.5 KB. Kumbukirani kuti njira ya kutsanzira, kukula kwake kunali 56.5 KB. Chifukwa chake, idachepetsedwa ndi nthawi zopitilira 1.7. Koma pankhaniyi, kukwaniritsidwa kwakukulu sikuchepetsa kulemera kwa fayiloyo, ndipo kuti pulogalamuyi tsopano isasulidwe ku Retulcortung Mitundu yosagwiritsidwa ntchito, yomwe ingakulitse kuchuluka kwa chikalatacho.

Ngati buku la mapepala angapo mumagwira ntchito, muyenera kuchita chimodzimodzi ndi aliyense wa iwo. Izi zimachepetsanso kukula kwa chikalatacho.

Njira 2: Kuchotsa mawonekedwe osakhalitsa

Chinthu china chofunikira chomwe chimapangitsa chikalata cha Excel ndi cholemera, chimakhala chosakanikirana. Izi zimaphatikizapo kugwiritsa ntchito mitundu yosiyanasiyana ya mafontis, malire, mitundu yambiri, koma poyamba imakhudza kuthira kwamaselo mumitundu yosiyanasiyana. Chifukwa chake tisanayambe kupanga fayilo, muyenera kuganizira kawiri, komanso ngati pakufunika kuchita kapena popanda njirayi ndikosavuta kuchita.

Izi zili choncho makamaka m'mabuku omwe ali ndi chidziwitso chochuluka omwe amakhala kale ndi kukula kwambiri. Kuphatikiza kwa bukuli kumatha kukulitsa kulemera kwake ngakhale kangapo. Chifukwa chake, muyenera kusankha "golide" pakati pa mawonekedwe a mawonekedwe owonetsa zambiri mu chikalatacho ndi kukula kwa fayilo, kugwiritsa ntchito mafayilo pokhapokha ndikofunikira kwenikweni.

Chinthu china chokhudzana ndi mawonekedwe, kulemera kolemetsa, ndikuti ogwiritsa ntchito ena amakonda kupanga ma cell "ndi malire." Ndiye kuti, samangopanga tebulo lokha, komanso mtundu womwe uli pansi pake, nthawi zina mpaka kumapeto kwa pepalalo, ndikuwerengera kuti mizere yatsopano ikawonjezeredwa pagome, sizikhala zofunika kuzisintha nthawi iliyonse.

Koma sizikudziwika kuti mizere yatsopano iwonjezedwa ndi angati omwe adzawonjezeredwa, ndipo mawonekedwe oyambira omwe mungatenge kale fayilo pompano, zomwe zingakhudze mwachangu komanso kuthamanga kwa chikalatachi. Chifukwa chake, ngati mwafunsira kupanga ma cell osayenera omwe sanaphatikizidwe pagome, iyenera kuchotsedwa.

1. Choyamba, muyenera kuwonetsa maselo onse omwe ali pansi pamtunduwu ndi deta. Kuti muchite izi, dinani nambala ya chingwe chopanda kanthu pa corertical. Adapereka mzere wonse. Pambuyo pake, timagwiritsa ntchito mitundu yodziwika bwino ya makiyi otentha Ctrl + Shift + pansi.



2. Pambuyo pake, mzere wonsewo ndi wotsika kuposa gawo la tebulo lodzaza ndi deta, amadzuka. Kukhala mu "kunyumba" tabu, dinani pa chithunzi cha "chomveka" chomwe chili patsamba mu tepi ya chida chosinthira. Menyu yaying'ono imatseguka. Sankhani "mitundu yowoneka bwino" mkati mwake.



3. Pambuyo pa izi m'maselo onse azomwe adagawidwa, mawonekedwe adzachotsedwa.



4. Momwemonso, mutha kuchotsa mawonekedwe osafunikira patebulo. Kuti muchite izi, sankhani maselo amodzi kapena osiyanasiyana omwe timaganizira kuti ndi othandiza pang'ono, dinani pa batani "chomveka" pa tepi ndikusankha "zomveka" pamndandanda.



5. Monga mukuwonera, mawonekedwe mumitundu yosankhidwa a tebulopo idachotsedwa kwathunthu.



6. Pambuyo pake, timabwezeranso izi zomwe tikuwona zoyenera: Border, mitundu ya nomer, etc.

Zochita zomwe zafotokozedwazi zikuthandizani kwambiri kuchepetsa kuchuluka kwa buku la Excel ndikufulumizitsa ntchitoyo. Koma ndibwino kugwiritsa ntchito mawonekedwe pokhapokha ngati kuli koyenera komanso kofunikira kuposa kuthera nthawi yokonza chikalatacho.

Phunziro: Ma tebuloni aposachedwa

Njira 3: Kuchotsa Maulalo

Mu zikalata zina, maulalo ambiri kuchokera komwe mfundo zimalimbikitsidwa. Izi zitha kuchedwetsa kuthamanga kwa ntchito yawo. Makamaka mwamphamvu kwambiri ndi zonena zakunja ndi mabuku ena, ngakhale mafotokozedwe amkati amawonetsedwanso moyenera. Ngati gwero lichokera komwe kulumikizana kumatenga chidziwitso sikusinthidwa nthawi zonse, ndiye kuti, tanthauzo lolowera ma adilesi m'maselo okhala m'magawo omwe ali pamakhalidwe abwinobwino. Izi zitha kuwonjezera liwiro la kugwira ntchito ndi chikalatacho. Lumikizani kapena mtengo uli mu khungu linalake, mu formula atasankha chinthucho.

1. Sankhani dera lomwe lili ndi zonena. Pokhala mnyumba tabu, dinani batani la "Copy" lomwe lili pa tepi mu gulu lokhazikika la clipboard.

   

   Kapenanso, mukasankha mitundu, mutha kugwiritsa ntchito makiyi otentha Ctrl + C.

2. Pambuyo pa zomwe zalembedwa, musachotse kusankha kuchokera kuderalo, ndikudina batani la mbewa lamanja. Zosankha zamitunduyo zayambitsidwa. Mmenemo, mu "zosintha", muyenera kudina "mfundo". Ili ndi malingaliro a zithunzi zomwe zili ndi manambala omwe akuwonetsedwa.



3. Pambuyo pake, zonena zonsezo m'dera lodzipereka zidzasinthidwa ndi zowerengera.

Koma muyenera kukumbukira kuti njira iyi pokonza buku la Excel silovomerezeka nthawi zonse. Itha kugwiritsidwa ntchito pokhapokha mutakhala ndi gwero loyambirira siliri lamphamvu, ndiye kuti, sasintha ndi nthawi.

Njira 4: Kusintha kwa Fomu

Njira ina yochepetseratu kukula kwa fayilo ndikusintha mtundu wake. Njira iyi, mwina, koposa zonse zimathandizira kufinya bukuli, ngakhale kulinso zofunika kugwiritsa ntchito zomwe mwasankhazi.

Kupambana pali "mitundu" ya fayilo - xls, xlsx, xlsm, xlsb. Fomu ya XLS inali yowonjezera yowonjezera pulogalamu ya pulogalamu ya Excel ya 2013 ndipo koyambirira. Ali munthu watha pantchito, koma, komabe, ogwiritsa ntchito ambiri amangokhalirabe. Kuphatikiza apo, pali zochitika ngati muyenera kubwerera kuntchito ndi mafayilo akale omwe adapanga zaka zambiri zapitazo ngakhale pakalibe mafowo amakono. Osanenanso kuti mapulogalamu ambiri a chipani chachitatu chikugwira ntchito ndi mabuku ndi kufalikira kumeneku, komwe sikukudziwa momwe mungagwiritsire ntchito pambuyo pake zosankha zaposachedwa.

Tiyenera kudziwa kuti XLS yowonjezera bukuli ili ndi kukula kwakukulu kuposa fanizoli la Xlsx, lomwe pakadali pano limagwiritsa ntchito ngati wamkulu. Choyamba, izi zimachitika kuti mafayilo a XSSX ndi osungidwa kale. Chifukwa chake, ngati mugwiritsa ntchito ma XL, koma mukufuna kuchepetsa kulemera kwa bukulo, ndiye kuti izi zitha kungoipitsa mu mtundu wa Xlsx.

1. Kuti musinthe chikalatacho kuchokera ku mtundu wa XLS ku mtundu wa Xlsx, pitani ku tab ya fayilo.



2. Pazenera lomwe ndimatsegula gawo la "tsatanetsatane wa gawo la" tsatanetsatane ", komwe kukusonyeza kuti pakadali pano zolembedwazo ndi 40 KB. Kenako, dinani pa dzinalo "Sungani Monga ...".



3. Windo la Sungani limatseguka. Ngati mukufuna, mutha kupita ku chikwatu chatsopano, koma ogwiritsa ntchito ambiri amakhala osavuta kusunga chikalata chatsopano pamalo omwewo pomwe gwedezani nambala. Dzinalo la Bukhu, ngati lingafune, lingasinthidwe mu gawo la "fayilo", ngakhale sikofunikira. Chofunikira kwambiri panjirayi ndikukhazikitsa "Fayilo" ya "Excel (.xls)" buku. Pambuyo pake, mutha kukanikiza batani la "OK" pansi pazenera.



4. Pambuyo populumutsa ndikupangidwa, pitani ku "tsatanetsatane" wa fayilo ya fayilo kuti muwone kuchuluka kwa kulemera kwachepa. Monga mukuwonera, tsopano ndi 13.5 kobtes motsutsana ndi njira 40 musanatembenukire kutembenuka. Ndiye kuti, chimodzi chopulumutsa mu mtundu wamakono chinatheketsa buku pafupifupi katatu.

Kuphatikiza apo, pali mtundu wina wamakono wa Xlsb kapena buku la binaryb. Mmenemo, chikalatacho chimasungidwa mu binary. Mafayilo amenewa amalemera pang'ono kuposa mabuku amtundu wa Xlsx. Kuphatikiza apo, chilankhulo chomwe chimalembedwa pafupi kwambiri ndi pulogalamu ya Excel. Chifukwa chake, imagwira ntchito ndi mabuku otere kuposa owonjezera ena. Nthawi yomweyo, buku la mtundu wa mtundu womwe ukufotokozedwayo ndi mwayi wogwiritsa ntchito zida zosiyanasiyana (zojambula, zopangira, etc.) sikuti ndi mawonekedwe a Xlx.

Chifukwa chachikulu chomwe Xlsb sichinakhale mtundu wokhazikika pa Excel ndikuti mapulogalamu achipani chachitatucho amatha kugwira nawo ntchito. Mwachitsanzo, ngati mukufuna kutumiza zinthu kuchokera ku Excel mu pulogalamu ya 1C, itha kuchitika ndi xlsx kapena xls zikalata, koma osati ndi xlsb. Koma, ngati simukonzekera kusamutsa deta pa pulogalamu iliyonse ya chipani chachitatu, mutha kusunga bwino chikalatacho mu mtundu wa XLSB. Izi zikuthandizani kuti muchepetse kukula kwa chikalatacho ndikuwonjezera liwiro la ntchito mmenemo.

Njira yosungira fayiloyo mu kufalikira kwa Xlsb ndizofanana ndi zomwe tachitidwa kuti tiwonjezere xlsx. Mu "fayilo" tabu, dinani "Sungani Monga ...". Pazenera lopulumutsa lomwe limatseguka m'munda wa "Fayilo ya fayilo", muyenera kusankha njira ya "Excel Buku (*. Kenako dinani batani la "Sungani".

Timayang'ana kulemera kwa chikalatacho mu gawo la "Zambiri". Monga mukuwonera, zachepa kwambiri ndipo tsopano ndi 11.6 kb zokha.

Pofotokoza zotsatira zazikuluzikulu, titha kunena kuti ngati mukugwira ntchito ndi fayilo ya Xls, ndiye njira yabwino kwambiri yochepetsera kukula kwake ndi mphamvu yolimbikitsira mu xlsx kapena xlsb. Ngati mukugwiritsa ntchito deta yowonjezera ya fayilo, ndiye kuti muchepetse kulemera kwawo, muyenera kusintha bwino malo ogwirira ntchito, chotsani mafuta ochulukirapo komanso maumboni osafunikira. Mudzalandiranso kubwezeredwa kwakukulu ngati mupanga izi mwazomwezi mu zovuta, osadziletsa.