Isixazululo sephutha leMicrosoft Excel "Amafomethi amaningi Eseli Ehlukile"

Enye yezinkinga abasebenzisi abahlangabezana nazo lapho besebenza namatafula eMicrosoft Excel yiphutha "Kunezinhlobo eziningi zamaseli ezihlukile." Kuvame kakhulu lapho sisebenza ngamatafula ngesengezo se-.xls. Ake siqonde umnyombo wale nkinga futhi sithole ukuthi zingaqedwa kanjani.

Bheka futhi: Unganciphisa kanjani usayizi wefayela ku-Excel

Ukulungiswa kwamaphutha

Ukuqonda ukuthi ungalilungisa kanjani iphutha, kufanele wazi umongo wawo. Iqiniso ngukuthi amafayili e-Excel anokwesekwa kwe-.xlsx kusetshenziswa okufanayo ngasikhathi sinye ngamafomethi angama-64,000 kudokhumenti, kanye nokunwetshwa kwe-.xls - kungama-4000 kuphela. Lapho lemikhawulo idluliwe, kwenzeka le phutha. Ifomethi inhlanganisela yezinto ezahlukahlukene zokufomatha:

• Imingcele;
• Gcwalisa;
• Ifonti
• Ama-histogram, njll.

Ngakho-ke, esitokisini esisodwa kungaba nezindlela eziningana ngasikhathi sinye. Uma idokhumenti isebenzisa ukufometha ngokweqile, lokhu kungavele kubangele iphutha. Manje ake sibheke ukuthi ungayilungisa kanjani le nkinga.

Indlela yoku-1: gcina ifayela ngokunwetshwa kwe-.xlsx

Njengoba kushiwo ngenhla, amadokhumenti anokwengezwa kwe-.xls asekela ukusebenza kanyekanye kwama-4,000 amayunithi amafomethi. Lokhu kuchaza iqiniso lokuthi kaningi leli phutha livela kubo. Ukuguqula incwadi ibe umbhalo wesimanje we-XLSX, esekela ukusebenza ngezinto ezingama-64,000 ngasikhathi sinye, kuzokuvumela ukuthi usebenzise lezi zinto izikhathi eziyi-16 ngaphambi kokuthi kwenzeke iphutha elingaphezulu.

1. Iya kuthebhu Ifayela.



2. Okulandelayo, kumenyu mpo yangakwesobunxele, chofoza entweni Gcina Njengo.



3. Iwindi lefayela lokugcina liyaqala. Uma ifiswa, ingagcinwa endaweni ehlukile, hhayi endaweni lapho khona umqulu womthombo ngokuya komunye umkhombandlela we-hard drive. Futhi enkundleni "Igama lefayela" ungaguquguqula ngenketho igama layo. Kepha lezi akuzona izimfanelo. Lezi zilungiselelo zingashiywa njengezenzakalelayo. Umsebenzi oyinhloko usekhampeni Uhlobo lwefayela inani lokushintsha "I-Excel Book 97-2003" kuvuliwe Incwadi yokusebenza ye-Excel. Ngalezi zinhloso, chofoza kule nkambu bese ukhetha igama elifanele ohlwini oluvulayo. Ngemuva kokwenza inqubo ebekiwe, chofoza inkinobho Gcina.

Manje idokhumenti izosindiswa ngokunwetshwa kwe-XLSX, okuzovumela ukuthi isebenze izikhathi eziphindwe izikhathi eziyi-16 inani elifanayo lamafomethi ngasikhathi sinye njengoba lalisebenza lapho kufakwa ifayili enwetshisweni le-XLS. Esikhathini esiningi samacala, le ndlela iqeda iphutha esilifundayo.

Indlela 2: amafomethi asobala emigqeni engenalutho

Kodwa noma kunjalo, kunezikhathi lapho umsebenzisi asebenza ngesandiso se-XLSX, kepha yena usalithola lelo phutha. Lokhu kungenxa yokuthi ngenkathi kusetshenziswa idokhumenti, ingqophamlando yamafomethi angama-64,000 idluliwe. Ngaphezu kwalokho, ngenxa yezizathu ezithile, isimo kungenzeka lapho udinga ukulondolozwa ifayela ngokunwetshwa kwe-XLS kune-XLSX, ngoba eyokuqala, ngokwesibonelo, ingasebenza ngenani elikhulu lezinhlelo ezivela eceleni. Kulezi zimo, udinga ukubheka enye indlela yokuphuma kulesi simo.

