Ukunciphisa ubungakanani befayile ye-Excel

Xa usebenza kwi-Excele, ezinye iitafile zifezekisa ubungakanani obuthathaka. Oku kukhokelela kwinto yokuba ubukhulu boxwebhu luyanda, ngamanye amaxesha nkqu ne-megabytes nangaphezulu. Ukonyuka kobunzima bencwadi ye-Excel kukhokelela kuphela ekunyukeni kwendawo yayo ehlala kwi-hard disk, kodwa okona kubaluleke nangakumbi, ukuze kwenziwe kancinci isantya kunye neenkqubo ezahlukeneyo. Ngamafutshane, xa usebenza noxwebhu olunjalo, inkqubo ye-Excel iqala kancinci kancinci. Ke ngoko, umbuzo wokunceda kunye nokucutha iincwadi ezinjalo zibalulekile. Makhe siqonde ukuba ungawunciphisa njani ubungakanani befayile kwi-Excele.

Inkqubo yokunciphisa iNcwadi

Yenza ifayile yokuzalwa ifanele ukuba ifanele ukuba ihambe ngokukhawuleza kwiindlela ezininzi. Abasebenzisi abaninzi abayamkeli, kodwa rhoqo le ncwadi i-Excel iqukethe ulwazi olungeyomfuneko olungafunekiyo. Xa ifayile incinci koku, akukho mntu unika ingqalelo ekhethekileyo koku, kodwa ukuba uxwebhu luye lwaba luxilongo, luyimfuneko ukuba luxhase ngazo zonke iiparameter kuzo zonke iiparameter.

Indlela yoku-1: Ukunciphisa uluhlu lokusebenza

Uluhlu lokusebenza yindawo, izenzo endizikhumbulayo zigqwetha. Ukuba uxwebhu lubalwa, inkqubo iphinda iphinde iphinde ibuyise zonke iiseli zendawo yokusebenza. Kodwa ayisoloko ihambelana noluhlu apho umsebenzisi esebenza khona. Umzekelo, umsantsa ongafanelekanga kwitheyibhile uya kwandisa ubungakanani bodidi lokusebenza kuloo nto ifumaneka kuyo le qanda. Kuyavela ukuba i-Excel xa iphindaphindwe ngalo lonke ixesha iya kujongana neqela leeseli ezingenanto. Makhe sibone ukuba le ngxaki inokupheliswa njani kumzekelo wetafile ethile.

1. Ekuqaleni, jonga ubunzima bayo ngaphambi kokuba uqinisekise ukuba kuya kubakho ntoni emva kokuba inkqubo yenziwe. Oku kungenziwa ngokuya kwi "Ifayile" yethebhu. Yiya kwicandelo "leenkcukacha". Kwicala lasekunene lefestile evule iipropathi ezisisiseko zencwadi. Ipropathi yokuqala ibukhulu boxwebhu. Njengoko sibona, kwimeko yethu yi-56.5 ii-kilobytes.



2. Okokuqala, kufuneka ifunyanwe ukuba indawo yokusebenzela eyahluke njani kuyo kule ifunwa ngokwenene ngumsebenzisi. Kulula ukuyenza. Siba nayiphi na iseli yetafile kunye nohlobo lwe-Ctrl + isiphelo seqhosha leqhosha. I-Excel ngokukhawuleza ihamba kwiseli yokugqibela, ethi inkqubo ithathela ingqalelo into yokugqibela yendawo yokusebenza. Njengoko ubona, ngokungqalileyo, ityala lethu lingumgca 913383. Kunikezwe ukuba itafile ithatha imigca emithandathu yokuqala, kunokwenzeka ukuba ichaze into yokuba imigca ye-9133377, engasebenziyo kuphela yonyusa ubungakanani befayile , kodwa ngenxa yokuphinda-phinda ngokusisigxina koluhlu lonke lwenkqubo xa usenza naliphi na inyathelo kukhokelela ekunciphiseni enyathekayo emsebenzini kuxwebhu.

   

   Ewe, enyanisweni, umsantsa omkhulu phakathi kwenqanaba lokusebenza kwaye inyani eyamkeleke kakhulu, kwaye sathatha inani elikhulu lemigca lokucaca. Nangona, ngamanye amaxesha kukho amatyala xa lonke indawo igqatswa ithathwa ngumsebenzi.

