Unganciphisa kanjani usayizi wefayela le-Excel

Lapho usebenza ku-Efpelle, amanye amatafula afinyelela usayizi ohlaba umxhwele. Lokhu kuholela eqinisweni lokuthi usayizi wedokhumenti uyanda, kwesinye isikhathi ama-megabyte ambalwa nokuningi. Ukwanda kwesisindo sencwadi egqamile akuholeli ekunyuseni kuphela endaweni yaso eyakheke kwi-hard disk, kepha okubaluleke kakhulu, ukwehlisa ijubane lokwenza izenzo nezinqubo ezahlukahlukene kuwo. Kalula nje, lapho usebenza ngedokhumenti enjalo, uhlelo lwe-Excel luqala ukwehlisa ijubane. Ngakho-ke, umbuzo wokusebenzisa kanye nokwehliswa kwezincwadi ezinjalo kuyasebenza. Ake sibheke ukuthi singanciphisa kanjani usayizi wefayela ku-Efpelle.

Inqubo yokunciphisa i-Book

Lungiselela ifayili lokuzalwa kufanele kube masinyane kwizikhombisi-ndlela eziningana. Abasebenzisi abaningi ababoni, kepha imvamisa incwadi Excel iqukethe imininingwane eminingi engadingekile. Lapho ifayela lincane kulokhu, akekho umuntu obheka ukunaka okukhethekile kulokhu, kepha uma idokhumenti selibe lube lukhuni, kuyadingeka ukukunikeza lonke amapharamitha angenzeka.

Indlela 1: Ukunciphisa uhla lokusebenza

Ibanga lokusebenza yindawo, izenzo engizikhumbule ngazo i-Excel. Uma idokhumenti ibalwa, uhlelo luphinda kabusha wonke amaseli wendawo yokusebenza. Kepha akuhlali kuqondana nobubanzi lapho umsebenzisi esebenza khona ngempela. Isibonelo, igebe elivelwe ngokungafanele kude netafula lizokwandisa ngosayizi wohlu olusebenzayo kuleyo nto lapho kutholakala khona igebe. Kuvela ukuthi i-Excel lapho iphinda iphinde iphinde isebenze isikhathi ngasinye lapho izophatha inqwaba yamaseli angenalutho. Ake sibheke ukuthi le nkinga ingaqedwa kanjani esibonelweni setafula elithile.

1. Ekuqaleni, bheka isisindo sayo ngaphambi kokukwenza kahle, ukuqhathanisa ukuthi kuzoba yini ngemuva kokuba inqubo yenziwe. Lokhu kungenziwa ngokuhambisa ithebhu "yefayela". Iya engxenyeni ethi "Imininingwane". Ngakwesokunene sewindi elivule izakhiwo eziyisisekelo zencwadi. Izakhiwo zokuqala zingusayizi wedokhumenti. Njengoba sibona, kithi kuma-kilobytes angama-56,5.



2. Okokuqala, kufanele kutholakale ukuthi i-Real Workpace ihlukile kanjani kulowo odingeka umsebenzisi ngempela. Kulula ukukwenza. Siba kunoma yisiphi iseli setafula kanye nohlobo lwenhlanganisela ye-Ctrl + End. I-Excel isuka ngokushesha isengqamuzweni sokugcina, okuyinto uhlelo libheka into yokugcina yendawo yokusebenza. Njengoba ubona, ngokuqondile, icala lethu liwumugqa 913383 , kepha ngenxa yokuphinda kubuye kabusha kwalo lonke uhla lwalolu hlelo lapho wenza noma yisiphi isenzo kuholela ekunciphiseni okuncipha emsebenzini kudokhumenti.

   

   Kuyiqiniso, empeleni, igebe elikhulu elinje phakathi kobubanzi bangempela bokusebenza kanye neqiniso lokuthi i-Excel yamukela akuvamile, futhi sathatha inani elikhulu lemigqa yokucaca. Yize, kwesinye isikhathi kukhona ngisho namacala lapho yonke indawo yamaqabunga ibhekwa njengendawo yokusebenza.

