Ngokuvamile lapho usebenza namatafula ku-Microsoft Excel, kunesimo lapho udinga ukuhlanganisa amaseli amaningana. Umsebenzi awuyinkimbinkimbi kakhulu uma lawa maseli engenayo ulwazi. Kodwa kufanele benzeni uma sebevele bangene idatha? Ingabe bazobhujiswa? Ake sibone ukuthi ungahlanganisa kanjani amaseli, kuhlanganise ngaphandle kokulahleka kwedatha, ku-Microsoft Excel.
Ukuhlanganisa amaseli okulula
Noma kunjalo, sizobonisa ukuhlanganisa amaseli esebenzisa isibonelo se-Excel 2010, kodwa le ndlela ibuye ihambisane nezinye izinguqulo zalolu hlelo lokusebenza.
Ukuze uhlanganise amangqamuzana amaningana, okuyiwona kuphela agcwele idatha, noma angenalutho nhlobo, ukhethe amaseli afunayo nge-cursor. Khona-ke, kuthebhu ye-Excel "Ikhaya", chofoza isithonjana ku-"Hlanganisa Nendawo Endaweni" ibhande.
Kulokhu, amangqamuzana azohlangana, futhi yonke idatha ezokwazi ukungena esitokisini ehlanganisiwe izobekwa phakathi.
Uma ufuna idatha ibekwa ngokusho kokufometha kweseli, bese ukhetha into "Hlanganisa amaseli" ohlwini lokudonsa phansi.
Kulesi simo, ukungena okuzenzakalelayo kuzoqala kusukela ekugcineni kwesokudla kweli cell elihlanganisiwe.
Futhi, kungenzeka ukuhlanganisa amangqamuzana amaningana alayini ngomugqa. Ukuze wenze lokhu, khetha uhla olufunayo, futhi ohlwini lokudonsa phansi, chofoza inani "Hlanganisa umugqa ngomugqa".
Njengoba sibona, ngemuva kwalokhu, amangqamuzana ahlanganisiwe angene esitokisini esisodwa esivamile, kodwa avunyelwe ukujoyina umugqa ngokulayini.
Union ngokusebenzisa imenyu umongo
Kungenzeka ukuhlanganisa amaseli ngokusebenzisa imenyu yomongo. Ukwenza lokhu, khetha amangqamuzana ofuna ukuhlanganisa ne-cursor, uchofoze ngakwesokudla kubo, nasemenyu yemongo evelayo, ukhethe into ethi "Fometha amaseli".
Ewindini elisefenjini elisefenjini leselula, iya kuthebhu ethi "Ukuvumelanisa". Hlola ibhokisi "Hlanganisa amaseli". Lapha ungakwazi futhi ukusetha ezinye imingcele: isiqondiso nokuma kombhalo, ukulungiswa okuqondile nokuqondile, ukukhethwa okuzenzakalelayo kobubanzi, ukugoqa amagama. Uma zonke izilungiselelo zenziwa, chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, kwakukhona ukuhlanganiswa kwamaseli.
Ubuhlobo obungenasici
Kodwa, yini okufanele uyenze uma kukhona idatha eziningana zamaseli ahlanganisiwe, ngoba uma uhlanganisa wonke amanani ngaphandle kwesokunxele phezulu uzolahleka?
Kukhona indlela yokuphuma kule simo. Sizosebenzisa umsebenzi we- "CLUTCH". Okokuqala, udinga ukwengeza elinye iseli phakathi kwamaseli ozowaxhuma. Ukuze wenze lokhu, chofoza ngakwesokudla ngakwesokudla kwamaseli ahlanganisiwe. Emenyu yomongo evelayo, khetha into "Faka ...".
Iwindi evuleka lapho udinga khona ukuhambisa inkinobho endaweni "Engeza ikholomu". Senza lokhu, bese uchofoza inkinobho ethi "Kulungile".
Esitokisheni esakhiwe phakathi kwalawo maseli esizohlangana nawo, faka inani ngaphandle kwamacaphuno "= CHAIN (X; Y)", lapho i-X ne-Y kuyizixhumanisi zamaseli ezihlanganisiwe, ngemuva kokungeza ikholomu. Isibonelo, ukuhlanganisa amangqamuzana A2 no-C2 ngale ndlela, faka inkulumo ethi "= CLEAR (A2; C2)" ibe esitokisini B2.
Njengoba ungabona, emva kwalokhu, izinhlamvu ezisemthethweni ejwayelekile "zihlangene ndawonye."
Kodwa manje kunesitokisi esisodwa esihlanganisiwe sinemithathu: amaseli amabili anedatha yangempela, futhi eyodwa ihlanganisiwe. Ukuze wenze iseli elilodwa, chofoza iseli elihlanganisiwe nenki yegundane elilungile, bese ukhetha into "Kopisha" kwimenyu yesimo.
Khona-ke, sithuthela esiteleni esifanele nedatha yangempela, futhi ngokuchofoza kuso, khetha into ethi "Amanani" kumingcele yokufaka.
Njengoba ubona, idatha evele ivele esitokisini sefomula yabonakala kule seli.
Manje, susa ikholomu engakwesokunxele equkethe iseli nedatha eyinhloko, nekholomu equkethe iseli ngefomula yokuxhuma.
Ngakho-ke, sithola iseli elisha eliqukethe idatha okufanele ihlanganiswe, futhi wonke amaseli aphakathi nawo asusiwe.
Njengoba ubona, uma ukuhlanganiswa okuvamile kwamaseli ku-Microsoft Excel kulula, khona-ke kuzodingeka uhlolisise ngokuhlanganisa amaseli ngaphandle kokulahlekelwa. Kodwa-ke, lokhu kuyinto ephoqelekile yalolu hlelo.
