Ungasisusa kanjani isihlungi ku-Excel

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.

okukodwa

• 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.

2.

Esigabeni sesibili, udinga ukuya kuthebhu ethi "Faka" futhi uthole ithuluzi lethebula, chofoza kulo nge-LKM futhi kusuka kokulandelayo okulandelayo ukukhetha "Ithebula".

3.

Iwindows elandelayo ebonakalayo evula, ukubhekana netafula elakhiwe kuyakhonjiswa. Ihlala kuphela ukuyiqinisekisa, futhi izihlungi ezingezansi zivulwa ngokuzenzakalelayo.

okune

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".

isihlanu

• Ngemuva kokusebenzisa uhlu luzobukeka kanjena:

6.

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".

7.

• 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.

isishiyagalombili

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

1. Okokuqala, sithola ifayela eligciniwe elinetafula kwikhompyutha yakho kanye nokuchofoza kabili i-LKM ukuvula ku-Excel. Ephepheni elinetafula, ungabona ukuthi isihlungi sisesimweni esisebenzayo kwikholamu yentengo.

isishiyagalolunye

1. Chofoza isithonjana somcibisholo phansi.
2. 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".
3. 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.

Okuthenyalwayo

Ukususa isihlungi kusuka eshidini lonke

Kwesinye isikhathi izimo kungenzeka lapho isidingo sokususa isihlungi kuyo yonke itafula liyavela. Ukuze wenze lokhu, kuzodingeka wenze izenzo ezilandelayo:

1. Vula ifayela ngedatha egciniwe ku-Excel.
2. Thola ikholomu eyodwa noma eziningana lapho isihlungi senziwa khona. Kulokhu, le yikholamu "igama".

ishumi nanye

1. Chofoza kunoma iyiphi indawo etafuleni noma ugqamise ngokuphelele.
2. Phezulu, thola "idatha" bese wenza kusebenze i-LKM yabo.

Okuqophele imali

1. Lalela "ukuhlunga". Ngokuphikisana nekholomu kunezimpawu ezintathu ngesimo se-funnel enezindlela ezihlukile. Chofoza inkinobho yokusebenza "Sula" nge-funnel ebonisiwe kanye neRed Crosshair.
2. 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.