Imvamisa, abasebenzisi abaningi bahlela indawo yetafula elinamamaki, ukuze ngokuzayo bangachithi isikhathi kule nqubo uma kungenzeka ukwanda kwetafula. Kepha lena indlela engalungile ngokuphelele. Ngenxa yalokhu, usayizi wefayela unyuka kakhulu, usebenze nalo wehlisa ijubane, futhi ngaphandle kwalokho, lezo zenzo zingaholela kwephutha esixoxa ngalo kulesi sihloko. Ngakho-ke, ukweqiwa okunjalo kufanele kulahlwe.

1. Okokuqala, kudingeka sikhethe yonke indawo ngaphansi kwetafula, kusukela kumugqa wokuqala, lapho kungekho datha. Ukuze wenze lokhu, chofoza kwesobunxele kwigama lezinombolo zalo mzila kuphaneli yokuqondisa mpo. Umugqa wonke ukhethiwe. Faka inhlanganisela yezinkinobho I-Ctrl + Shift + Arow Down. Lonke uhla lwedokhumenti luqokonyiswa ngezansi kwetafula.



2. Ngemuva kwalokho siqhubekela kuthebhu "Ikhaya" bese uqhafaza isithonjana sebambo "Sula"etholakala kwibhulokhi yamathuluzi "Ukuhlela". Uhlu luyavuleka lapho sikhetha khona isikhundla "Sula amafomethi".



3. Ngemuva kwalesi senzo, ibanga elikhethiwe lizosulwa.

Ngokufanayo, ungahlanza amaseli uye kwesokudla kwetafula.

1. Chofoza egameni lekholamu lokuqala elingagcwalisiwe nedatha yokuhlanganisa iphaneli. Kuqokonyiswa kuze kube phansi impela. Ngemuva kwalokho senza ukuhlanganiswa kwezinkinobho I-Ctrl + Shift + Arow Right. Kulokhu, kugcizelelwa lonke uhla lwedokhumenti olungakwesokudla kwetafula.



2. Ngemuva kwalokho, njengasekuqaleni, chofoza isithonjana "Sula", bese ukhetha inketho kumenyu eyehlayo "Sula amafomethi".



3. Ngemuva kwalokho, ukuhlanza kuzokwenziwa kuwo wonke amaseli kuya ngakwesokudla kwetafula.

Inqubo efanayo lapho kwenzeka iphutha, esikhuluma ngalo kulesi sifundo, ngeke siphume endaweni noma ngabe kubonakala sengathi kuqala ukubheka ukuthi amabanga angezansi nangakwesokudla setafula awahlelwanga nhlobo. Iqiniso ngukuthi kungenzeka aqukethe amafomethi "afihlekile". Isibonelo, kungenzeka kungabikho umbhalo noma izinombolo esitokisini, kepha kusethelwe ngokugqamile, njll. Ngakho-ke, ungavilaphi, uma kwenzeka iphutha, feza le nqubo ngisho nakububanzi obungenalutho. Futhi, ungakhohlwa ngamakholomu afihlekile nokufihla.

Indlela 3: sula amafomethi ngaphakathi kwetafula

Uma inketho yangaphambilini ingazange isize ekuxazululeni inkinga, khona-ke kufanele unake ukufomatha ngokweqile ngaphakathi kwetafula uqobo. Abanye abasebenzisi benza ukufometha etafuleni noma lapho kungathethi khona imininingwane eyengeziwe. Bacabanga ukuthi benza itafula lihle ngokwedlulele, kepha empeleni imvamisa ingaphandle, umklamo onjalo ubukeka ungathandeki. Okubi kakhulu, uma lezi zinto ziholela ekuvinjelweni kohlelo noma ngephutha esilichazayo. Kulokhu, ukufometha okunengqondo ngempela kufanele kushiywe etafuleni.

