Ukuze kube lula ukusebenza ngedatha enkulu yedatha ematafuleni, kumele njalo ahlelwe ngokulandela umgomo othile. Ngaphezu kwalokho, ngezinjongo ezithile, ngezinye izikhathi lonke uhlu lwemininingwane aludingeki, kodwa imigqa ngayinye kuphela. Ngakho-ke, ukuze ungadideki emininingwaneni yolwazi, isisombululo esinengqondo siyobe sihlehlise idatha bese sihlunga kusuka eminye imiphumela. Ake sithole indlela yokuhlunga nokuhlunga idatha ku-Microsoft Excel.
Ukuhlunga idatha elula
Ukuhlunga kungenye yamathuluzi alula kakhulu uma usebenza ku-Microsoft Excel. Ngalo, ungahlela imigqa yetafula ngokulandelana kwe-alfabhethi, ngokusho kwedatha esezinqoleni zamakholomu.
Ukuhlunga idatha ku-Microsoft Excel kungenziwa ngokusebenzisa inkinobho ethi "Hlela nokuhlunga", etholakala kuthebhu ethi "Ekhaya" kulayini kwibha yamathuluzi "Ukuhlela". Kodwa okokuqala, sidinga ukuchofoza kunoma iyiphi iseli kukholomu esizoyihlela.
Isibonelo, etafuleni elingezansi, abasebenzi kufanele bahlungwe nge-alphabetically. Sifinyelela kunoma iyiphi iseli yekholomu "Igama", bese uchofoze inkinobho ethi "Hlela nokuhlunga". Ukuze uhlele amagama alfabhethi, ohlwini oluvela, khetha into "Hlunga kusuka ku-A kuya ku-Z".
Njengoba ubona, yonke idatha etafuleni itholakala, ngokusho kohlu lwamagama alfabhethi.
Ukuze wenze ukuhlelwa ngokulandelana okulandelanayo, kwimenyu efanayo, khetha Inkinobho yoHlelo kusuka ku-Z kuya ku-A ".
Uhlu lwakhiwe kabusha ngokuhleleka okulandelanayo.
Kumele kuqashelwe ukuthi lolu hlobo lokuhlunga luboniswa kuphela ngefomethi yedatha yombhalo. Isibonelo, uma ifomethi yenombolo icacisiwe, uhlobo "Kusuka kokungenani kuya kwesiphezulu" (futhi ngokuphambene nalokho) lucacisiwe, futhi uma ifomethi yosuku imisiwe, "Kusuka endala kuya entsha" (futhi ngokuphambene nalokho).
Ukuhlunga ngokwezifiso
Kodwa, njengoba sibona, ngezinhlobo ezicacisiwe zokuhlunga ngokulingana okufanayo, idatha equkethe amagama omuntu ofanayo ihlelwe ngokuhleleka ngaphakathi kwebanga.
Futhi kufanele senzeni uma sifuna ukuhlunga amagama ngama-alfabhethi, kodwa isibonelo, uma igama lilingana, yenza idatha ihlelwe ngosuku? Ukwenza lokhu, kanye nokusebenzisa ezinye izici, konke kumenyu efanayo "Hlunga futhi uhlunge", kudingeka siye entweni ethi "Ukuhlelwa ngokwezifiso ...".
Ngemuva kwalokho, iwindi yezilungiselelo zokuhlela zivula. Uma kukhona izihloko etafuleni lakho, sicela uqaphele ukuthi kule window kufanele kube khona uphawu lokuhlola eduze "Idatha yami iqukethe izihloko".
Ensimini "Ikholomu" ichaza igama lekholomu, elizohlungwa. Esimweni sethu, lena yikholomu "Igama". Ensimini "Ukuhlunga" kuboniswa ukuthi yiluphi uhlobo lokuqukethwe oluzohlungwa. Kunezinketho ezine:
- Amanani;
- Umbala weselula;
- Umbala wefonti;
- Isithonjana seselula
Kodwa, ezimweni eziningi, into ethi "Amanani" isetshenziswe. Isethwe ngokuzenzakalelayo. Esimweni sethu, sizophinde sisebenzise le nto.
Kukholomu "I-oda" sidinga ukucacisa umyalelo lapho idatha izobe khona khona: "Kusukela ku-A ukuya ku-Z" noma ngokuphambene nalokho. Khetha inani "Kusukela ku-A kuya ku-Z".
Ngakho, sabeka ukuhlunga ngeyodwa yamakholomu. Ukuze wenze ngokwezifiso ukukhetha kwenye ikholomu, chofoza inkinobho "Engeza izinga".
Enye isethi yamasimu ibonakala, okumele kugcwaliswe kakade ukuhlunga ngenye ikholomu. Esimweni sethu, ngekholomu "Usuku". Njengoba isakhiwo sosuku sisethelwe kulezi zisele, enkundleni "Ye-oda" sabeka amanani hhayi "Kusukela ku-A ukuya ku-Z", kepha "Kusuka endala kuya entsha", noma "Kusukela okusha kuya endala."
Ngendlela efanayo, kule festile, ungalungisa, uma kunesidingo, bese uhlunga ngamanye amakholomu ngendlela ehamba phambili. Uma zonke izilungiselelo zenziwa, chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, manje etafuleni lethu lonke idatha ihlungwa, okokuqala, ngegama lomsebenzi, bese kuthi, ngezinsuku zokukhokha.
Kodwa, akuzona zonke izici zokuhlelwa ngokwezifiso. Uma ufisa, kule window ungalungisa ukukhetha hhayi ngamakholomu, kodwa ngemigqa. Ukuze wenze lokhu, chofoza inkinobho ethi "Parameters".
Ewindini evuliwe yokuhlunga imingcele, susa inkinobho endaweni "Imigqa yezinhlangothi" endaweni "Amakholomu wezinkambo". Chofoza inkinobho ethi "Kulungile".
Manje, ngokufana nesibonelo sangaphambilini, ungangena idatha yokuhlunga. Faka idatha, bese uchofoza inkinobho ethi "Kulungile".
Njengoba ubona, emva kwalokhu, amakholomu aguqulwa ngokusho kwemingcele engenisiwe.
Yiqiniso, etafuleni lethu, kuthathwe njengesibonelo, ukusetshenziswa kokuhlunga ngokushintsha indawo yamakholomu akusizi ngokukhethekile, kodwa kwezinye izibhebhe lolu hlobo lokuhlunga lungase lufaneleke.
Hlunga
Ngaphezu kwalokho, ku-Microsoft Excel, kunomsebenzi wokuhlunga idatha. Ikuvumela ukuthi ushiye ukubonakala kuphela idatha obonayo ifanelekile, bese ufihla konke okunye. Uma kunesidingo, idatha efihliwe ingabuyiselwa njalo kwimodi ebonakalayo.
Ukuze sisebenzise lo msebenzi, sichofoza kunoma isiphi iseli etafuleni (futhi mhlawumbe esihlokweni), futhi chofoza inkinobho ethi "Hlela nokuhlunga" kubha yamathuluzi "Ukuhlela". Kodwa, ngalesi sikhathi kwimenyu evelayo, khetha into "Hlunga". Ungase futhi esikhundleni salezi zenzo mane ucindezele inhlanganisela eyinhloko Ctrl + Shift + L.
Njengoba ubona, kumaseli anegama lazo zonke amakholomu, isithonjana sibonakala ngesigcawu, lapho unxantathu obheke phansi obhalwe khona.
Chofoza kulesi sithonjana kukholomu ngalokho esizoyihlunga. Esikhathini sethu, sanquma ukuhlunga ngegama. Isibonelo, sidinga ukushiya idatha kuphela isisebenzi uNikolaev. Ngakho-ke, sisusa umkhawulo emagameni abo bonke abanye abasebenzi.
Uma inqubo igcwalisiwe, chofoza inkinobho ethi "Kulungile".
Njengoba sibona, etafuleni kwakukhona imigqa kuphela negama lesisebenzi sikaNikolaev.
Ake sicindezele umsebenzi, bese usuka etafuleni kuphela idatha ehlobene noNicolaev kwikota ye-III ka-2016. Ukwenza lokhu, chofoza isithonjana kuseli "Usuku". Kulolu hlu oluvula, susa uphawu kusukela ezinyangeni zika "Meyi", "ngoJuni" no-"Okthoba", njengoba zingahambisani nekota yesithathu, bese uchofoza inkinobho ethi "Kulungile".
Njengoba ubona, kukhona idatha kuphela esiyidingayo.
Ukuze ususe isihlungi kukholomu ethile, futhi ubonise idatha efihliwe, phinda uqhafaze esithombeni esitholakala kuseli negama laleli kholomu. Emenyu evula, chofoza into ethi "Susa isihlungi kusuka ...".
Uma ufuna ukusetha kabusha lesi sihlungi ngokwetafula, kuzomele uchofoze inkinobho ethi "Hlunga nokuhlunga" ebhobheni, bese ukhetha inketho ethi "Sula".
Uma udinga ukukhipha ngokuphelele isihlungi, khona-ke, njengokusungulwa kwayo, kwimenyu efanayo, khetha into "Hlunga", noma thayipha inhlanganisela yekhibhodi ekhibhodi Ctrl + Shift + L.
Ngaphezu kwalokho, kufanele kuqashelwe ukuthi emva kokuvula umsebenzi "Wokuhlunga", uma uchofoza kwisithonjana esifanayo emafetheni ekhanda etafuleni, kwimenyu evele ibonakala, imisebenzi yokuhlunga iyatholakala, esishilo ngenhla: "Hlunga A kuya ku-Z" , "Hlunga kusuka ku-Z kuya ku-A", futhi "Hlela ngombala".
Isifundo: Indlela yokusebenzisa isihlungi se-Microsoft ku-Excel
Ithebula elihlakaniphile
Ukuhlunga nokuhlunga nakho kungenziwa kusebenze ngokuvula indawo yedatha osebenza ngayo kuyo okuthiwa "ithebula elihlakaniphile".
Kunezindlela ezimbili zokudala ithebula elihlakaniphile. Ukuze usebenzise okokuqala, khetha yonke indawo yetafula, futhi, uma usendaweni yasekhaya, chofoza inkinobho eFometha njengeTable ithebula. Le nkinobho isendaweni yamathuluzi wamathuluzi.
Okulandelayo, khetha eyodwa yezitayela zakho ozithandayo kuhlu oluvula. Ukukhethwa kwetafula ngeke kuthinte ukusebenza kwetafula.
Emva kwalokho, ibhokisi lengxoxo livula lapho ungashintsha khona izixhumanisi zetafula. Kodwa, uma ngaphambilini ukhethe indawo ngokulungile, akukho okunye okumele kwenziwe. Into esemqoka ukuphawula ukuthi kukhona umkhawulo eceleni kwepharathi "Ithebula ne-header". Okulandelayo, mane uchofoze inkinobho ethi "Kulungile".
Uma unquma ukusebenzisa indlela yesibili, kuzodingeka futhi ukhethe yonke indawo yetafula, kodwa manje uye kuthebhu "Faka". Ngenkathi lapha, ku-ribbon ebhokisini lamathuluzi "Amathebula", kufanele uchofoze inkinobho ethi "Ithebula".
Ngemuva kwalokho, njengesikhathi sokugcina, iwindi lizovula lapho ungalungisa khona izixhumanisi zokubekwa kwetafula. Chofoza inkinobho ethi "Kulungile".
Kungakhathaliseki ukuthi iyiphi indlela oyisebenzisayo uma udala itafula elihlakaniphile, uzophetha ngetafula, kuma-cell of the caps lapho izimpawu zokuhlunga ezichazwe ekuqaleni zizofakwa.
Uma uchofoza kulesi sithonjana, yonke imisebenzi efanayo iyoba khona lapho uqala isihlungi ngendlela ejwayelekile nge inkinobho ethi "Hlela nokuhlunga".
Isifundo: Indlela yokudala itafula ku-Microsoft Excel
Njengoba ubona, amathuluzi wokuhlunga nokuhlunga, uma asetshenziswa kahle, angenza lula abasebenzisi basebenze ngamatafula. Okubaluleke kakhulu umbuzo wokusetshenziswa kwawo uma kwenzeka ithebula liqukethe uhlu olubanzi lwemininingwane.