3. Ukwenzela ukuphelisa le ngxaki, kufuneka ususe yonke imiqolo eqala ukusuka ekuqaleni engenanto kwaye kude kube sekupheleni kwephepha. Ukwenza oku, khetha iseli yokuqala, ephantsi kwetafile, kwaye uthayiphe iqhosha le-CTRL + Shift + iqhosha.



4. Njengoko sibona, emva koko zonke izinto zekholamu yokuqala, ukuqala kwiseli ekhankanyiweyo kunye nokuphela kwetafile zabelwa. Emva koko cofa kwiqhosha lemouse lasekunene lemouse. Kwimenyu yenguqu evula, khetha "Cima".

   

   Abasebenzisi abaninzi bazama ukucima ngokunqakraza kwiqhosha lokucima kwikhibhodi, kodwa alichanekanga. Esi senzo sicoca iziqulatho zeseli, kodwa azishenxisi. Ke ngoko, kwimeko yethu ayizukukunceda.

5. Emva kokuba sikhethe "Cima ..." Into kwimenyu yemeko, iwindows encinci yokukhupha iselfowuni ivulwa. Ndibeka iswitshi kwisikhundla "somtya" kuyo kwaye ucofe kwiqhosha le-Ok.



6. Yonke imiqolo yenqanaba elabiweyo yasuswa. Qiniseka ukuba uyayimisa le ncwadi ngokunqakraza kwi icon yefloppy kwikona ephezulu yefestile.



7. Ngoku makhe sibone ukuba kwasinceda njani. Siba nasiphi na isisele setafile kwaye sichwetheze umdibaniso we-CTRL + isiphelo se-CTRL. Njengoko ubona, i-Excel eyabelwe isisele sokugqibela setafile, oko kuthetha ukuba ngoku yindawo yokugqibela yendawo yokusebenzela igqabi.



8. Ngoku sifudukela kwicandelo "leNkcukacha" le "Ifayile" yethebhu yokufumanisa ukuba ubunzima bexwebhu lethu benciphile. Njengoko ubona, ngoku 32.5 kb. Khumbula ukuba ngaphambi kwenkqubo yokuphucula, ubungakanani bayo yayingama-56.5 KB. Ke, incitshisiwe ngamaxesha angaphezu kwe-1.7. Kodwa kule meko, eyona mpumelelo iphambili ayikokuncitshiswa kobunzima befayile, kwaye isibakala sokuba inkqubo ixolelwe ekukhuliseni inqanaba elingasetyenziswanga loxwebhu.

Ukuba kwincwadi yamaphepha aliqela osebenza nayo, kufuneka uqhube inkqubo efanayo nenye yazo. Oku kuyakwenza ngakumbi ukunciphisa ubungakanani boxwebhu.

Indlela yesi-2: Ukupheliswa kwefomathi engafunekiyo

Enye into ebalulekileyo esenza uxwebhu lwe-Excel lunzima, lungafuneki ukuba kufuphi. Oku kubandakanya ukusetyenziswa kweentlobo ngeentlobo zeefonti, imida, iifomathi zenani, kodwa kuqala kuzo zonke inkxalabo zokuthululwa kweeseli kwimibala eyahlukeneyo. Ngaphambi koko ngaphambi kokwenza ifomathi yefayile, kufuneka ucinge kabini, kwaye nokuba kubalulekile ukuba uyenze okanye ngaphandle kwale nkqubo ilula ukuyenza.