3. Ukuze uqede le nkinga, udinga ukususa yonke imigqa eqala kusuka kokuqala ingelutho futhi kuze kube sekupheleni kweshidi. Ukuze wenze lokhu, khetha iseli lokuqala, lapho ngaphansi kwetafula, bese uthayipha ukhiye womcibisholo we-Ctrl + we-Shift +.



4. Njengoba sibona, ngemuva kwalokhu zonke izinto zekholomu yokuqala, kusukela kuseli elibekiwe kuze kube sekupheleni kwetafula kwabelwe. Bese uchofoza inkinobho yokuqukethwe kwesokudla kwegundane. Kumenyu yokuqukethwe evula, khetha u- "Delete".

   

   Abasebenzisi abaningi bazama ukususa ngokuchofoza inkinobho yokususa kwikhibhodi, kepha ayilungile. Lesi senzo sisula okuqukethwe amaseli, kepha akazisusi ngokwazo. Ngakho-ke, thina ngeke kusize.

5. Ngemuva kokuthi sikhethe into "Delete ..." kumenyu yokuqukethwe, kuvulwa iwindi elincane lokususa amaseli. Ngibeka i-switch esimweni esithi "String" kuyo bese uqhafaza inkinobho ethi OK.



6. Yonke imigqa yebanga elenziwe yasuswa. Qiniseka ukuthi ukomisa incwadi ngokuchofoza isithonjana se-floppy ekhoneni eliphezulu kwesokunxele sewindi.



7. Manje ake sibheke ukuthi kusisiza kanjani. Silwa noma isiphi iseli setafula bese sithayipha inhlanganisela yokhiye we-CTRL + End. Njengoba ukwazi ukubona, ukugqama kwabelwe iseli lokugcina letafula, okusho ukuthi manje sekuyisici sokugcina sendawo yokusebenza yamaqabunga.



8. Manje sithuthela engxenyeni ethi "Imininingwane" yethebhu "yefayela" ukuthola ukuthi isisindo sedokhumenti yethu sehle kangakanani. Njengoba ubona, manje sekungama-32,5 kb. Khumbula ukuthi ngaphambi kwenqubo yokwenza kahle, usayizi wawo wawungu-56.5 KB. Ngakho-ke, kuncishiswe izikhathi ezingaphezu kwezingu-1,7. Kepha kulokhu, impumelelo enkulu akuyona ukwehliswa kwesisindo sefayela, futhi iqiniso lokuthi lolu hlelo manje selukhululiwe ekubuyiseleni kabusha ibanga elingasetshenziswanga, elizokhulisa kakhulu izinga lokucubungula le dokhumenti.

Uma encwadini amashidi amaningana usebenza nawo, udinga ukwenza inqubo efanayo nalowo nalowo. Lokhu kuzokwehlisa futhi usayizi wedokhumenti.

Indlela 2: Ukuqedwa kokufomatha okungafuneki

Enye into ebalulekile eyenza idokhumenti ye-Excel isindayo, ukufometha okungadingekile. Lokhu kufaka phakathi ukusetshenziswa kwezinhlobo ezahlukahlukene zamafonti, imingcele, amafomethi ezinombolo, kepha okokuqala okuphathelene nokuthululwa kwamaseli ngemibala ehlukahlukene. Ngakho-ke ngaphambi kwalokho kwangeza ifayela, udinga ukucabanga kabili, nokuthi ngabe kuyadingeka ukukwenza noma ngaphandle kwale nqubo kulula ukukwenza.

Lokhu kuyiqiniso ikakhulukazi ezincwadini eziqukethe imininingwane enkulu eyayivele inosayizi omkhulu. Ukungeza ukufomatha encwadini kungakhulisa isisindo sayo kaninginingi. Ngakho-ke, udinga ukukhetha i- "Golden" maphakathi phakathi kokubonakala kokwethula imininingwane kudokhumenti kanye nosayizi wefayela, ukusebenzisa ukufomatha kuphela lapho kudingeka khona ngempela.