1. Kulezo zigaba lapho ukufometha kungasuswa ngokuphelele, futhi lokhu ngeke kuthinte okuqukethwe kolwazi kwetafula, senza inqubo ngokulandela i-algorithm efanayo neyachazwa indlela eyedlule. Okokuqala, khetha ibanga etafuleni lokuhlanza kulo. Uma itafula likhulu kakhulu, khona-ke le nqubo izoba lula ngokwengeziwe ukusebenzisa inhlanganisela yenkinobho I-Ctrl + Shift + Arow Right (kwesobunxele, phezulu, phansi) Uma ngasikhathi sinye ukhetha iseli ngaphakathi kwetafula, khona-ke usebenzisa lezi zinkinobho, ukukhetha kuzokwenziwa kuphela ngaphakathi kwaso, hhayi ekugcineni kweshidi, njengakwindlela edlule.

   Chofoza inkinobho esivele siyazi "Sula" kuthebhu "Ikhaya". Uhlu olwehliswayo, khetha inketho "Sula amafomethi".



2. Ibanga elikhethiwe lethebula lizosulwa ngokuphelele.



3. Ukuphela kwento ezodinga ukwenziwa kamuva ukusetha imingcele kucezu olucwengekile, uma ngabe bekhona kulolo hlalo lwethebula.

Kepha kwezinye izindawo zethebula, le ndlela ngeke isebenze. Isibonelo, ebangeni elithile, ungasusa ukugcwaliswa, kepha kufanele ushiye ifomethi yosuku, ngaphandle kwalokho idatha ngeke iboniswe kahle, imingcele nezinye izinto. Uhlobo olufanayo lwezenzo esikhulume ngalo ngaphezulu lusisusa ngokuphelele ukufometha.

Kepha kunendlela yokuphuma futhi kuleli cala, noma kunjalo, kuthatha isikhathi esithe xaxa. Ezimweni ezinjalo, umsebenzisi kuzodingeka ukuthi akhethe ibhlokhi ngalinye lamaseli afomethwe ngendlela efanayo asuse ngesandla indlela yohlobo olungasakazwa ngayo.

Vele, lo ngumsebenzi omude futhi obuhlungu uma itafula likhulu kakhulu. Ngakho-ke, kungcono ukungasebenzisi kabi "ubuhle" ngokushesha lapho ulungiselela idokhumenti, ukuze kuthi kamuva kube nezinkinga, isixazululo sakho esizothatha isikhathi esiningi.

Indlela 4: susa ukufomatha okunemibandela

Ukufomatha okunemibandela kuyithuluzi elilula kakhulu lokubona idatha, kepha ukusetshenziswa kwayo ngokweqile kungadala nephutha esilifundayo. Ngakho-ke, udinga ukubheka uhlu lwemithetho yokufometha enemibandela esetshenziswe kuleli shidi futhi ususe izikhundla ongazenza ngaphandle kwawo.

1. Itholakala kuthebhu "Ikhaya"chofoza inkinobho Ukufomatha okunemibandelaokuyi-block Izitayela. Kumenyu evula ngemuva kwalesi senzo, khetha Ukuphathwa Kwemithetho.



2. Ngemuva kwalokhu, kwethulwa iwindi lokuphatha umthetho, eliqukethe uhlu lwezinto ezinemibandela yokufometha.



3. Ngokuzenzakalelayo, uhlu luqukethe kuphela izinto zesiqeshana esikhethiwe. Ukuze ubonise yonke imithetho eshidini, sihlela kabusha inkambu ebaleni "Khombisa imithetho yokufometha ye" esikhundleni "Ishidi leli". Ngemuva kwalokho, kuzoboniswa yonke imithetho eshidi lamanje.



4. Bese ukhetha umthetho ongawenza ngaphandle, bese uchofoza inkinobho Susa umthetho.



5. Ngale ndlela, sisusa leyo mithetho engadlali indima ebalulekile ekuboneni kwedatha. Ngemuva kokuba inqubo isiqediwe, chofoza inkinobho "Kulungile" phansi ewindini Umphathi we-Rule.

Uma udinga ukususa ngokuphelele ukufomatha okunemibandela ebangeni elithile, ukulenza kube lula kakhulu.

1. Khetha ibanga lamaseli esihlela ukuwasusa.



2. Chofoza inkinobho Ukufomatha okunemibandela ebhlokini Izitayela kuthebhu "Ikhaya". Kuluhlu olubonakala, khetha inketho Susa imithetho. Ngokulandelayo, olunye uhlu luyavula. Kuyo, khetha into "Susa imithetho kumaseli akhethiwe".



3. Ngemuva kwalokho, yonke imithetho ebangeni elikhethiwe izosuswa.

