Rage girman fayil a Microsoft Excel

Lokacin aiki a cikin Excel, wasu tebur suna da ban sha'awa sosai a girma. Wannan yana haifar da gaskiyar cewa girman daftarin aiki yana ƙaruwa, wani lokacin kai har ma da dozin megabytes ko fiye. Theara nauyi na littafin aiki mai inganci ba kawai zai haifar da hauhawar sararin samaniya da take zaune akan rumbun kwamfutarka ba, amma, mafi mahimmanci, ga rage gudu a cikin sauri na ayyuka daban-daban da matakai a ciki. A sauƙaƙe, lokacin aiki tare da irin wannan takaddun, Excel ya fara rage gudu. Don haka, batun ingantawa da rage girman irin waɗannan littattafai ya zama ya dace. Bari mu ga yadda za a rage girman fayil ɗin a Excel.

Tsarin Rage Girman Littafin

Yakamata ka inganta babban fayil sama sau daya a lokaci daya. Yawancin masu amfani ba su da masaniya, amma sau da yawa littafin aikin Excel ya ƙunshi bayanai da yawa marasa amfani. Lokacin da fayil ɗin ƙarami ne, babu wanda ke kulawa da shi sosai, amma idan takaddar ta zama ƙato, kuna buƙatar inganta shi bisa ga dukkan sigogi mai yiwuwa.

Hanyar 1: rage yawan aiki

Yankin aiki shine yankin da Excel ke tuna ayyukan. Lokacin da aka sake karanta wata takarda, shirin zai tarar da dukkanin ƙwayoyin da ke cikin aikin. Amma koyaushe bai dace da kewayon abin da mai amfani yake aiki da gaske ba. Misali, sararin samaniya da ba a sani ba nesa da tebur zai fadada girman kewayon aikin zuwa kashi inda wannan fili yake. Sai dai itace cewa Excel a duk lokacin da zai sake aiwatar da wani tsari na tarin kwayoyin halitta. Bari mu ga yadda za a gyara wannan matsalar ta amfani da misalin takamaiman tebur.

1. Da farko, bincika nauyinta kafin ingantawa don kwatanta abin da zai kasance bayan hanyar. Ana iya yin wannan ta motsawa zuwa shafin Fayiloli. Je zuwa sashin "Cikakkun bayanai". A hannun dama na taga wanda zai buɗe, an nuna manyan abubuwan mallakar littafin. Abubuwan farko na kaddarorin sune girman daftarin aiki. Kamar yadda kake gani, a cikin yanayin namu shine kilo 56.5.



2. Da farko dai, yakamata ku gano nawa yankin aiki na gaskiya ya bambanta da wanda mai amfani yake buƙata sosai. Wannan abu ne mai sauki. Mun shiga cikin kowane tantanin tebur kuma mun haɗa haɗin maɓalli Ctrl + .arshe. Excel nan da nan yana motsawa zuwa sel na ƙarshe, wanda shirin yayi la'akari da kashi na ƙarshe na filin aiki. Kamar yadda kake gani, a cikin yanayinmu na musamman, wannan shine layi 913383. Ganin cewa teburin zahiri ya ƙunshi layuka shida na farko, zamu iya faɗi gaskiyar cewa layin 913377 sune, a zahiri, kaya mara amfani, wanda ba kawai yana ƙara girman fayil ɗin ba, amma, saboda yawan aiwatar da ɗaukacin fanni ta hanyar shirin yayin aiwatar da kowane irin aiki, rage aiki a kan takaddar.

   

   Tabbas, a zahiri, irin wannan babban banbanci tsakanin ainihin aiki da wanda Excel yake ɗauka yana da ɗan wahalar gaske, kuma mun dauki yawancin adadin layin don fito fili. Kodayake, wasu lokuta akwai lokuta har ma lokacin da yankin ke aiki shine duk yankin takardar.

3. Don gyara wannan matsalar, kuna buƙatar share duk layin, daga wofi na farko har zuwa ƙarshen ƙarshen takaddar. Don yin wannan, zaɓi tantanin farko, wanda yake a ƙarƙashin tebur nan da nan, kuma buga a hade haɗin maɓallin Ctrl + Shift + Girman Arrow.



