Kaningi, lapho usebenza namatafula eMicrosoft Excel, kwenzeka isimo lapho udinga ukuhlanganisa amaseli ambalwa. Umsebenzi awukho nzima uma la maseli engenawo imininingwane. Kepha okufanele ukwenze uma idatha isivele ifakiwe kubo? Ingabe bayobhujiswa? Ake sibheke ukuthi ungahlanganisa kanjani amaseli, kufaka phakathi ngaphandle kokulahleka kwedatha, kuMicrosoft Excel.
Ukuhlanganiswa kweseli okulula
Noma kunjalo, sizokhombisa inyunyana yamaseli esibonelweni se-Excel 2010, kepha le ndlela ilungele ezinye izinhlobo zalolu hlelo lokusebenza.
Ukuze uhlanganise amaseli ambalwa, okuyiwo kuphela ogcwele idatha, noma kungenalutho ngokuphelele, khetha amaseli adingekayo nesikhombisi. Ngemuva kwalokho, kuthebhu ye-Excel ethi "Ikhaya", chofoza isithonjana kubambo "Hlanganisa bese ubeka phakathi nendawo."
Kulokhu, amaseli azohlangana, futhi yonke imininingwane ezongena esitokisini esihlanganisiwe izofakwa enkabeni.
Uma ufuna idatha ibekwe ngokuya ngokufomethwa kweseli, kuzodingeka ukhethe into ethi "Hlanganisa Amaseli" kusuka ohlwini olwehliswayo.
Kulokhu, ukuqoshwa okuzenzakalelayo kuzoqala kusuka emaphethelweni angakwesokudla kweseli elihlanganisiwe.
Futhi, kungenzeka ukuhlanganisa amaseli amaningana umugqa ngomugqa. Ukuze wenze lokhu, khetha uhla olufunayo, futhi kusuka ohlwini olwehlayo, chofoza inani "Hlanganisa ngemigqa."
Njengoba ukwazi ukubona, ngemuva kwalokhu amaseli awahlangananga kwiseli elilodwa, kodwa inyunyana eyamukelwa ngokulandelana.
Imenyu yokuqukethwe ihlanganisa
Kungenzeka ukuhlanganisa amaseli ngemenyu yokuqukethwe. Ukuze wenze lokhu, khetha amaseli ukuthi ahlanganiswe nesikhombisi, chofoza ngakwesokudla kuwo, bese ukhetha into ethi "Fomula Amaseli" kumenyu yokuqukethwe evela.
Ewindini elivuliwe lefomathi yeseli, iya kuthebhu ethi "Ukuqondanisa". Hlola ibhokisi eliseduze ne- "Hlanganisa amaseli". Lapha futhi ungabeka eminye imingcele: ukuqondiswa nokukhonjwa kombhalo, ukuqondanisa nokuvundlile okuthe mpo, ububanzi be-auto, ukugoqa kwamagama. Lapho wonke amasethingi eseqediwe, chofoza inkinobho "Kulungile".
Njengoba ubona, kwakukhona ukuhlangana kwamaseli.
Ukulahleka okungekho
Kepha kufanele wenzeni uma idatha ikhona kumaseli amaningi ahlanganisiwe, ngoba uma ihlanganiswa, wonke amanani ngaphandle kwesokunxele phezulu azolahleka?
Kukhona indlela yokuphuma kulesi simo. Sizosebenzisa umsebenzi we- "CONNECT". Okokuqala, udinga ukufaka enye iseli phakathi kwamaseli ozowaxhuma. Ukuze wenze lokhu, chofoza kwesokudla kwesokudla kweseli ukuze lihlanganiswe. Kumenyu yokuqukethwe evela, khetha into ethi "Faka ...".
Kuvulwa iwindi lapho udinga khona ukuhlela kabusha ukushintshela endaweni ethi "Faka ikholomu". Senza lokhu, bese sichofoza inkinobho "Kulungile".
Esitokisini esenziwe phakathi kwalawo maseli esizowahlanganisa, sibeka inani ngaphandle kwezingcaphuno "= CONNECT (X; Y)", lapho u-X no-Y bengabaxhumanisi bezitokisi ezixhunyiwe, ngemuva kokungeza ikholomu. Isibonelo, ukuze uhlanganise amaseli u-A2 no-C2 ngale ndlela, faka igama elithi "= CONNECT (A2; C2)" kwiseli B2.
Njengoba ubona, ngemuva kwalokho, abalingiswa esitokisini esijwayelekile "banamathela ndawonye."
Kepha manje, esikhundleni seseli elilodwa elihlanganisiwe, sinamaseli amathathu: amaseli amabili anedatha yasekuqaleni, eyodwa ahlanganisiwe. Ukwenza iseli elilodwa, chofoza kuseli elihlanganisiwe nenkinobho yegundane bese ukhetha into ethi "Kopisha" kumenyu yokuqukethwe.
Ngemuva kwalokho, siqhubekela kuseli elifanele nedatha yokuqala, bese sichofoza kukho, khetha into "yamaNani" kuzindlela zokufaka.
Njengoba ukwazi ukubona, esitokisini imininingwane yavela ukuthi ngaphambi kwalokho yayisesitokisini ngefomula.
Manje, susa ikholomu kwesokunxele equkethe iseli ngemininingwane eyinhloko, nekholomu equkethe iseli ngefomula ye-clutch.
Ngakho-ke, sithola iseli elisha eliqukethe idatha obekufanele ihlanganiswe, futhi wonke amaseli aphakathi nendawo asusiwe.
Njengoba ukwazi ukubona, uma inhlanganisela ejwayelekile yamaseli kuMicrosoft Excel ilula impela, kuzofanela unamathisele ngokuhlanganisa amaseli ngaphandle kokulahleka. Kodwa-ke, lokhu futhi kungumsebenzi ongasebenza walolu hlelo.