Uma ufuna ukususa ngokuphelele ukufomatha okunemibandela, khona-ke ohlwini lwemenyu lokugcina udinga ukukhetha inketho "Susa imithetho kusuka kulo lonke ishidi".

Indlela 5: susa izitayela

Ngaphezu kwalokho, le nkinga ingavela ngenxa yokusetshenziswa kwenombolo enkulu yezitayela zokwenza ngokwezifiso. Ngaphezu kwalokho, zingavela ngenxa yokungenisa noma ukukopisha kusuka kwezinye izincwadi.

1. Le ndaba ixazululwa kanjena. Iya kuthebhu "Ikhaya". Kubambo olubekwe ebhokisini lamathuluzi Izitayela chofoza eqenjini Izitayela Zamaseli.



2. Imenyu yesitayela iyavula. Izitayela ezahlukahlukene zokwakheka kwamaseli zivezwa lapha, okungukuthi, empeleni, inhlanganisela ezinqunyelwe zezindlela eziningi. Phezulu phezulu kohlu kukhona ibhulokhi Isiko. Lezi zitayela ngokwazo azakhelwanga ku-Excel, kepha zingumkhiqizo wezenzo zomsebenzisi. Uma kwenzeka iphutha esiliphenyayo, kunconywa ukuthi ulisuse.



3. Inkinga ukuthi akukho thuluzi elakhelwe ngaphakathi lokususa izitayela, ngakho-ke kufanele ususe ngalinye lazo ngokwehlukana. Hambisa ngaphezulu kwesitayela esithile eqenjini Isiko. Sichofoza kukho inkinobho yegundane elifanele bese ukhetha inketho kumenyu yokuqukethwe "Susa ...".



4. Sisusa isitayela ngasinye ebhlokini ngale ndlela. Isikokuze kusele kuphela izitayela eziphakathi nendawo ze-Excel.

Indlela yesi-6: sula amafomethi

Inqubo efanayo kakhulu yokususa izitayela ukususa amafomethi wangokwezifiso. Okusho ukuthi, sizosusa lezo zinto ezingakhelwanga ngokuzenzakalelayo ku-Excel, kepha zishunyelelwa umsebenzisi, noma ezifakwe kudokhumenti ngenye indlela.

1. Okokuqala, sizodinga ukuvula iwindi lokufomatha. Indlela ejwayelekile yokwenza lokhu ukushaya ngakwesokudla noma kuphi kudokhumenti bese ukhetha inketho kusuka kumenyu yokuqukethwe "Ifomethi yeseli ...".

   

   Ungase futhi, ngokuba kuthebhu "Ikhaya"chofoza inkinobho "Ifomathi" ebhlokini "Amaseli" ekhasethini. Kumenyu evulayo, khetha "Ifomethi yeseli ...".

   

   Enye indlela yokubiza iwindi esilidingayo iqoqo lezinqamuleli zekhibhodi I-Ctrl + 1 kwikhibhodi.

2. Ngemuva kokwenza noma yiziphi izenzo ezichazwe ngenhla, ukufometha kwewindows kuzoqala. Iya kuthebhu "Inombolo". Ebhulokini lamapharamitha "Amafomethi ezinombolo" setha ukushintshela esimweni "(onke amafomethi)". Engxenyeni efanele yaleli windi kunensimu equkethe uhlu lwazo zonke izinhlobo zezinto ezisetshenziswa kulo mbhalo.

   Khetha ngamunye wabo ngesikhombisi. Iya entweni elandelayo elula kakhulu ngokhiye "Phansi" kwikhibhodi ebhulokhi lokuhambisa. Uma into ikulayini, inkinobho Susa ngaphansi kohlu kuzobe kungasebenzi.



3. Lapho kugcizelelwa into eyenziwe ngokwezifiso, inkinobho Susa izosebenza. Qhafaza kuwo. Ngendlela efanayo, sisusa wonke amagama achazwe abasebenzisi abachazwe kuhlu.



4. Ngemuva kokuqeda inqubo, qiniseka ukuthi uchofoza inkinobho "Kulungile" phansi kwewindi.

Indlela 7: susa amashidi angafuneki

Sichaze isenzo ukuxazulula inkinga ngaphakathi kweshidi elilodwa. Kepha ungakhohlwa ukuthi lokho kwenziwa ngendlela efanayo kufanele kwenziwe ngawo wonke amanye amashidi encwadi agcwele le mininingwane.