Oku kuyinyani ngakumbi kwiincwadi ezinezibalo esikhulu zolwazi ukuba sele zinobungakanani obukhulu. Ukongeza ukufomatha ukuya encwadini kunokunyusa ubunzima bayo kangangezihlandlo ezininzi. Ke ngoko, kufuneka ukhethe "igolide" phakathi kokubonakala kolwazi kuxwebhu kunye nobungakanani befayile, ukusebenzisa ifomathi kuphela apho kufuneka khona.

Enye into enxulumene nokufomatha, ubunzima obunzima, kukuba abanye abasebenzisi bakhetha ukufomatha iiseli "ngomda." Oko kukuthi, ayoyitha kuphela itafile ngokwayo, kodwa kunye noluhlu oluphantsi kwayo, ngamanye amaxesha kude kube sekupheleni kwephepha, ngokungabalwa kwento yokuba xa imigca emitsha iya kongezwa kwitafile, ayizukubakho iyimfuneko ekutsaleni ngalo lonke ixesha.

Kodwa ayaziwa xa imigca emitsha iya kongezwa kwaye bangaphi ongezelelweyo, kwaye onjalo obo butshoyo ufomatha uthatha ifayile ngoku, eya kuchaphazela kakubi kwaye isantya sokusebenza nolu xwebhu. Ke ngoko, ukuba ufaka isicelo sefomathi kwiiseli ezingenanto ezingafakwanga etafileni, kufuneka isuswe.

1. Okokuqala, kufuneka ubalaselisa zonke iiseli ezikwinqanaba ledatha. Ukwenza oku, cofa kwinani lomtya wokuqala ongenanto kwipaneli yokulungelelanisa ethe nkqo. Yabelwe umgca wonke. Emva koko, sisebenzisa indibaniselwano ekhoyo yeqhosha elishushu ctrl + shift + ezantsi ezantsi ezantsi.



2. Emva koko, uluhlu lonke lomqolo lungaphantsi kunenxalenye yetafile ezele yidatha, ii-vuka zibalaselisiwe. Ukuba sekhaya "Ikhaya", cofa kwi icon "ecacileyo", ekhoyo kwitheyiphu kwi-Goolbar yokuhlela. Imenyu encinci ivula. Khetha i "fomats ecacileyo" kuyo.



3. Emva kwale nyathelo kuzo zonke iiseli zoluhlu oluxhonyiweyo, ukufomatha kuya kucinywa.



4. Ngendlela efanayo, unokususa ukufomatha okungafunekiyo kwitafile ngokwayo. Ukwenza oku, khetha iiseli ezizodwa okanye uluhlu apho sijonga khona ukufomatha ubuncinci, cofa kwiqhosha "elicocekileyo" kwitheyiphu kwaye ukhethe into ethi "Iifomathi ezicacileyo" kuluhlu.



5. Njengoko ubona, ukufomatha kuluhlu olukhethiweyo lwetafile lwalususiwe ngokupheleleyo.



6. Emva koko, sibuyisela olu hlulwa kwezinto ezithile zokufomatha esifanelekileyo: Imida, iifomati zamanani, njl.

Izenzo ezichazwe apha ngasentla ziya kunceda ukunciphisa ubungakanani bencwadi ye-Excel kwaye ikhawuleze umsebenzi kuyo. Kodwa kungcono ukusebenzisa ukufomatha kuphela apho kufanelekile kwaye kuyimfuneko kunokuchitha ixesha lokwandisa uxwebhu.

Isifundo: Iitafile zokufomatha kwi-Excel

Indlela 3: Ukususa amakhonkco

