Yehlisa usayizi wefayela kuMicrosoft Excel

Lapho usebenza e-Excel, amanye amatafula ahlaba umxhwele ngosayizi. Lokhu kuholela ekutheni usayizi wedokhumenti uyanda, kwesinye isikhathi kufinyelela ngisho nama-megabytes noma ngaphezulu. Ukungezelela isisindo sebhuku lokusebenzela le-Excel akugcini ngokuholela ekwandeni kwesikhala esikuthola ku-hard drive, kodwa, okubaluleke kakhulu, ukwehla ngesivinini sezenzo nezinqubo ezahlukahlukene kukho. Kalula nje, lapho usebenza ngedokhumenti enjalo, i-Excel iqala ukwehlisa ijubane. Ngakho-ke, impikiswano yokwenza kahle kanye nokunciphisa usayizi wezincwadi ezinjalo iba efanelekile. Ake sibheke ukuthi sinciphisa kanjani usayizi wefayela ku-Excel.

Inqubo Yokwehlisa Ubukhulu Bencwadi

Kuzofanele ukwandise ifayili elikhulisiwe ngezinkomba eziningana ngasikhathi sinye. Abasebenzisi abaningi abazi, kepha imvamisa yencwadi yokusebenza ye-Excel inemininingwane eminingi engadingekile. Lapho ifayela lilincane, akekho umuntu olinaka kakhulu, kepha uma idokhumenti seliningi, udinga ukulithuthukisa ngokuya ngawo wonke amapharamitha angabakhona.

Indlela yoku-1: ukunciphisa ibanga lokusebenza

Ububanzi bokusebenza yindawo lapho i-Excel ikhumbula khona isenzo. Lapho kulandiswa futhi idokhumenti, uhlelo lubala wonke amaseli endaweni yokusebenza. Kepha akuhlali njalo kuhambelana nobubanzi lapho umsebenzisi asebenza khona ngokweqiniso. Isibonelo, isikhala esibekwe ngengozi kude ngezansi kwetafula sizokwandisa usayizi wobubanzi bokusebenza kwento lapho lesi sikhala sikhona. Kuyavela ukuthi i-Excel izolandisa ngaso sonke isikhathi inqubo yeqembu lamaseli angenalutho. Ake sibheke ukuthi angayilungisa kanjani le nkinga usebenzisa isibonelo setafula elithile.

1. Okokuqala, bhekisisa isisindo sayo ngaphambi kokuqhathanisa nokwenza kahle ukuqhathanisa ukuthi kuzoba yini ngemuva kwenqubo. Lokhu kungenziwa ngokuhambisa kuthebhu Ifayela. Iya esigabeni "Imininingwane". Engxenyeni engakwesokudla yewindi elivulayo, kuboniswa izakhiwo eziphambili zencwadi. Into yokuqala yezakhiwo ngosayizi wedokhumenti. Njengoba ubona, kithi kungama-kilobyte angama-56,5.



2. Okokuqala, kufanele uthole ukuthi ingakanani indawo yokusebenza kweshidi ehluke kuleyo umsebenzisi ayidingayo ngempela. Lokhu kulula. Singena kunoma yisiphi iseli yetafula bese sithayipha inhlanganisela yokhiye I-Ctrl + Ekupheleni. I-Excel isuka ngokushesha iye kwiseli lokugcina, lolu hlelo olucubungula into yokugcina yendawo yokusebenza. Njengoba ubona, esimweni sethu esithile, lo umugqa 913383. Ngokunikezwa ukuthi ithebula empeleni lihlala kuphela imigqa eyisithupha yokuqala, singasho iqiniso lokuthi imigqa engu-913377 empeleni ingumthwalo ongenamsebenzi, ongakhuphi usayizi wefayela kuphela, kepha, ngoba ukuphinda kubuye kuhlolwe lonke uhla ngohlelo lapho kwenziwa noma yisiphi isenzo, kubambezela umsebenzi kudokhumenti.

   

   Kuliqiniso, eqinisweni, igebe elikhulu kangako phakathi kobubanzi bokusebenza kanye nalelo i-Excel eliyithathela lona alijwayelekile, futhi sathatha imigqa eminingi ukuze icace. Noma, kwesinye isikhathi kuba nezimo lapho indawo esebenza kuyo yonke indawo yeshidi.