Ngaphezu kwalokho, amashidi noma amashidi angadingekile lapho imininingwane iphindwa khona, kungcono ukuwucisha. Lokhu kwenziwa kalula.

1. Sichofoza ngakwesokudla kwilebula leshidi okufanele lisuswe, elibekwe ngaphezulu kwebha yesimo. Okulandelayo, kumenyu evelayo, khetha "Susa ...".



2. Lokhu kuvula ibhokisi lengxoxo elidinga isiqinisekiso sokususa isinqamuleli. Chofoza inkinobho ekuyo. Susa.



3. Ngemuva kwalokhu, ilebula elikhethiwe lizosuswa kudokhumenti, futhi, ngakho-ke, zonke izinto zokufometha kulo.

Uma udinga ukususa izinqamuleli ezimbalwa ezitholakala ngokulandelana, bese uqhafaza kokuqala ngenkinobho yegundane, bese uqhafaza kokugcina, kepha ubambe kuphela ukhiye I-Shift. Zonke izinqamuleli phakathi kwalezi zinto zizoqokonyiswa. Ngokulandelayo, inqubo yokususa yenziwa ngokuya nge-algorithm efanayo njengoba kuchaziwe ngenhla.

Kepha kukhona amashidi afihliwe, futhi phezu kwawo kungabakhona inani elikhulu kakhulu lezinto ezahlukahlukene ezifomethwe. Ukususa ukufometha ngokweqile kula makhishithi noma ukuwasusa ngokuphelele, udinga ukubonisa ngokushesha izinqamuleli.

1. Sichofoza kunoma yisiphi isinqamuleli bese ukhetha into kumenyu yokuqukethwe Khombisa.



2. Uhlu lwamashidi afihliwe luyavula. Khetha igama leshidi elifihlekile bese uchofoza inkinobho "Kulungile". Ngemuva kwalokho kuzokhonjiswa kuphaneli.

Senza umsebenzi onjalo ngawo wonke amashidi afihliwe. Ngemuva kwalokho sibona ukuthi benzeni ngabo: susa ngokuphelele noma uhlanze ekufomeni ngokweqile, uma ulwazi olukuyo lubalulekile.

Kepha ngaphandle kwalokhu, kukhona futhi okuthiwa amashidi afihlwe kakhulu, ongeke uwathole kuhlu lwamashidi ajwayelekile afihliwe. Zingabonakala futhi ziboniswe kuphaneli kuphela ngesihleli se-VBA.

1. Ukuqala isihleli se-VBA (umhleli we-macro), cindezela inhlanganisela ye-hotkey I-Alt + F11. Ebhlokini "Iphrojekthi" khetha igama leshidi. Kubonisa njengamashidi ajwayelekile abonakalayo, afihlekile futhi afihlekile kakhulu. Endaweni engezansi "Izindawo" bheka inani lepharamitha "Kuyabonakala". Uma ihleli lapho "2-xlSheetVeryHired", khona-ke leli ishidi elifihlekile kakhulu.



2. Sichofoza kule pharamitha futhi ohlwini oluvulayo, khetha igama "-1-xlSheet Kuyabonakala". Bese uchofoza inkinobho evamile ukuvala iwindi.

Ngemuva kwalesi senzo, ishidi elikhethiwe ngeke lisafihlwa futhi ilebula lakhona lizokhonjiswa kuphaneli. Ngaphezu kwalokho, kuzokwenzeka ukwenza inqubo yokuhlanza noma yokususa.

Isifundo: Yini okufanele uyenze uma amashidi engekho ku-Excel

Njengoba ukwazi ukubona, indlela esheshayo nephumelela kunazo zonke yokususa iphutha elaphenywa kulesi sifundo ukusindisa ifayili futhi ngokunwetshwa kwe-.xlsx. Kepha uma le ndlela ingasebenzi noma ngasizathu simbe ingasebenzi, ezinye izindlela zokuxazulula inkinga zizodinga isikhathi esiningi nomzamo kusuka kumsebenzisi. Ngaphezu kwalokho, konke kufanele kusetshenziswe ngokuhlanganiswa. Ngakho-ke, kungcono ukungasebenzisi kabi ukufomatha ngokweqile kwinqubo yokwakha idokhumenti, ukuze kuthi kamuva kungadingeki usebenzise amandla ukulungisa iphutha.