Ngamanye amaxesha, inani elikhulu kakhulu lamakhonkco apho amaxabiso aqinelwe khona. Oku kungacotha kakhulu isantya somsebenzi kubo. Ngokukodwa uphembeleleke ngamandla zizingqinisiso zangaphandle kwezinye iincwadi, nangona izingqinisiso zangaphakathi zibonakaliswa kakubi ekusebenzeni. Ukuba umthombo uvela apho ikhonkco ithatha ulwazi aluhlali lusoloko luhlaziywa, oko kukuthi, intsingiselo yokutshintsha iidilesi kwiiseli kwixabiso eliqhelekileyo. Oku kuyakwandisa isantya sokusebenza kunye noxwebhu. Ikhonkco okanye ixabiso likwiseli ethile, kumqolo wefomula emva kokukhetha into.

1. Khetha indawo equlethwe zizifithiso. Ukuba kwithebhu yasekhaya, cofa kwiqhosha "Khuphela" elikwe kwitheyiphu kwiqela le-clipboard.

   

   Ngenye indlela, emva kokukhetha uluhlu, ungasebenzisa indibaniselwano yeqhosha elishushu Ctrl + C.

2. Emva kokuba idatha ikhutshiwe, musa ukususa ukhetho ukusuka kwindawo, kwaye ucofe kuyo iqhosha lemouse lasekunene. Imenyu yemeko isunguliwe. Kuyo, kwi "Useto lwe-" play, kufuneka ucofe i-icon "yexabiso". Inembono yeepilisi ezinamanani abonakalisiweyo.



3. Emva koko, zonke izingqinisiso kwindawo ezinikezelweyo ziya kuthathelwa indawo ziinkcukacha-manani.

Kodwa kuya kufuneka ukhumbule ukuba olu khetho ukwenza iNcwadi ye-Excel ayisoloko yamkelekile. Inokusetyenziswa kuphela xa idatha evela kumthombo wokuqala awunamandla, oko kukuthi, abayi kutshintsha nexesha.

Indlela 4: Iinguqulelo zeFomathi

Enye indlela yokunciphisa ubungakanani befayile kukutshintsha ifomathi yayo. Le ndlela, mhlawumbi, uninzi lwazo zonke lunceda ekutyhafeni incwadi, nangona kuyimfuneko ukusebenzisa le ndlela ingentla.

I-Excel kukho iifomati eziliqela "zomthonyama" - xls, xlsx, xlsm, xlsb. Ifomathi yefomathi ye-XL yayingulwandiso olusisiseko kwinguqulo yenkqubo ye-Excel 2003 nangaphambi koko. Sele ephesheya, kodwa, nangona kunjalo, abasebenzisi abaninzi basaqhubeka nokusetyenziswa. Ukongeza, kukho iimeko apho kufuneka ubuye emsebenzini kunye neefayile ezindala eziye zenziwe kwiminyaka emininzi eyadlulayo kwade nangokungabikho kweefomati zale mihla. Ukungasathethi ke ukuba iinkqubo ezininzi zeqela lesithathu zisebenza kunye nolwando, ezingazi ukuba zisebenzela ukhetho kamva kumaxwebhu e-Ecel.

Kufuneka kuqatshelwe ukuba incwadi eyongezelelekileyo ye-XLS inobungakanani obukhulu kakhulu kune-neague ye-XLSX yefomathi ye-XLSX, eyokuqala isebenzisa njengeyona iphambili. Okokuqala, oku kungenxa yenyani yokuba iifayile ze-XLSX zigqitywe kuvimba. Ke ngoko, ukuba usebenzisa ulwandiso lwe-XLS, kodwa unqwenela ukunciphisa ubunzima bencwadi, emva koko le nto inokwenziwa ngokulula kwifomathi ye-XLSX.

1. Ukuguqula uxwebhu kwifomathi ye-XLS kwifomathi ye-XLSX, yiya kwithebhu yefayile.



2. Kwifestile evula, ndiye ndanikela ingqalelo kwicandelo "leenkcukacha", apho kubonisiwe ukuba okwangoku ubunzima boxwebhu ngama-40 kb. Okulandelayo, cofa kwigama "Gcina njenge ...".