3. Ukuze ulungise le nkinga, udinga ukususa yonke imigqa, kusukela kokuqala okungenalutho kuze kube sekupheleni kweshidi. Ukuze wenze lokhu, khetha iseli lokuqala, elingezansi kwetafula ngokushesha, bese uthayipha kwinhlanganisela yokhiye I-Ctrl + Shift + Arow Down.



4. Njengoba ubona, ngemuva kwalokho kukhethwe zonke izinto zekholamu lokuqala, kusukela kuseli elicacisiwe kuze kube sekupheleni kwetafula. Bese uqhafaza kokuqukethwe ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe evula, khetha Susa.

   

   Abasebenzisi abaningi bazama ukususa ngokuchofoza inkinobho. Susa kukhibhodi, kodwa akulungile. Lesi senzo sisula okuqukethwe ngamaseli, kepha asizisuli. Ngakho-ke, kithi, ngeke kusize.

5. Ngemuva kokuthi sikhethe leyo nto "Susa ..." kumenyu yokuqukethwe, kuvulwa iwindi elincane lokususa amaseli. Sibeka ukushintshwa kusikhundla kuyo "Umugqa" bese uchofoza inkinobho "Kulungile".



6. Yonke imigqa yobubanzi ekhethiwe isusiwe. Qiniseka ukuthi uyigcina futhi incwadi ngokuchofoza isithonjana sediski ekhoneni eliphezulu kwesokunxele lewindi.



7. Manje ake sibone ukuthi lokhu kwasisiza kanjani. Khetha noma isiphi iseli etafuleni bese uthayipha isinqamuleli I-Ctrl + Ekupheleni. Njengoba ubona, u-Excel ukhethe iseli lokugcina letafula, okusho ukuthi manje sekuyinto yokugcina yesikhala sokusebenzela ishidi.



8. Manje dlulela esigabeni "Imininingwane" amathebhu Ifayelaukuthola ukuthi isisindo sedokhumenti yethu sehlisiwe kangakanani Njengoba ukwazi ukubona, manje sekungama-32.5 KB. Khumbula ukuthi ngaphambi kwenqubo yokwenza kahle, usayizi wayo wawungu-56.5 Kb. Ngakho-ke, yehliswa izikhathi ezingaphezu kuka-1,7. Kepha kulokhu, impumelelo enkulu ayinciphisi ngisho isisindo sefayela, kepha ukuthi uhlelo manje selukhululekile ekuphindeni ibanga elingasetshenziswanga empeleni, elizonyusa kakhulu ijubane lokucubungula idokhumenti.

Uma incwadi inamashidi amaningi osebenza ngawo, udinga ukwenza inqubo efanayo neyawo ngamunye. Lokhu kuzokwehlisa futhi usayizi wedokhumenti.

Indlela 2: Susa Ukufometha Ngaphezulu

Okunye okubalulekile okwenza idokhumenti le-Excel libe nzima ngokwengeziwe ukufomatha ngokweqile. Lokhu kungafaka ukusetshenziswa kwezinhlobo ezahlukahlukene zamafonti, imingcele, amafomethi ezinombolo, kepha okokuqala kuphathelene nokugcwaliswa kwamaseli ngemibala ehlukene. Ngakho-ke ngaphambi kokungezelela ukufometha ifayili, udinga ukucabanga kabili ukuthi ngabe liyakufanelekela ngempela noma uma ungakwenza kalula ngaphandle kwale nqubo.

