Ukuhlunga kwedatha ku-Excel kuyadingeka ukwenza lula ukusebenza ngamatafula kanye namanani amakhulu wolwazi. Ngakho-ke, ngokwesibonelo, ingxenye ebalulekile ingafihlakala kumsebenzisi, futhi lapho isebenzisa isihlungi, ibonise imininingwane edingekayo njengamanje. Kwezinye izimo, lapho itafula lenziwa ngokungalungile, noma ngenxa yezizathu zokungabizi komsebenzisi, kunesidingo sokususa isihlungi kumakholomu ahlukile noma eshidini ngokuphelele. Kwenziwa kanjani ngempela, sizokuhlaziya esihlokweni.
Izibonelo Zokwakha I-Table
Ngaphambi kokuthi uqale ukususa isihlungi, okokuqala cabanga ngezinketho zokufakwa kwayo etafuleni le-Excel:
- Ukungena kwedatha. Gcwalisa imigqa namakholomu imininingwane edingekayo. Emva kwalokho, khetha ikheli lendawo yetafula, kufaka phakathi izihloko. Iya kuthebhu ethi "datha" phezulu kwamathuluzi. Sithola "ukuhlunga" (kuboniswa ngendlela ye-funnel) bese uqhafaza kuyo yi-LKM. Isihlungi senziwa ku-Upper Headers.
![Ungasisusa kanjani isihlungi ku-Excel 15035_1](/userfiles/21/15035_1.webp)
- Ukuhlunga okuzenzakalelayo kuvuliwe. Kulokhu, itafula libuye ligcwaliswe ngaphambili, ngemuva kwalokho kuthebhu "Izitayela", kutholakala ukuthi kusebenze "ukuhlunga ngetafula njengeTafula". Kufanele kube nokuhlunga okuzenzakalelayo kumibhalo engezansi yetafula.
![Ungasisusa kanjani isihlungi ku-Excel 15035_2](/userfiles/21/15035_2.webp)
Esigabeni sesibili, udinga ukuya kuthebhu ethi "Faka" futhi uthole ithuluzi lethebula, chofoza kulo nge-LKM futhi kusuka kokulandelayo okulandelayo ukukhetha "Ithebula".
![Ungasisusa kanjani isihlungi ku-Excel 15035_3](/userfiles/21/15035_3.webp)
Iwindows elandelayo ebonakalayo evula, ukubhekana netafula elakhiwe kuyakhonjiswa. Ihlala kuphela ukuyiqinisekisa, futhi izihlungi ezingezansi zivulwa ngokuzenzakalelayo.
![Ungasisusa kanjani isihlungi ku-Excel 15035_4](/userfiles/21/15035_4.webp)
Izibonelo ezinokuhlunga ku-Excel
Shiya ukubheka itafula lesampula elifanayo elenziwe ngaphambili kumakholomu amathathu.
- Khetha ikholomu lapho udinga ukujwayela khona. Ngokuchofoza umcibisholo esitokisini esiphezulu, ungabona uhlu. Ukususa elinye lamanani noma izinto, kufanele ususe umkhaza ngokuphambene nalokho.
- Isibonelo, sidinga kuphela imifino etafuleni. Ewindini elivula, susa umkhaza "ngezithelo", bese ushiya imifino iyasebenza. Vuma ngokuchofoza inkinobho ethi "Kulungile".
![Ungasisusa kanjani isihlungi ku-Excel 15035_5](/userfiles/21/15035_5.webp)
- Ngemuva kokusebenzisa uhlu luzobukeka kanjena:
![Ungasisusa kanjani isihlungi ku-Excel 15035_6](/userfiles/21/15035_6.webp)
Cabanga ngesinye isibonelo sokusebenza kokuhlunga:
- Ithebula lihlukaniswe ngamakholomu amathathu, futhi amanani okugcina ngohlobo lomkhiqizo ngamunye wethulwa. Kudinga ukulungiswa. Ake sithi sidinga ukuhlunga imikhiqizo yakhe intengo ephansi kunenani elithi "45".
- Chofoza isithonjana sokuhlunga esitokisini esikhethwe yithi. Njengoba ikholomu igcwele amanani ezinombolo, bese ngewindows ubona ukuthi i-"izihlungi zezinombolo" isesimweni esisebenzayo.
- Ukuba nesikhombisi kuyo, vula ithebhu entsha enezici ezahlukahlukene zokuhlunga kwethebula ledijithali. Kuyo, khetha inani "ngaphansi".
![Ungasisusa kanjani isihlungi ku-Excel 15035_7](/userfiles/21/15035_7.webp)
- Ngemuva kwalokho faka inombolo "45" noma khetha ngokuvula uhlu lwezinombolo ku-autofilter yomsebenzisi.
Futhi, ngosizo lwalo msebenzi, amanani ahlungwa kuhlu oluthile lwedijithali. Ukuze wenze lokhu, udinga ukwenza kusebenze inkinobho ethi "noma" ku-Autofilter yomsebenzisi. Lapho-ke phezulu setha inani elithi "ngaphansi", nangaphansi "ngaphezulu". Ezinhlangeni ezibonakalayo ngakwesokunene, amapharamitha adingekayo ehlu lamanani asethelwe ukushiya. Isibonelo, ngaphansi kwama-30 nangaphezulu kwama-45. Ngenxa yalokho, ithebula lizogcina amanani ezinombolo 25 no-150.
![Ungasisusa kanjani isihlungi ku-Excel 15035_8](/userfiles/21/15035_8.webp)
Amathuba wedatha yolwazi lokuhlunga empeleni ayabanzi. Ngaphezu kwezibonelo, kungenzeka ukuguqula idatha ngombala wamaseli, ngokusho kwezinhlamvu zokuqala zamagama namanye amanani. Manje, lapho senza ukujwayela okujwayelekile ngezindlela zokwakha izihlungi kanye nemigomo yokusebenza nabo, iya izindlela zokususa.
Khipha isihlungi sekholomu
- Okokuqala, sithola ifayela eligciniwe elinetafula kwikhompyutha yakho kanye nokuchofoza kabili i-LKM ukuvula ku-Excel. Ephepheni elinetafula, ungabona ukuthi isihlungi sisesimweni esisebenzayo kwikholamu yentengo.
![Ungasisusa kanjani isihlungi ku-Excel 15035_9](/userfiles/21/15035_9.webp)
- Chofoza isithonjana somcibisholo phansi.
- Ebhokisini lengxoxo elivula, ungabona ukuthi umaki wokuhlola obhekene nezinombolo "25" uyasuswa. Uma ukuhlunga okusebenzayo kususwe endaweni eyodwa kuphela, khona indlela elula yokufaka ilebula emuva bese uqhafaza inkinobho ethi "KULUNGILE".
- Ngaphandle kwalokho, kuyadingeka ukucisha isihlungi. Ukuze wenze lokhu, ewindini elifanayo udinga ukuthola intambo "Susa isihlungi esivela kukholamu" ... "bese uqhafaza ku-LKM. Kuzoba nokuvalwa okuzenzakalelayo, futhi yonke imininingwane efakiwe efakiwe izokhonjiswa ngokugcwele.
![Ungasisusa kanjani isihlungi ku-Excel 15035_10](/userfiles/21/15035_10.webp)
Ukususa isihlungi kusuka eshidini lonke
Kwesinye isikhathi izimo kungenzeka lapho isidingo sokususa isihlungi kuyo yonke itafula liyavela. Ukuze wenze lokhu, kuzodingeka wenze izenzo ezilandelayo:
- Vula ifayela ngedatha egciniwe ku-Excel.
- Thola ikholomu eyodwa noma eziningana lapho isihlungi senziwa khona. Kulokhu, le yikholamu "igama".
![Ungasisusa kanjani isihlungi ku-Excel 15035_11](/userfiles/21/15035_11.webp)
- Chofoza kunoma iyiphi indawo etafuleni noma ugqamise ngokuphelele.
- Phezulu, thola "idatha" bese wenza kusebenze i-LKM yabo.
![Ungasisusa kanjani isihlungi ku-Excel 15035_12](/userfiles/21/15035_12.webp)
- Lalela "ukuhlunga". Ngokuphikisana nekholomu kunezimpawu ezintathu ngesimo se-funnel enezindlela ezihlukile. Chofoza inkinobho yokusebenza "Sula" nge-funnel ebonisiwe kanye neRed Crosshair.
- Okulandelayo kuzocisha izihlungi ezisebenzayo etafuleni lonke.
Ukugcina
Izakhi zokuhlunga namagugu etafuleni kusiza kakhulu umsebenzi we-Excel, kodwa ngeshwa, umuntu uthambekele ekwenzeni amaphutha. Kulokhu, uhlelo lwe-Multifunction Excel luza ukutakula, okuzosiza ukuhlunga idatha nokususa izihlungi ezingadingekile ezifakwe ngaphambili ngokulondolozwa kwedatha yomthombo. Lesi sici siwusizo ikakhulukazi lapho sigcwalisa amatafula amakhulu.
Umlayezo wokuthi ungasusa kanjani isihlungi ku-Excel ubonakale kuqala kubuchwepheshe bolwazi.