3. I-Window ivuliwe. Ukuba unqwenela, ungaya kwisalathiso esitsha, kodwa uninzi lwabasebenzisi lube lula ukugcina uxwebhu olutsha kwindawo enye apho ikhowudi yomthombo. Igama lencwadi, ukuba ifunwa, linokutshintshwa kwintsimi ethi "yegama lefayile", nangona ayiyomfuneko. Eyona nto ibaluleke kakhulu kule nkqubo kukuseta "uhlobo lwefayile" yentsimi "i-Excel (.xlsx)". Emva koko, unokucinezela iqhosha u "Kulungile" emazantsi efestile.



4. Emva kokugcinwa kwenziwe, yiya kwicandelo "leeNkcukacha" le-fayile yefayile ukuze ubone ukuba bungakanani ubunzima obuphelile. Njengoko ubona, ngoku yi-13,5 kbytes nxamnye ne-40 kboy phambi kwenkqubo yokuguqula. Oko kukuthi, enye kuphela yokonga kwale mihla yenza ukuba ikwazi ukutyhala le ncwadi phantse kathathu.

Ukongeza, kukho enye ifomathi ye-XLSB yanamhlanje okanye iNcwadi yeBinary egqwesileyo. Kuyo, olu xwebhu lugcinwa ngokudibeneyo. Ezi fayile zinobunzima obungaphantsi kweencwadi kwifomathi ye-XLSX. Ukongeza, ulwimi apho lurekhodwe lusondele kwiNkqubo ye-Excel. Ke ngoko, isebenza nezinye iincwadi ezinjalo ngokukhawuleza kunokuba nolunye ulwandiso. Kwangelo xesha, incwadi yefomathi echaziweyo ekusebenzeni kunye nezinto ezinokwenzeka zokusebenzisa izixhobo ezahlukeneyo (ukufomatha, imisebenzi, iigrafu, njl njl) ayinaphantsi kwefomathi ye-XLS.

Esona sizathu sokuba i-XLSB ayizange ibe yifomathi engagqibekanga kwi-Excel kukuba iinkqubo zeqela lesithathu zikwazi ukusebenza nayo. Umzekelo, ukuba ufuna ulwazi lokuthumela ngaphandle ukusuka kwi-Excel kwinkqubo ye-1C, inokwenziwa nge-XLSX okanye amaxwebhu e-XLS, kodwa hayi nge-XLSB. Kodwa, ukuba awucwangcisi ukutshintshela idatha kuyo nayiphi na inkqubo yesithathu yeqela, ungagcina ixwebhu kwifomathi ye-XLSB. Oku kuyakuvumela ukuba unciphise ubungakanani boxwebhu kwaye bandise isantya somsebenzi kuwo.

Inkqubo yokugcina ifayile kwi-XLSB ekwandisiweyo iyafana nalowo siyenziwe ukwandisa i-XLSX. Kwi "Ifayile" yethebhu, cofa kwi "Gcina njenge ...". Kwifestile yogcino evula i- "Uhlobo lwefayile", kufuneka ukhethe ukhetho "lwencwadi ye-Excel (* .xlb)". Emva koko cofa iqhosha u "Gcina".

Sijonga icandelo loxwebhu kwicandelo "leinkcukacha". Njengoko ubona, inciphile nangakumbi kwaye ngoku i-11.6 kb.

Ukushwankathela iziphumo ngokubanzi, sinokuthi ukuba usebenza ngefayile ye-XLS, ke eyona ndlela isebenzayo yokunciphisa ubungakanani bayo yi-XLSX ye-XLSX okanye i-XLSB ye-XLSB. Ukuba sele usebenzisa idatha yokwandiswa kwefayile, emva koko ukunciphisa ubunzima babo, kufuneka uqwalasele ngokufanelekileyo indawo yokusebenza, susa ukufomatha okuphezulu kunye nemali engeyomfuneko. Uya kufumana imbuyekezo enkulu ukuba uvelisa zonke ezi zenzo kwisakhiwo, kwaye ungazibekeli umda kwinketho enye.