Lokhu kunjalo ikakhulukazi ezincwadini eziqukethe inani elikhulu lolwazi, zona ngokwazo esezinosayizi obonakalayo. Ukufomatha ukufometha encwadini kungakhuphula isisindo sayo noma amahlandla ambalwa. Ngakho-ke, udinga ukukhetha umaphakathi ophakathi kokubonakala kwokwethulwa kolwazi kudokhumenti nosayizi wefayela, faka ukufomatha kuphela lapho kudingeka khona ngempela.

Okunye okuhambisana nokufometha isisindo ukuthi abanye abasebenzisi bathanda ukweqisa amaseli. Okusho ukuthi, zifometha hhayi kuphela itafula uqobo, kodwa futhi nobubanzi obungaphansi kwaso, kwesinye isikhathi kuze kube sekupheleni kweshidi, ngethemba lokuthi lapho imigqa emisha ingezelelwa etafuleni, ngeke kube yimfuneko ukuwafometha futhi isikhathi ngasinye.

Kepha akwaziwa ukuthi izokwengezwa nini imigqa emisha nokuthi imingaki eyengeziwe, futhi ngokufomatha okunjalo kokuqala uzokwenza ifayela likhulu kakhulu manje, futhi lokho kuzophazamisa nomthelela ijubane lokusebenza kwalo mbhalo. Ngakho-ke, uma ufake isicelo sokufometha kumaseli angenalutho angafakiwe etafuleni, khona-ke kufanele asuswe.

1. Okokuqala, udinga ukukhetha wonke amaseli akhiwe ngaphansi kwebanga nedatha. Ukuze wenze lokhu, chofoza inombolo yomugqa wokuqala ongenalutho kuphaneli yokuqondisa mpo. Wonke umugqa uqokonyisiwe. Ngemuva kwalokho, sisebenzisa inhlanganisela ye-hotkey eseyivele ijwayelekile I-Ctrl + Shift + Arow Down.



2. Ngemuva kwalokho, kuzoqokonyiswa lonke uhlu lwemigqa engezansi kwengxenye yetafula eligcwele idatha. Ukuba kuthebhu "Ikhaya" chofoza isithonjana "Sula"etholakala kubambo kubhokisi lamathuluzi "Ukuhlela". Imenyu encane iyavula. Khetha isikhundla kukho "Sula amafomethi".



3. Ngemuva kwalesi senzo, ukufometha kuzosuswa kuwo wonke amaseli ebanga elikhethiwe.



4. Ngendlela efanayo, ungasusa ukufomatha okungadingekile etafuleni uqobo. Ukuze wenze lokhu, khetha amaseli ngamanye noma ibanga esicabanga ukuthi ukufometha njengelingawusizo kangako, chofoza inkinobho "Sula" kubambo nakuluhlu, khetha "Sula amafomethi".



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



6. Ngemuva kwalokho, sibuyela kulolu banga ezinye izinto zokufometha esizibona kufanelekile: imingcele, amafomethi ezinombolo, njll.

Izinyathelo ezingenhla zizosiza ukunciphisa kakhulu usayizi webhuku lokusebenza le-Excel futhi kusheshiswe umsebenzi okuyo. Kepha kungcono ukuqala ukusebenzisa ukufometha kuphela lapho kufaneleka khona futhi kudingekile kunokuchitha isikhathi kamuva wenza kahle idokhumenti.

Isifundo: Ukufaka amatafula e-Excel

Indlela 3: susa izixhumanisi

Amanye amadokhumenti anenombolo enkulu kakhulu yezixhumanisi ukusuka lapho amanani edonswa khona. Lokhu kunganciphisa kakhulu ijubane lomsebenzi kubo. Izixhumanisi zangaphandle zezinye izincwadi zinomthelela kakhulu kulo mbukiso, yize izixhumanisi zangaphakathi zithinta nomthelela omubi ukusebenza. Uma umthombo kusuka lapho isixhumanisi sithatha khona imininingwane ungavuselelwa njalo, okungukuthi, kunengqondo ukufaka esikhundleni samakheli esixhumanisi kumaseli ngamanani ajwayelekile. Lokhu kungandisa ijubane lokusebenza ngedokhumenti. Ungabona uma isixhumanisi noma inani lisiseli ethile kubha yefomula ngemuva kokukhetha into.

