Okuqukethwe
Lapho usebenza namathebula ku-Excel, abasebenzisi ngokuvamile badinga ukuhlanganisa amaseli athile. Ngokwawo, lo msebenzi awunzima uma ingekho idatha kulawa maseli, okungukuthi angenalutho. Kodwa kuthiwani ngesimo lapho amangqamuzana equkethe noma yiluphi ulwazi? Ingabe idatha izolahleka ngemva kokuhlanganiswa? Kulesi sihloko, sizohlaziya lolu daba ngokuningiliziwe.
Okuqukethwe
Ungawahlanganisa kanjani amaseli
Inqubo ilula kakhulu futhi ingasetshenziswa ezimweni ezilandelayo:
- Hlanganisa amaseli angenalutho.
- Ukuhlanganisa amaseli lapho eyodwa kuphela iqukethe idatha egcwele.
Okokuqala, udinga ukukhetha amaseli azohlanganiswa nenkinobho yegundane engakwesokunxele. Bese siya kumenyu yohlelo kuthebhu ethi "Ekhaya" bese sibheka ipharamitha esiyidingayo lapho - "Hlanganisa futhi ubeke phakathi nendawo".
Ngale ndlela, amaseli akhethiwe azohlanganiswa abe yiseli elilodwa, futhi okuqukethwe kuzobekwa phakathi nendawo.
Uma ufuna imininingwane ingagxili phakathi, kodwa ucabangela ukufomethwa kweseli, kufanele uchofoze umcibisholo omncane oya phansi oseduze nesithonjana sokuhlanganisa iseli bese ukhetha into ethi "Hlanganisa Amaseli" kumenyu evulayo.
Ngale ndlela yokuhlanganisa, idatha izoqondaniswa kwesokudla seseli elihlanganisiwe (ngokuzenzakalelayo).
Uhlelo luhlinzeka ngamathuba okuhlanganiswa kwamaseli ngomugqa ngomugqa. Ukuze uyisebenzise, khetha uhla oludingekayo lwamaseli, oluhlanganisa imigqa eminingana, bese uchofoza into ethi "Hlanganisa Ngemigqa".
Ngale ndlela yokuhlanganisa, umphumela uhlukile: amaseli ahlanganiswa abe munye, kodwa ukuhlukaniswa kwemigqa kuyagcinwa.
Amaseli angaphinda ahlanganiswe kusetshenziswa imenyu yokuqukethwe. Ukuze wenze lo msebenzi, khetha indawo ezohlanganiswa nekhesa, chofoza kwesokudla, bese ukhetha okuthi “Fometha Amaseli” ohlwini.
Futhi efasiteleni elivelayo, khetha into ethi "Ukuqondanisa" bese ubeka uphawu ngaphambi kokuthi "Hlanganisa amaseli". Kule menyu, ungaphinda ukhethe ezinye izinketho zokuhlanganisa: ukugoqa umbhalo, ububanzi obuzenzakalelayo, umumo ovundlile noqondile, isiqondiso, izinketho ezihlukahlukene zokuqondanisa, nokuningi. Ngemuva kokuthi wonke amapharamitha asethiwe, chofoza "OK".
Ngakho, njengoba besifuna, amaseli ahlanganiswa abe munye.
Ungawahlanganisa kanjani amaseli ngaphandle kokulahlekelwa idatha
Kodwa kuthiwani uma amaseli amaningi equkethe idatha? Ngempela, ngokuhlanganisa okulula, lonke ulwazi, ngaphandle kweseli engenhla kwesokunxele, luzosuswa.
Futhi lo msebenzi obonakala unzima unesixazululo. Ukuze wenze lokhu, ungasebenzisa umsebenzi "Xhuma".
Isinyathelo sokuqala siwukwenza okulandelayo. Iseli elingenalutho kumelwe lifakwe phakathi kwamaseli ahlanganisiwe. Ukuze wenze lokhu, udinga ukuchofoza kwesokudla kukholomu / inombolo yomugqa ngaphambi kwalokho esifuna ukwengeza ikholomu / umugqa omusha bese ukhetha "Faka" kumenyu evulayo.
Kuseli elisha eliwumphumela, bhala ifomula ngokwethempulethi elandelayo: “=CONCATENATE(X,Y)“. Kulokhu, u-X kanye no-Y amanani ezixhumanisi zamaseli ahlanganiswayo.
Esimweni sethu, sidinga ukuhlanganisa amaseli B2 no-D2, okusho ukuthi sibhala ifomula “=CONCATENATE(B2,D2)” kuseli C2.
Umphumela uzoba ukunamathisela idatha kuseli elihlanganisiwe. Kodwa-ke, njengoba ubona, sinamaseli amathathu aphelele, esikhundleni selilodwa elihlanganisiwe: amabili okuqala futhi, ngokufanele, elihlanganisiwe ngokwalo.
Ukuze ususe amaseli engeziwe, chofoza (chofoza kwesokudla) kuseli elihlanganisiwe eliwumphumela. Kuhlu lokudonsela phansi, chofoza "Kopisha".
Okulandelayo, yiya esitokisini esingakwesokudla saleyo ehlanganisiwe (equkethe idatha yoqobo), chofoza kwesokudla kuyo, bese ukhetha inketho ethi "Namathisela Okukhethekile" ohlwini.
Ewindini elivulayo, khetha u- "Values" kuzo zonke izinketho bese uchofoza "Kulungile".
Ngenxa yalokho, leli seli lizoqukatha umphumela weseli C2, lapho sihlanganise khona amanani okuqala amaseli B2 no-D2.
Manje, ngemva kokufaka umphumela kuseli D2, singasusa amaseli engeziwe angasadingeki (B2 kanye ne-C2). Ukuze wenze lokhu, khetha amaseli/amakholomu engeziwe ngenkinobho yegundane engakwesokunxele, bese uchofoza kwesokudla ebangeni elikhethiwe bese ukhetha okuthi “Susa” kumenyu evulayo.
Ngenxa yalokho, kufanele kusele iseli eyodwa kuphela, lapho kuzoboniswa khona idatha ehlanganisiwe. Futhi wonke amaseli engeziwe avele ezigabeni ezimaphakathi zomsebenzi azokhishwa etafuleni.
Isiphetho
Ngakho-ke, akukho lutho oluyinkimbinkimbi ekuhlanganiseni kweseli evamile. Kodwa ukuze uhlanganise amaseli ngenkathi ugcina idatha, kufanele usebenze kancane. Kodwa noma kunjalo, lo msebenzi ungenzeka ngenxa yokusebenza okulula kohlelo lwe-Excel. Into esemqoka ukuba nesineke futhi ulandele ukulandelana okulungile kwezenzo. Sincoma ukuthi ngaphambi kokuqala umsebenzi, uma kwenzeka, wenze ikhophi yedokhumenti, uma kungazelelwe okuthile kungasebenzi futhi idatha ilahlekile.
Qaphela: Yonke imisebenzi engenhla ingasetshenziswa kuwo womabili amaseli ekholomu (amakholomu amaningi) namaseli emigqa (imigqa eminingi). Ukulandelana kwezenzo nokutholakala kwemisebenzi kuhlala kufana.