Enye into ehlotshaniswa nokufometha, isisindo esinesisindo, ukuthi abanye abasebenzisi bakhetha ukufometha amaseli "nge-margin." Okungukuthi, afomekela hhayi itafula uqobo kuphela, kodwa futhi nobubanzi obungaphansi kwalo, kwesinye isikhathi ngisho nakulo ukuphela kwephepha, ngokubalwa kweqiniso lokuthi lapho kuzongezwa khona itafula, ngeke kube kudingekile ukuyifometha ngaso sonke isikhathi.

Kepha akukaziwa lapho kuzongezwa lapho kuzongezwa khona imigqa emisha nokuthi mangaki azongezwa, futhi okunjalo kokuqala ukufomatha uthatha ifayili eselivele likhona manje, elizothinta kabi futhi ngejubane lokusebenza nalo mbhalo. Ngakho-ke, uma ufake isicelo sokufometha kumaseli angenalutho angafakiwe etafuleni, kufanele isuswe.

1. Okokuqala, udinga ukugqamisa wonke amaseli atholakala ngaphansi kwebanga nedatha. Ukuze wenze lokhu, chofoza inani lentambo yokuqala engenalutho kuphaneli yokuxhumanisa mpo. Wabela lonke umugqa. Ngemuva kwalokho, sisebenzisa inhlanganisela esejwayelekile yezikhiye ezishisayo ze-Ctrl + shift + ezansi.



2. Emva kwalokho, lonke uhla lonke lomugqa luphansi kunengxenye yetafula eligcwele idatha, ama-wake aqokonyisiwe. Ukuba sethebhu "Yasekhaya", chofoza isithonjana esithi "Sula", esitholakala etheyipini kubha yamathuluzi yokuhlela. Kuvulwa imenyu encane. Khetha isikhundla esithi "Amafomethi acacile" kuwo.



3. Ngemuva kwalesi senzo kuwo wonke amaseli wokwabelwa uhla, ukufometha kuzosuswa.



4. Ngendlela efanayo, ungasusa ukufomatha okungadingekile etafuleni uqobo. Ukuze wenze lokhu, khetha amaseli ngamanye noma abhekane lapho sibheka khona ukufomatha ubuncane, chofoza inkinobho ethi "Sula" ethepheni bese ukhetha into "ecacile" kusuka ohlwini.



5. Njengoba ukwazi ukubona, ukufomatha ebangeni elikhethiwe lethebula kususwe ngokuphelele.



6. Emva kwalokho, sibuyisela lolu banga ukufomatha izinto esikubheka njengezifanele: imingcele, amafomethi ezinombolo, njll.

Izenzo ezichazwe ngenhla zizosiza ekunciphiseni kakhulu usayizi wencwadi ye-Excel futhi asheshise umsebenzi kuwo. Kepha kungcono ukusetshenziselwa ekuqaleni ukufometha kuphela lapho kufaneleka khona futhi kuyadingeka kunokuba uchithe isikhathi sokwandisa idokhumenti.

Isifundo: Ukufomatha amatafula ku-Excel

Indlela 3: Ukususa izixhumanisi

Kwamanye amadokhumenti, inani elikhulu kakhulu lezixhumanisi ezivela lapho amanani aqiniswa khona. Lokhu kunganciphisa kakhulu ijubane lokusebenza kuzo. Ithonywe ngokuqinile izinkomba zangaphandle kwezinye izincwadi, yize izinkomba zangaphakathi ziboniswa ngokungafanele ekusebenzeni. Uma umthombo uvela lapho isixhumanisi sithatha khona imininingwane singavuselelwa njalo, okungukuthi, incazelo ukufaka esikhundleni samakheli ereferensi kumaseli ajwayelekile. Lokhu kuyakwazi ukwandisa ijubane lokusebenza nedokhumenti. Isixhumanisi noma inani lisesitokisini esithile, emugqeni wefomula ngemuva kokukhetha into.