1. Khetha indawo lapho izixhumanisi ziqukethwe khona. Ukuba kuthebhu "Ikhaya"chofoza inkinobho Kopisha elibekwe phezu kobambo eqenjini lezilungiselelo Ibhodi yokunamathisela.

   

   Ngenye indlela, ngemuva kokuqokomisa ububanzi, ungasebenzisa inhlanganisela ye-hotkey I-Ctrl + C.

2. Ngemuva kokuthi idatha ikopishwe, asisusi ukukhethwa endaweni, kodwa chofoza kukho inkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Kuyo block Faka Izinketho kudingeka uchofoze isithonjana "Amanani". Inendlela yesithonjana enezinombolo ezikhonjisiwe.



3. Ngemuva kwalokho, zonke izixhumanisi endaweni ekhethiwe zizothathelwa indawo ngamanani ezibalo.

Kepha khumbula ukuthi le nketho ye-Excel workbook inketho ayamukeleki ngaso sonke isikhathi. Ingasetshenziswa kuphela uma idatha evela emthonjeni wokuqala ingenamandla, okungukuthi, ngeke iguquke ngokuhamba kwesikhathi.

Indlela 4: izinguquko zefomethi

Enye indlela yokwehlisa ubukhulu besayizi lefayela ukushintsha indlela yayo. Le ndlela mhlawumbe isiza ngaphezu kwanoma ngubani omunye umuntu ukucindezela ibhuku, yize izinketho ezingenhla kufanele zisetshenziswe ngokuhlanganiswa.

Ku-Excel kunezindlela eziningana zamafayela "abomdabu" - ama-xls, xlsx, xlsm, xlsb. Isimo se-xls sasingesisekelo esiyisisekelo sezinhlelo zohlelo i-Excel 2003 nangaphambilini. Sekuphelile, kepha noma kunjalo, abasebenzisi abaningi bayaqhubeka nokusebenzisa. Ngaphezu kwalokho, kunezikhathi lapho kufanele ubuye usebenze ngokusebenza namafayela amadala enziwe eminyakeni eminingi edlule emuva lapho bezingenafomethi yanamuhla. Ukungasho lutho ukuthi izinhlelo eziningi zenkampani yesithathu ezingazi ukuthi zizocubungula kanjani kamuva izinguqulo zemibhalo ye-Excel zisebenza nezincwadi ezinokwelulwa.

Kufanele kuqashelwe ukuthi incwadi enwetshiwe yama-xls inkulu kakhulu kune-analogue yesimanje yefomethi ye-xlsx, i-Excel njengamanje eyisebenzisa njengeyona eyinhloko. Okokuqala, lokhu kungenxa yokuthi amafayela we-xlsx, empeleni, agcinwa ezinqolobaneni. Ngakho-ke, uma usebenzisa isandiso se-xls, kepha ufuna ukwehlisa isisindo sencwadi, ungakwenza lokhu ngokuligcina kabusha ngefomethi ye-xlsx.

1. Ukuguqula idokhumenti kusuka kwifomethi ye-xls ifomethi ye-xlsx, iya kuthebhu Ifayela.



2. Ewindini elivulayo, manaka ngokushesha isigaba "Imininingwane", lapho kukhonjiswa khona ukuthi njengamanje idokhumenti inesisindo sama-Kbyte angama-40. Okulandelayo, chofoza igama "Gcina Njengo ...".



