Lapho usebenza e-Excel, kwesinye isikhathi kuba nesidingo sokuhlanganisa amakholomu amabili noma amaningi. Abanye abasebenzisi abazi ukuthi bangakwenza kanjani lokhu. Abanye bajwayela kuphela izinketho ezilula. Sizodingida zonke izindlela ezingenzeka zokuhlanganisa lezi zinto, ngoba esimweni ngasinye kunengqondo ukusebenzisa izinketho ezahlukahlukene.
Hlanganisa inqubo
Zonke izindlela zokuhlanganisa amakholomu zingahlukaniswa zaba ngamaqembu amakhulu amabili: ukusetshenziswa kwefomethi nokusetshenziswa kwemisebenzi. Inqubo yokufometha ilula, kepha eminye imisebenzi yokuhlanganisa amakholomu ingaxazululwa kuphela ngokusebenzisa umsebenzi okhethekile. Cabanga zonke izinketho ngemininingwane eminingi bese unquma ukuthi yimaphi amacala athile angcono ukusebenzisa indlela ethile.
Indlela yoku-1: ukuhlanganisa usebenzisa imenyu yokuqukethwe
Indlela ejwayelekile yokuhlanganisa amakholomu ukusebenzisa amathuluzi wemenyu yokuqukethwe.
- Khetha umugqa wokuqala wamaseli wekholamu ukusuka phezulu esifuna ukuwahlanganisa. Sichofoza ezintweni ezikhethiwe ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavula. Khetha into ekuyo "Ifomethi yeseli ...".
- Iwindi lokufometha iseli liyavula. Iya kuthebhu ethi "Ukuqondanisa". Eqenjini lezilungiselelo "Khombisa" eduze kwepharamitha I-Cell Union faka uphawu. Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, sihlanganise amaseli aphezulu etafula kuphela. Sidinga ukuhlanganisa wonke amaseli amakholomu amabili ngokulandelana. Khetha iseli elihlanganisiwe. Ukuba kuthebhu "Ikhaya" kubambo, chofoza inkinobho "Uhlobo lwefomethi". Le nkinobho inesimo sebhulashi futhi isendaweni yebhulokhi yamathuluzi Ibhodi yokunamathisela. Ngemuva kwalokho, vele ukhethe yonke indawo esele lapho ufuna ukuhlanganisa khona amakholomu.
- Ngemuva kokufometha isampula, amakholomu etafula azohlanganiswa abe munye.
Ukunaka! Uma kuzoba nedatha kumaseli okufanele ahlanganiswe, khona-ke kuphela ulwazi olukukholamu lokuqala lwesobunxele lesikhathi esikhethiwe luzosindiswa. Yonke eminye imininingwane izobhujiswa. Ngakho-ke, ngaphandle kokungajwayelekile, le ndlela inconyelwe ukusetshenziswa ngamaseli angenalutho noma amakholomu anemininingwane yenani eliphansi.
Indlela 2: hlanganisa usebenzisa inkinobho kubambo
Ungahlanganisa futhi amakholomu usebenzisa inkinobho kubambo. Le ndlela ilungele ukusetshenziswa uma ufuna ukuhlanganisa hhayi amakholomu etafula elihlukile, kepha ishidi lilonke.
- Ukuze uhlanganise amakholomu eshidi ngokuphelele, kufanele akhethwe kuqala. Sifika kuphaneli yokuqondisa ye-Excel ovundlile, lapho amagama ekholamu ebhalwe khona ngezinhlamvu zamagama zesiLatini. Bamba inkinobho yegundane kwesobunxele bese ukhetha amakholomu esifuna ukuwahlanganisa.
- Iya kuthebhu "Ikhaya"uma njengamanje ukwithebhu ehlukile. Chofoza isithonjana ngesimo sonxantathu, ichopho likhombe phansi, ngakwesokudla kwenkinobho "Hlanganisa nesikhungo"etholakala kubambo kubhokisi lamathuluzi Ukuqondanisa. Imenyu iyavula. Khetha into ekuyo Hlanganisa Umugqa.
Ngemuva kwalezi zinyathelo, amakholomu akhethiwe alo lonke ishidi azohlanganiswa. Lapho usebenzisa le ndlela, njengakuhlobo lwangaphambilini, yonke imininingwane, ngaphandle kwaleyo eyayikukholamu kwesobunxele ngaphambi kokuhlanganiswa, izolahleka.
Indlela 3: Hlanganisa Usebenzisa Umsebenzi
Ngasikhathi sinye, kungenzeka ukuhlanganisa amakholomu ngaphandle kokulahleka kwedatha. Ukuqaliswa kwale nqubo kuyinkimbinkimbi kakhulu kunendlela yokuqala. Kwenziwa kusetshenziswa umsebenzi QHAFA.
- Khetha noma isiphi iseli kukholamu engenalutho ekhasini lokusebenzela le-Excel. Ukushayela Isici Wizardchofoza inkinobho "Faka umsebenzi"eseduze komugqa wamafomula.
- Iwindows livula ngohlu lwemisebenzi ehlukahlukene. Sidinga ukuthola igama phakathi kwabo. Xhuma. Ngemuva kokuthi sithole, khetha le nto bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalokho, iwindi lokuphikisana komsebenzi liyavula QHAFA. Izimpikiswano zayo zingamakheli amaseli anokuqukethwe kwawo okudinga ukuhlanganiswa. Emasimini "Umbhalo1", "Umbhalo2" njll. sidinga ukufaka amakheli amaseli emugqeni ophezulu wamakholomu ahlanganisiwe. Ungakwenza lokhu ngokufaka amakheli ngesandla. Kepha, kulula kakhulu ukubeka isikhombisi emkhakheni wempikiswano ehambisanayo, bese ukhetha iseli elihlanganisiwe. Ngendlela efanayo esenza ngayo namanye amaseli womugqa wokuqala amakholomu ahlanganisiwe. Ngemuva kokuthi izixhumanisi zivele emasimini "Test1", "Umbhalo2" njll., chofoza inkinobho "Kulungile".
- Esitokisini lapho kukhonjiswa khona umphumela wokusebenza kwamanani womsebenzi, kukhonjiswa idatha ehlanganisiwe yomugqa wokuqala wamakholomu ozokhonjiswa. Kepha, njengoba sibona, amagama esitokisi esinomphumela ahlanganiswa, akukho sikhala phakathi kwawo.
Ukuze uhlukanise, kubha yefomula ngemuva kwe-semicolon phakathi kwezixhumanisi zeseli, faka izinhlamvu ezilandelayo:
" ";Ngasikhathi sinye, sibeka isikhala phakathi kwamamaki amabili wokucaphuna kulezi zinhlamvu ezingeziwe. Uma sikhuluma ngesibonelo esithile, lapho-ke thina singena khona:
= I-CLICK (B3; C3)ishintshelwe kokulandelayo:
= I-CLICK (B3; ""; C3)Njengoba ukwazi ukubona, kuvela isikhala phakathi kwamagama, futhi awasasasebenzi ndawonye. Uma ufisa, ungabeka ikhefana noma enye into ehlukanisayo kanye nendawo.
- Kepha, kuze kube manje sibona umphumela womugqa owodwa kuphela. Ukuthola inani elihlanganisiwe lamakholomu kwamanye amaseli, sidinga ukukopisha umsebenzi QHAFA ebangeni eliphansi. Ukuze wenze lokhu, setha ikhesa ekhoneni elingezansi kweseli eliqukethe ifomula. Umaka wokugcwalisa uvela ngendlela yesiphambano. Bamba inkinobho yegundane kwesobunxele bese uyihudulela phansi ekugcineni kwetafula.
- Njengoba ukwazi ukubona, ifomula ikopishelwa ebangeni elingezansi, futhi imiphumela ehambisana nayo iyakhonjiswa kumaseli. Kepha simane sibeka amanani kukholomu ehlukile. Manje udinga ukuhlanganisa amaseli asekuqaleni futhi ubuyisele imininingwane endaweni yayo yangempela. Uma umane uhlanganisa noma ususa amakholomu okuqala, ke ifomula QHAFA izophulwa futhi sizolahlekelwa idatha vele. Ngakho-ke, sizokwenza okuhlukile. Khetha ikholomu ngomphumela ohlanganisiwe. Kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Copy" etholakala ku-ribbon "Ithuluzi" le-Clipboard "block. Njengesinye isenzo, ngemuva kokukhetha ikholomu, ungathayipha ukuhlanganiswa kwezinkinobho kukhibhodi I-Ctrl + C.
- Setha ikhesa kunoma iyiphi indawo engenalutho eshidi. Qhafaza kwesokudla. Kumenyu yokuqukethwe evela ebhlokini Faka Izinketho khetha into "Amanani".
- Silondoloze amanani wekholomu ehlanganisiwe, futhi asasaxhomekeki kufomula. Nalapha futhi, kopisha imininingwane, kepha usuka endaweni entsha.
- Khetha ikholomu yokuqala yebanga loqobo, elizodinga ukuhlanganiswa namanye amakholomu. Chofoza inkinobho Namathisela ibekwe kuthebhu "Ikhaya" eqenjini lamathuluzi Ibhodi yokunamathisela. Esikhundleni sesenzo sokugcina, ungacindezela isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + V.
- Khetha amakholomu okuqala azohlanganiswa. Kuthebhu "Ikhaya" ebhokisini lamathuluzi Ukuqondanisa vula imenyu esivele siyijwayele ngendlela yangaphambilini bese ukhetha into ekuyo Hlanganisa Umugqa.
- Ngemuva kwalokho, iwindi elinomyalezo wolwazi ngokulahleka kwedatha lingavela kaningana. Njalo cindezela inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ekugcineni imininingwane ihlanganiswa kwikholomu eyodwa endaweni lapho yayifuneka khona ekuqaleni. Manje udinga ukusula ishidi ledatha yokuhamba. Sinezindawo ezimbili ezinjalo: ikholomu enefomula nekholamu enamanani akopishiwe. Sikhetha ibanga lokuqala nelesibili ngokulandelana. Qhafaza kwesokudla endaweni ekhethiwe. Kumenyu yokuqukethwe, khetha Sula okuqukethwe.
- Ngemuva kokuqeda idatha yokuhamba, sifometha ikholomu elihlanganisiwe ngokubona kwethu, ngoba ngenxa yokukhohlisa, ifomethi yayo yabuyiselwa kabusha. Lapha konke kuncike enjongweni yetafula elithile futhi lihlala ngokubona komsebenzisi.
Kulokhu, inqubo yokuhlanganisa amakholomu ngaphandle kokulahleka kwedatha ingabhekwa njengephelele. Vele, le ndlela iyinkimbinkimbi kakhulu kunezinketho ezedlule, kepha kwezinye izimo ibaluleke kakhulu.
Isifundo: Umsebenzi Wizard e-Excel
Njengoba ukwazi ukubona, kunezindlela eziningi zokuhlanganisa amakholomu e-Excel. Ungasebenzisa noma iyiphi yazo, kepha ezimweni ezithile kufanele unikeze ukukhetha okukhethiwe.
Ngakho-ke, iningi labasebenzisi likhetha ukusebenzisa usoseshini ngemenyu yokuqukethwe, njengokunembile kakhulu. Uma udinga ukuhlanganisa amakholomu hhayi etafuleni kuphela, kepha kulo lonke ishidi, lapho ufometha ngokusebenzisa into yemenyu kubambo kuzokusiza Hlanganisa Umugqa. Uma udinga ukuhlanganisa ngaphandle kokulahleka kwedatha, ungabhekana nalo msebenzi kuphela ngokusebenzisa umsebenzi QHAFA. Noma, uma umsebenzi wokugcina idatha ungasetwanga, futhi nangaphezulu uma amaseli ezohlanganiswa engenalutho, khona-ke le ndlela ayinconywa. Lokhu kungenxa yokuthi kuyinkimbinkimbi impela futhi ukwenziwa kwayo kuthatha isikhathi eside.