1. Khetha indawo equkethe izinkomba. Ukuba sethebhu yasekhaya, chofoza inkinobho ethi "Kopisha" okutholakala etheyipini eqenjini lezilungiselelo ze-Clipboard.

   

   Ngenye indlela, ngemuva kokukhetha uhla, ungasebenzisa inhlanganisela yezinkinobho ezishisayo i-CTRL + C.

2. Ngemuva kokuthi idatha ikopisile, ungasusi ukukhethwa endaweni, bese uqhafaza kuyo inkinobho yegundane efanele. Imenyu yomongo yethulwa. Kuyo, ku- "Faka izilungiselelo" block block, udinga uchofoze isithonjana esithi "Amanani". Inombono wama-pictographs aboniswe izinombolo.



3. Ngemuva kwalokho, zonke izinkomba endaweni ezinikezele zizothathelwa indawo amanani wezibalo.

Kepha udinga ukukhumbula ukuthi le nketho yokwenza ngcono incwadi engcaphule ayimukelekile ngaso sonke isikhathi. Ingasetshenziswa kuphela lapho idatha evela kumthombo wokuqala ayinamandla, okungukuthi, ngeke iguquke nesikhathi.

Indlela 4: Izinguquko zefomethi

Enye indlela yokunciphisa kakhulu usayizi wefayela ukushintsha ifomethi yayo. Le ndlela, mhlawumbe, ngaphezu kwakho konke kusiza ukunciphisa incwadi, yize kuyadingeka futhi ukusebenzisa izinketho ezingenhla kwinkimbinkimbi.

Ku-Excel Kunamafomethi wefayela elithile "lomdabu" - ama-XLS, XLSX, XLSM, XLSB. Ifomethi ye-XLS bekungezelwa okuyisisekelo kwenguqulo yohlelo lwe-Excel 2003 nakungaphambili. Usevele ephelelwe yisikhathi, kepha, noma kunjalo, abasebenzisi abaningi basaqhubeka nokusetshenziswa. Ngaphezu kwalokho, kunezimo lapho kufanele ubuyele emsebenzini namafayela amadala adalwe eminyakeni eminingi edlule ngisho nalapho kungekho khona amafomethi wesimanje. Ukungasho ukuthi izinhlelo eziningi zeqembu lesithathu zisebenza nezincwadi ngalolu suku, ezingazi ukuthi zingacubungula kanjani izinketho zakamuva zemibhalo ehamba phambili.

Kumele kuqashelwe ukuthi incwadi ye-XLS Extension inosayizi omkhulu kakhulu kune-analogue yamanje yefomethi ye-XLSX, okwamanje i-Excel isebenzisa njengenhloko. Okokuqala, lokhu kungenxa yokuthi amafayela we-XLSX ayingqinango ecindezelwe ngokuyisisekelo. Ngakho-ke, uma usebenzisa ukunwetshwa kwe-XLS, kepha ufisa ukunciphisa isisindo sencwadi, khona-ke lokhu kungenziwa nje ukukuvimba ngefomethi ye-XLSX.

1. Ukuguqula idokhumenti kusuka kufomethi ye-XLS kuya kwifomethi ye-XLSX, iya kuthebhu yefayela.



2. Efasiteleni elivulayo, nginaka ngokushesha isigaba "semininingwane", lapho kuvezwa khona ukuthi okwamanje isisindo sedokhumenti singama-40 kb. Okulandelayo, chofoza igama elithi "Gcina njenge ...".