4. Kamar yadda kake gani, bayan wannan an zaɓi dukkan abubuwan farkon layin farko, farawa daga ƙayyadadden tantanin halitta zuwa ƙarshen teburin. Sannan danna kan abinda ke ciki tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da zai buɗe, zaɓi Share.

   

   Yawancin masu amfani suna ƙoƙarin sharewa ta danna maɓallin. Share a kan maballin, amma ba daidai bane. Wannan aikin yana share abubuwan da ke cikin sel, amma bai share su da kansu ba. Sabili da haka, a cikin yanayinmu, ba zai taimaka ba.

5. Bayan mun zabi abun "Share ..." a cikin menu na mahallin, ƙaramin taga don share sel yana buɗe. Mun sanya canjin a cikin sa "Layi" kuma danna maballin "Ok".



6. Duk share layuka na zaɓaɓɓen da aka zaɓa an share su. Tabbatar sake ajiye littafin ta danna maɓallin diskette a saman kusurwar hagu na taga.



7. Yanzu bari mu ga yadda wannan ya taimaka mana. Zaɓi kowane tantanin halitta a tebur kuma rubuta gajerar hanya Ctrl + .arshe. Kamar yadda kake gani, Excel ya zaɓi satin ƙarshe na teburin, wanda ke nufin cewa yanzu shine ainihin abu na aiki na takardar.



8. Yanzu koma zuwa sashin "Cikakkun bayanai" shafuka Fayilolidon gano yadda aka rage nauyin rubutunmu. Kamar yadda kake gani, yanzu shine 32.5 KB. Ka tuna cewa kafin aikin ingantawa, girmansa yakai 56.5 Kb. Don haka, ya rage fiye da sau 1.7. Amma a wannan yanayin, babban nasarar ba ma rage nauyin fayil ɗin ba, amma cewa yanzu an dakatar da shirin daga sake dawo da iyaka wanda ba a amfani da shi, wanda zai haɓaka saurin sarrafa takaddar.

Idan littafin yana da wasu zanen gado wanda kuke aiki da shi, kuna buƙatar aiwatar da irin wannan tsarin tare da kowane ɗayansu. Wannan zai kara rage girman daftarin aiki.

Hanyar 2: Rage Tsara Tsarin

Wani muhimmin mahimmanci wanda ke sa takaddar Excel ta fi wahala shi ne tsarawa. Wannan na iya haɗawa da amfani da nau'ikan fonts daban-daban, iyakoki, tsari mai lamba, amma da farko ya shafi cika sel da launuka daban-daban. Don haka kafin a bugu da formatari yana tsara fayil ɗin, kuna buƙatar yin tunani sau biyu ko yana da ƙimar gaske ko kuma kuna iya sauƙaƙe ba tare da wannan hanyar ba.

Gaskiya ne don littattafan da ke ƙunshe da ɗimbin bayanai, waɗanda a cikin su sun riga sun sami babban adadin. Dingara tsarawa zuwa littafi na iya ƙaruwa da nauyi koda sau da yawa. Sabili da haka, kuna buƙatar zaɓar tsakiyar tsakani tsakanin gani na gabatar da bayani a cikin takaddar da girman fayil ɗin, sanya tsarin ƙira kawai inda ake buƙatarta sosai.

Wani batun kuma da aka danganta shi da tsara kayan rubutu shine cewa wasu masu amfani sunfi son cika sel. Wannan shine, suna tsara ba kawai tebur kanta ba, har ma da kewayon da ke ƙarƙashinsa, wani lokacin har zuwa ƙarshen takardar, tare da tsammanin cewa lokacin da aka ƙara sabon layuka a teburin, bazai zama tilas a sake tsara su kowane lokaci ba.

Amma ba a san daidai lokacin da za a ƙara sababbin layin da kuma nawa za a ƙara ba, kuma tare da irin wannan tsarin farawa za ku sa fayil ɗin ya fi ƙarfin a yanzu, wanda kuma hakan ba zai rasa nasaba da saurin aiki tare da wannan takaddar ba. Sabili da haka, idan kunyi amfani da tsara tsararru ga fatattakan sel waɗanda ba a cikin teburin ba, to, dole ne a cire shi.

1. Da farko dai, kuna buƙatar zaɓar duk ƙwayoyin da ke ƙasa da kewayon tare da bayanai. Don yin wannan, danna kan lambar layin farko na layin tsaye a cikin kwamitin daidaitawa na tsaye. An fifita layin gaba daya. Bayan haka, muna amfani da haɗin kayan abinci na gama gari da muka saba Ctrl + Shift + Girman Arrow.