3. Iwindows yokulinda iyavula. Uma ufisa, ungashintshela kwisikhombi esisha kuyo, kodwa kubasebenzisi abaningi kulula kakhulu ukugcina idokhumenti entsha endaweni efanayo nomthombo. Igama lencwadi, uma lifiswa, lingaguqulwa enkampanini "yegama lefayela", yize kungenasidingo. Okubaluleke kakhulu kule nqubo ukusetha ensimini Uhlobo lwefayela inani "Incwadi yokusebenzela i-Excel (.xlsx)". Ngemuva kwalokho, ungacindezela inkinobho "Kulungile" phansi kwewindi.



4. Ngemuva kokuthi ukongiwa kwenziwe, ake siye esigabeni "Imininingwane" amathebhu Ifayelaukubona ukuthi isisindo sehlile kangakanani. Njengoba ukwazi ukubona, manje sekungu-13.5 KB kuqhathaniswa no-40 KB ngaphambi kwenqubo yokuguqula. Okusho ukuthi, ukuligcina lisesimweni samanje kwenze kwaba nzima ukucindezela ibhuku cishe izikhathi ezintathu.

Ngaphezu kwalokho, e-Excel kunenye ifomethi yesimanje ye-xlsb noma incwadi kanambambili. Kuyo, idokhumenti ligcinwa ekubhalweni kwe-kanambambili. Lawa mafayela anesisindo esingaphansi kwezincwadi ezinhlobo ye-xlsx. Ngaphezu kwalokho, ulimi ababhalelwe kulo lusondele kakhulu kwa-Excel. Ngakho-ke, isebenza ngezincwadi ezinjalo ngokushesha kunanoma yikuphi okunye ukunwetshwa. Ngasikhathi sinye, incwadi yefomethi ebekiwe ngokuya ngokusebenza namathuba wokusebenzisa amathuluzi ahlukahlukene (ukufomatha, imisebenzi, ihluzo, njll.) Ayiphansi ngefomethi ye-xlsx futhi idlula ifomethi ye-xls.

Isizathu esiyinhloko sokuthi kungani i-xlsb ingazange ibe yifomethi yokuzenzakalelayo ku-Excel ukuthi izinhlelo zeqembu lesithathu azikwazi ukusebenza kanzima nayo. Isibonelo, uma udinga ukuthumela ulwazi kusuka ku-Excel kuya ku-1C, lokhu kungenziwa ngemibhalo ye-xlsx noma ye-xls, kepha hhayi nge-xlsb. Kepha, uma ungahleleli ukudlulisa idatha kunoma yiluphi uhlelo oluvela eceleni, ungagcina idokhumenti ngokuphepha ngefomethi ye-xlsb. Lokhu kuzokuvumela ukuthi wehlise usayizi wedokhumenti futhi wandise ijubane lomsebenzi kuwo.

Inqubo yokulondolozwa kwefayela ekunwetshisweni kwe-xlsb iyafana nale esiyenzele ukwandiswa kwe-xlsx. Kuthebhu Ifayela chofoza entweni "Gcina Njengo ...". Ewindini elisindayo elivulayo, enkambu Uhlobo lwefayela isidingo sokukhetha inketho "I-Excel Binary Workbook (* .xlsb)". Bese uchofoza inkinobho Gcina.

Sibheka isisindo sedokhumenti esigabeni "Imininingwane". Njengoba ubona, sehlile ngisho nangaphezulu futhi manje usu-11.6 KB kuphela.

Ukufingqa imiphumela ejwayelekile, singasho ukuthi uma usebenza ngefayela ngefomethi ye-xls, khona-ke indlela ephumelela kakhulu yokunciphisa usayizi wayo ukuligcina lisesimweni sanamuhla se-xlsx noma i-xlsb. Uma usuvele usebenzisa idatha yokunwebeka kwefayela, bese unciphisa isisindo sawo, kufanele ulungiselele kahle indawo yokusebenza, ususe ukufomatha ngokweqile nezixhumanisi ezingadingekile. Uzothola ukubuyiselwa okukhulu uma wenza zonke lezi zenzo ngendlela eyinkimbinkimbi, futhi ungazikhawuleli enketho eyodwa kuphela.