3. Iwindi longa livula. Uma ufisa, ungaya kwisikhombi esisha, kepha abasebenzisi abaningi basebenziseka kalula ukugcina idokhumenti entsha endaweni efanayo lapho ikhodi yomthombo. Igama lencwadi, uma lifiswa, lingashintshwa ensimini ethi "Igama lefayela", yize kungadingekile. Into ebaluleke kakhulu kule nqubo ukusetha i- "File Type" Excel (.XLSX) ". Ngemuva kwalokho, ungacindezela inkinobho ethi "Kulungile" ezansi kwewindi.



4. Ngemuva kokulondolozwa kwenziwa, iya engxenyeni ethi "Imininingwane" yethebhu yefayela ukuze ubone ukuthi isisindo esingakanani sehle. Njengoba ubona, manje sekungama-13,5 kbytes ngokumelene nama-40 kbytes ngaphambi kwenqubo yokuguqula. Okungukuthi, umuntu ogcina kuphela ngefomethi yanamuhla eyenze kwaba nokwenzeka ukunciphisa incwadi cishe kathathu.

Ngaphezu kwalokho, kunenye enye ifomethi yesimanje ye-XLSB noma incwadi kanambambili e-Effelle. Kuyo, idokhumenti igcinwa ekufakweni kwe-kanambambili. Lawa mafayela anesisindo esingaphansi kwezincwadi ngefomethi ye-XLSX. Ngaphezu kwalokho, ulimi abalotshwe ngalo kakhulu ohlelweni lwe-Excel. Ngakho-ke, isebenza nezincwadi ezinjalo ngokushesha kunanoma yikuphi okunye ukunwetshwa. Ngasikhathi sinye, incwadi yefomethi ebekiwe ekusebenzeni kanye namathuba okusebenzisa amathuluzi ahlukahlukene (ukufometha, imisebenzi, amagrafu, njll.) Akaphansi kwefomethi ye-XLSX futhi idlula ifomethi ye-XLS.

Isizathu esiyinhloko esenza ukuthi i-XLSB ingaba yifomethi ezenzakalelayo ku-Excel ukuthi izinhlelo ezivela eceleni zikwazi ukusebenza nayo. Isibonelo, uma udinga ukuthekelisa imininingwane kusuka ku-Excel kuhlelo lwe-1C, kungenziwa nge-XLSX noma amadokhumenti we-XLS, kepha hhayi nge-XLSB. Kepha, uma ungahleleli ukudlulisa idatha kunoma yiluphi uhlelo lweqembu lesithathu, ungasindisa ngokuphephile idokhumenti ngefomethi ye-XLSB. Lokhu kuzokuvumela ukuthi unciphise usayizi wedokhumenti futhi wandise ijubane lomsebenzi kulo.

Inqubo yokusindisa ifayela ekwandisweni kwe-XLSB ifana nalowo esiyenzile ukukhulisa i-XLSX. Kuthebhu "File", chofoza ku- "Gcina njenge ...". Efasiteleni elisindisayo elivula inkambu "yohlobo lwefayela", udinga ukukhetha inketho "incwadi ye-Excel (* .XLSB)". Bese uchofoza inkinobho ethi "Gcina".

Sibheka isisindo sedokhumenti engxenyeni ethi "Imininingwane". Njengoba ukwazi ukubona, sehle ngokwengeziwe futhi manje sekuyi-11.6 KB kuphela.

Ukufingqa imiphumela ejwayelekile, singasho ukuthi uma usebenza ngefayela le-XLS, khona-ke indlela ephumelela kunazo zonke yokunciphisa usayizi wayo ukuqinisa amandla kumafomethi wesimanje we-XLSX noma ama-XLSB. Uma usuvele usebenzisa idatha yokwandiswa kwefayela, khona-ke ukunciphisa isisindo sabo, kufanele ulungiselele kahle indawo yokusebenza, susa ukufomatha ngokweqile kanye nezikhombo ezingadingekile. Uzothola imbuyiselo enkulu kunazo zonke uma ukhiqiza zonke lezi zenzo kwinkimbinkimbi, futhi ungazikhawuleli kukhetho olulodwa.