2. Bayan haka, za a fifita duk kewayon layuka da ke ƙasa da ɓangaren tebur da ke cike da bayanai. Kasancewa a cikin shafin "Gida" danna alamar "A share"wacce take akan kintinkiri a cikin akwatin kayan aiki "Gyara". Smallaramin menu yana buɗe. Zabi wani matsayi a ciki "A share fasali".



3. Bayan wannan matakin, za'a share Tsarin a duk ƙwayoyin da aka zaɓa.



4. Ta wannan hanyar, zaka iya cire tsarin da ba dole ba a cikin teburin kanta. Don yin wannan, zaɓi ƙwayoyin sel guda ko kewayon da muke la'akari da tsara abubuwa don zama da ƙima kaɗan, danna maɓallin "A share" a kan kintinkiri kuma daga lissafin, zaɓi "A share fasali".



5. Kamar yadda kake gani, an cire tsari a cikin yankin da aka zaɓa gaba ɗaya na tebur gaba daya.



6. Bayan haka, za mu koma wannan fanni wasu abubuwan tsarawa waɗanda muke ganin sun dace: kan iyakoki, tsari na lamba, da sauransu.

Matakan da ke sama zasu taimaka sosai rage girman littafin aikin Excel da hanzarta aikin a ciki. Amma ya fi kyau da farko a yi amfani da tsari kawai inda ya dace da gaske kuma ya cancanta fiye da ɓata lokaci daga baya akan inganta takaddar.

Darasi: Tsarin allunan a Excel

Hanyar 3: share hanyoyin

Wasu takardu suna da adadi mai yawa na hanyoyin sadarwa daga inda aka jawo dabi'un. Wannan na iya saurin rage saurin aiki a cikin su. Hanyoyin haɗin yanar gizo na waje zuwa wasu littattafai suna da tasiri musamman a cikin wannan wasan kwaikwayon, kodayake hanyoyin haɗin ciki na ciki suna cutar mummunan aiki. Idan tushen daga inda hanyar haɗi ke ɗaukar bayanan ba a sabunta shi koyaushe, wannan, yana da ma'ana don maye gurbin adiresoshin hanyar haɗin yanar gizon tare da dabi'un talakawa. Wannan na iya ƙara saurin aiki tare da daftarin aiki. Kuna iya gani idan haɗin haɗin ko ƙimar yana cikin takamaiman sel a cikin masarar dabara bayan zaɓin kashi.

1. Zaɓi yankin da hanyoyin haɗin ke ciki. Kasancewa a cikin shafin "Gida"danna maballin Kwafa wanda yake a kan kintinkiri a cikin rukunin saiti Clipboard.

   

   Madadin, bayan nuna alama, zaku iya amfani da kayan haɗin hotkey Ctrl + C

2. Bayan an kwafa bayanan, ba mu cire zaɓi daga yankin ba, amma danna kan shi tare da maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. A ciki a toshe Saka Zabi buƙatar danna kan gunkin "Dabi'u". Yana da nau'in gumaka tare da lambobin da aka nuna.



3. Bayan haka, duk hanyoyin haɗin da aka zaɓa a cikin yankin da aka zaɓa za a maye gurbinsu da ƙididdiga.

Amma ka tuna cewa wannan zaɓi na ingantawa na aikin aikin Excel ba koyaushe ne ake yarda da shi ba. Ana iya amfani dashi kawai lokacin da bayanai daga asalin asali ba masu ƙarfi bane, wannan shine, baza su canza tare da lokaci ba.

Hanyar 4: canje-canje tsari

Wata hanyar don rage girman fayil ita ce canza tsari. Wannan hanyar tabbas yana taimakawa fiye da kowa don damfara littafin, dukda cewa yakamata a yi amfani da zaɓuɓɓukan da ke sama a haɗuwa.

A cikin Excel akwai nau'ikan fayil ɗin '' ɗan ƙasa '- xls, xlsx, xlsm, xlsb. Tsarin xls ya kasance farkon fadadawa ga nau'ikan shirin Excel 2003 da kuma a baya. Ya riga ya ɓace, amma duk da haka, yawancin masu amfani suna ci gaba da amfani dashi. Bugu da kari, akwai wasu lokuta da yakamata ku koma ga aiki tare da tsoffin fayiloli wadanda aka kirkiresu shekaru da yawa da suka gabata baya lokacin da babu tsarin zamani. Ba tare da ambaton gaskiyar cewa yawancin shirye-shirye na ɓangare na uku waɗanda ba su san yadda ake aiwatar da su ba a baya na takardun Excel suna aiki tare da littattafai tare da wannan ƙarin.

