Uma usebenza ku-Excel, ngezinye izikhathi kuyadingeka ukuhlanganisa amakholomu amabili noma ngaphezulu. Abanye abasebenzisi abazi ukuthi bangayenza kanjani. Abanye bajwayele kuphela izinketho ezilula. Sizoxoxa ngezindlela ezikhona zokuhlanganisa lezi zakhi, ngoba esimweni ngasinye kunengqondo ukusebenzisa izinketho ezahlukene.
Hlanganisa inqubo
Zonke izindlela zokuhlanganisa amakholomu zingahlukaniswa ngamaqembu amakhulu amabili: ukusetshenziswa kokufometha nokusetshenziswa kwemisebenzi. Inqubo yokufometha ilula, kodwa eminye yemisebenzi yokuhlanganisa amakholomu ingaxazululwa kuphela ngokusebenzisa umsebenzi okhethekile. Cabanga zonke izinketho ngokuningiliziwe futhi unqume ukuthi yiziphi amacala othize kungcono ukusebenzisa indlela ethile.
Indlela 1: Hlanganisa Ukusebenzisa Imenyu Yokuqukethwe
Indlela evame kakhulu yokuhlanganisa amakholomu ukusebenzisa amathuluzi wemenyu yokuqukethwe.
- Khetha umugqa wokuqala wamaseli avela ngenhla kumakholomu esifuna ukuhlanganisa. Chofoza ezintweni ezikhethiwe inkinobho yegundane efanele. Imenyu yomongo ivulwa. Khetha into kuwo "Fometha amaseli ...".
- Iwindi yokufometha yeseli ivuleka. Iya kuthebhu "Ukuvumelanisa". Kuqoqo lezinhlelo "Bonisa" eduze kwepharamitha "Ukuhlanganiswa Kwamaselula" beka uphawu. Emva kwalokho, chofoza inkinobho "Kulungile".
- Njengoba ungabona, sihlangene kuphela amaseli aphezulu etafuleni. Sidinga ukuhlanganisa wonke amaseli wamakholomu amabili ngomugqa. Khetha iseli elihlanganisiwe. Ukuba ngaphakathi kuthebhu "Ikhaya" kwi-tape chofoza inkinobho "Fometha ngesampula". Le nkinobho inomumo wesibhamu futhi itholakala ebhokisini lamathuluzi. "Ibhodi lokunamathisela". Emva kwalokho, mane ukhethe indawo esele lapho ufuna ukuhlanganisa khona amakholomu.
- Ngemuva kokufometha isampula, amakholomu wetafula azohlanganiswa abe munye.
Qaphela! Uma amaseli ahlangene aqukethe idatha, khona-ke kuphela ulwazi olukukholomu lokuqala ngakwesobunxele kwesikhala esikhethiwe luzogcinwa. Yonke enye idatha izobhujiswa. Ngakho-ke, ngokungafani okungajwayelekile, le ndlela inconywa ukuthi isebenze ngamaseli angenalutho noma ngamakholomu ene-value-value data.
Indlela 2: Hlanganisa ne-inkinobho ku-tape
Ungaphinda uhlanganise amakholomu besebenzisa inkinobho ebhethini. Le ndlela ilula ukuyisebenzisa uma ufuna ukuhlanganisa hhayi kuphela amakholomu etafuleni elihlukile, kodwa ishidi lonke.
- Ukuze uhlanganise amakholomu kushidi ngokugcwele, kumele kuqala akhethwe. Sifika kwi-panel ehlanganisiwe yokuxhumanisa i-Excel, lapho amagama amakholomu abhalwe ngezinhlamvu ze-alfabhethi yesiLatini. Cisha inkinobho yegundane lesokunxele bese ukhetha amakholomu esifuna ukuhlanganisa.
- Iya kuthebhu "Ikhaya", uma okwamanje singenye kwenye ithebhu. Chofoza kusithonjana ngesimo sontathu, ubheke phansi, ngakwesokudla kwenkinobho "Hlanganisa futhi ubeke phakathi"okuyinto itholakala ku-tape ebhodini lamathuluzi "Ukuqondanisa". Imenyu ivula. Khetha into kuwo "Hlanganisa ngomugqa".
Ngemva kwalezi zenzo, amakholomu akhethiwe wepheshana lonke azohlanganiswa. Uma usebenzisa le ndlela, njengenguqulo yangaphambilini, yonke idatha, ngaphandle kwalabo ababesekholomu engakwesokunxele ngaphambi kokuhlanganisa, izolahleka.
Indlela 3: Hlanganisa nomsebenzi
Ngesikhathi esifanayo, kungenzeka ukuhlanganisa amakholomu ngaphandle kokulahlekelwa kwedatha. Ukuqaliswa kwalenqubo kuyinkimbinkimbi kakhulu kunendlela yokuqala. Isetshenziswa ngokusebenzisa umsebenzi Ukudonsa.
- Khetha noma yisiphi iseli kukholomu engenalutho kwi-Excel sheet. Ukubangela Umsebenzi weWebhu, chofoza inkinobho "Faka umsebenzi"itholakala eduze kwebha yefomula.
- Iwindi livula uhlu lwemisebenzi ehlukahlukene. Sidinga ukuthola igama phakathi kwabo. "CLICK". Ngemva kokuthola, khetha le nto bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalokho ifasitela lezinkulumo zisebenza. Ukudonsa. Amaphuzu alo amakheli amangqamuzana okuqukethwe okudingeka ahlanganiswe. Emasimini "Umbhalo1", "Umbhalo2" nokunye sidinga ukungeza amakheli eseli egceni eliphezulu kakhulu lamakholomu okufanele ajoyine. Ungakwenza lokhu ngokuthayipha amakheli ngesandla. Kodwa, kulula kakhulu ukubeka isikhombisi emkhakheni wezingqinamba ezihambelanayo, bese ukhetha iseli ukuthi lihlanganiswe. Siyaqhubeka ngendlela efanayo namanye amangqamuzana emgqeni wokuqala wekholomu ehlanganisiwe. Ngemuva kokuthi izixhumanisi zivele emasimini "Test1", "Umbhalo2" njll, chofoza inkinobho "Kulungile".
- Esitokisini, lapho umphumela wokwenziwa kwamagugu ngomsebenzi kuboniswa, idatha ehlangene yomugqa wokuqala wekholomu ehlanganisiwe iboniswa. Kodwa, njengoba sibona, amagama esitokisini ahlanganiswe nomphumela, akukho sikhala phakathi kwabo.
Ukuze uwahlukanise, ebhafini yefomula ngemuva kwe-semicolon phakathi kwezixhumanisi zeseli, faka izinhlamvu ezilandelayo:
" ";Ngesikhathi esifanayo emkhatsini wamaphuzu amabili okucaphuna kulezi zinhlamvu ezengeziwe zibeka isikhala. Uma sikhuluma ngesibonelo esithile, kulokhu irekhodi:
= I-CLUTCH (B3; C3)ishintshiwe kwaba okulandelayo:
= CLUTCH (B3; ""; C3)Njengoba ubona, isikhala sivela phakathi kwamazwi, futhi asisekho ndawonye. Uma ngabe ufisa, i-comma noma yimuphi omunye umkhawulo wezinhlamvu ungangeniswa ngesikhala.
- Kodwa manje sibona umphumela womugqa owodwa kuphela. Ukuze uthole inani elihlanganisiwe lamakholomu kwamanye amaseli, sidinga ukukopisha lo msebenzi Ukudonsa ebangeni eliphansi. Ukuze wenze lokhu, setha isikhombisi ekhoneni elingaphansi lesokudla leseli elinefomula. Uphawu lokugcwalisa luvela ngesimo sesiphambano. Cindezela inkinobho yesinxele yesinxele bese uyihudula phansi ekugcineni kwetafula.
- Njengoba ungabona, ifomula likopishwa ebangeni elingezansi, nemiphumela ehambelanayo iboniswa emafetheni. Kodwa sibeke nje amanani kukholomu ehlukile. Manje udinga ukuhlanganisa amaseli okuqala bese ubuyela idatha endaweni yangempela. Uma umane uhlanganisa noma ususe amakholomu okuqala, ifomula Ukudonsa izophulwa, futhi sisalahlekelwa idatha. Ngakho-ke, siqhubeka kancane kancane. Khetha ikholomu nomphumela ohlangene. Kwithebhu "Ekhaya", chofoza inkinobho ethi "Kopisha" efakwe ebhokisini ebhokisini lamathuluzi "I-Clipboard". Njengesinye isenzo, emva kokukhetha ikholomu, ungathayipha isinqamuleli sekhibhodi ekhibhodi. Ctrl + C.
- Setha isikhangiso kunoma iyiphi indawo engenalutho yeshidi. Chofoza inkinobho yesokudla yegundane. Emenyu yomongo evela kubhulogi "Izinketho zokufaka" khetha into "Amanani".
- Silondoloze amanani wekholomu ehlanganisiwe, futhi asisekho ngaphansi kwefomula. Phinda futhi, kopisha idatha, kodwa kusuka endaweni entsha.
- Khetha ikholomu yokuqala ebangeni lokuqala, okuzodinga ukuhlanganiswa namanye amakholomu. Sicindezela inkinobho Namathisela kufakwe kuthebhu "Ikhaya" eqenjini lamathuluzi "Ibhodi lokunamathisela". Ungacindezela isinqamuleli sekhibhodi esikhundleni sesenzo sokugcina Ctrl + V.
- Khetha amakholomu okuqala okufanele ahlanganiswe. Kuthebhu "Ikhaya" ebhodini lamathuluzi "Ukuqondanisa" vula imenyu esivele iyajwayele indlela yangaphambilini bese ukhetha into kuyo "Hlanganisa ngomugqa".
- Emva kwalokhu, kungenzeka ukuthi iwindi lizovela izikhathi eziningana ngomyalezo wolwazi mayelana nokulahlekelwa kwedatha. Njalo cindezela inkinobho "Kulungile".
- Njengoba ungabona, ekugcineni, idatha ihlanganiswe kukholomu eyodwa endaweni lapho yayidingeka khona ekuqaleni. Manje udinga ukususa ishidi lemininingwane yokuhamba. Sinezindawo ezimbili ezinjalo: ikholomu enefomula kanye nekholomu enezindinganiso ezikopishiwe. Khetha uhlangothi lokuqala nolwesibili. Chofoza inkinobho yesokudla yegundane endaweni ekhethiwe. Kumenyu yesimo, khetha into "Sula okuqukethwe".
- Ngemuva kokuthi siphume idatha yedlulisela, sifometha ikholomu ehlanganisiwe ekuqapheliseni kwethu, njengoba ifomethi yethu isethwe kabusha ngenxa yokusebenza kwethu. Konke kuncike ngenhloso yetafula elithile futhi kushiywa ekuboneni komsebenzisi.
Kulokhu, inqubo yokuhlanganisa amakholomu ngaphandle kokulahlekelwa kwedatha ingacatshangwa igcwaliswe. Yiqiniso, le ndlela yinkimbinkimbi kakhulu kunezinketho zangaphambilini, kodwa kwezinye izimo ayikwazi ukuhleleka.
Isifundo: I-Excel Function Wizard
Njengoba ubona, kunezindlela eziningana zokuhlanganisa amakholomu ku-Excel. Ungasebenzisa noma yikuphi kwalokhu, kodwa ngaphansi kwezimo ezithile, ukhetho kufanele lunikezwe inketho ethize.
Ngakho, abasebenzisi abaningi bakhetha ukusebenzisa inyunyana ngokusebenzisa imenyu yomongo, njengenembile kakhulu. Uma kudingekile ukuhlanganisa amakholomu hhayi etafuleni kuphela, kodwa nakuwo wonke ishidi, bese ufometha ngokusebenzisa into yemenyu ku-ribbon kuyofika ekusindisweni "Hlanganisa ngomugqa". Kodwa-ke, uma kubalulekile ukwenza inyunyana ngaphandle kokulahlekelwa kwedatha, lo msebenzi ungenziwa kuphela ngokusebenzisa umsebenzi Ukudonsa. Nakuba, uma imisebenzi yokugcina idatha ingasethiwe, futhi ngisho nangaphezulu, uma amaseli ahlangene engenalutho, khona-ke le ndlela ayikhuthazwa. Lokhu kungenxa yokuthi kunzima kakhulu futhi ukusebenza kwayo kuthatha isikhathi eside.