Ya kamata a lura cewa littafi tare da xls fadada yana da girma fiye da yadda yake analog na zamani na tsarin xlsx, wanda a halin yanzu Excel yake amfani dashi a matsayin babba. Da farko dai, wannan ya faru ne saboda gaskiyar cewa fayilolin xlsx, a zahiri, sune wuraren tattara bayanan tarihin. Sabili da haka, idan kuna amfani da tsawo na xls, amma kuna son rage nauyin littafin, zaku iya yin wannan ta hanyar sake adana shi a cikin tsarin xlsx.

1. Don sauya takarda daga tsarin xls zuwa xlsx, tafi zuwa shafin Fayiloli.



2. A cikin taga wanda zai buɗe, nan da nan ku mai da hankali ga ɓangaren "Cikakkun bayanai", inda aka nuna cewa takaddun yanzu nauyin 40 Kbytes ne. Bayan haka, danna kan sunan "Ajiye As ...".



3. Wurin ajiyewa yana buɗewa. Idan kuna so, zaku iya canza zuwa sabon shugabanci a ciki, amma ga yawancin masu amfani da shi sun fi dacewa don adana sabon takaddun a wuri guda da asalin. Za a iya canza sunan littafin, in ana so, a fagen "sunan fayil", kodayake ba lallai bane. Mafi mahimmanci a cikin wannan hanyar ita ce saita a fagen Nau'in fayil darajar "Madalla aikin littafi (.xlsx)". Bayan haka, zaku iya latsa maɓallin "Ok" a kasan taga.



4. Bayan an gama ceton, bari mu shiga ɓangaren "Cikakkun bayanai" shafuka Fayilolidon ganin nawa nauyi ya ragu. Kamar yadda kake gani, yanzu 13.5 KB a kan 40 KB kafin aiwatarwar juyi. Wato, kawai adana shi a cikin wani tsari na zamani ya sa ya yiwu a damfara littafin sau uku.

Bugu da kari, a cikin Excel akwai wani sabon tsari na zamani xlsb ko littafin binary. A ciki, an adana takaddun a cikin bayanan binary. Wadannan fayiloli suna yin nauyi har ƙasa da littattafai a tsarin xlsx. Bugu da kari, yaren da ake rubuta su, ya fi kusanci da Excel. Sabili da haka, yana aiki tare da irin waɗannan littattafan da sauri fiye da kowane ɗauka. A lokaci guda, littafin tsarin da aka ƙayyade dangane da aiki da kuma damar yin amfani da kayan aikin daban-daban (Tsarin hoto, ayyuka, zane, da sauransu) ba shi da ƙima ga tsarin xlsx kuma ya zarce tsarin xls.

Babban dalilin da ya sa xlsb bai zama tsarin tsoho a cikin Excel shi ne cewa shirye-shirye na ɓangare na uku ba zai iya aiki da shi ba. Misali, idan kana bukatar fitar da bayanai daga Excel zuwa 1C, ana iya yin hakan tare da dokin xlsx ko xls, amma ba tare da xlsb ba. Amma, idan ba ku shirya canja wurin bayanai zuwa kowane shiri na ɓangare na uku ba, to, kuna iya ajiye adana lafiya cikin tsarin xlsb. Wannan zai ba ku damar rage girman daftarin aiki da ƙara saurin aiki a ciki.

Hanya don adana fayil a cikin xlsb tsawo yana kama da wanda muka yi don faxita xlsx. A cikin shafin Fayiloli danna kan kayan "Ajiye As ...". A cikin taga wanda yake buɗe, a fagen Nau'in fayil buƙatar zaɓar zaɓi "Mallakar Labarin Binary (* .xlsb)". Saika danna maballin Ajiye.

Mun kalli nauyin daftarin aiki a sashin "Cikakkun bayanai". Kamar yadda kake gani, ya ragu sosai kuma yanzu shine kawai 11.6 KB.

Ta tattara sakamakon gaba daya, zamu iya cewa idan kuna aiki tare da fayel a cikin tsarin xls, to hanya mafi inganci don rage girmanta ita ce adana shi a tsarin xlsx ko xlsb na zamani. Idan kun riga kun yi amfani da bayanan fadada fayil ɗin, to don rage nauyinsu, yakamata ku daidaita wurin aiki, cire tsari mai yawa da hanyoyin haɗin da ba dole ba. Za ku sami mafi girman dawowa idan kun aiwatar da duk waɗannan ayyuka a cikin hadaddun, kuma kada ku iyakance kanku ga zaɓi ɗaya kawai.