Ungahlanganisa kanjani imigqa ku-Excel. Ukuhlanganisa, ukuhlanganisa ngaphandle kokulahlekelwa idatha, ukuhlanganisa ngaphakathi kwemingcele yethebula

Ngenkathi usebenza namadokhumenti ezimweni eziningi, kuyadingeka ukushintsha ukwakheka kwawo. Okuhlukile okudumile kwale nqubo ukuhlangana kwemigqa. Ngaphezu kwalokho, kunenketho yokuqoqa imigqa eseduze. Kulesi sihloko, sizocubungula ngosizo lokuthi yiziphi izindlela ezingenzeka zokwenza lezi zinhlobo zokuhlanganisa ngaphakathi kohlelo lwe-Excel.

Izinhlobo zokuhlanganisa

Ngezikhathi ezithile, umsebenzisi osebenza kusihleli sespredishithi se-Excel unesidingo sokuhlanganisa amakholomu kudokhumenti. Kwabanye, lokhu kuzoba umsebenzi olula ongaxazululwa ngokuchofoza okukodwa kwegundane, kwabanye kuzoba yinkinga enzima. Zonke izindlela zokuhlanganisa amakholomu ku-Excel zingahlukaniswa ngamaqembu ama-2, ahluke ngomgomo wokuqalisa. Ezinye zibandakanya ukusetshenziswa kwamathuluzi okufometha, ezinye zisebenzisa imisebenzi yomhleli. Uma kukhulunywa ngobulula bomsebenzi, umholi ongenambangi uzoba yiqembu elingu-1 ngqo. Nokho, hhayi kuzo zonke izimo, usebenzisa izilungiselelo zokufometha, kungenzeka ukufeza imiphumela oyifunayo.

Indlela 1: ukuhlanganisa ngefasitela lefomethi

Ekuqaleni, udinga ukufunda ukuhlanganisa izakhi ezingaphakathi komugqa usebenzisa ibhokisi lefomethi. Kodwa-ke, ngaphambi kokuqala inqubo ngokwayo, kuyadingeka ukuthi ukhethe imigqa eseduze ehlelelwe ukuhlanganisa.

• Ukuze ukhethe imigqa edinga ukuhlanganiswa, kungenzeka ukusebenzisa amaqhinga angu-2. Okokuqala: bamba i-LMB bese udweba emigqeni - ukukhetha kuzokwenzeka.

• Okwesibili: kuleli phaneli, futhi uchofoze i-LMB kusici sokuqala esisemgqeni okufanele sihlanganiswe. Okulandelayo - emgqeni wokugcina, ngalesi sikhathi udinga ukubamba "Shift". Lonke igebe eliphakathi kwale mikhakha emi-2 liyagqanyiswa.

• Uma igebe olifunayo limakwa, inqubo yokuqoqa ingaqala. Ngalezi zinhloso, i-RMB ichofozwa noma yikuphi ebangeni elishiwo. Kuvela imenyu, ilandelwe yisigaba esithi Fometha Amaseli.

• Ngemva kwalokho, udinga ukuvula imenyu yokufometha. Udinga ukuvula ingxenye ethi "Ukuqondanisa". Ngaphezu kwalokho, kokuthi “Bonisa” uphawu lusethwa eduze nesibonisi esithi “Hlanganisa Amaseli”. Bese ucindezela inkinobho ethi "KULUNGILE" ezansi kwefasitela.

• Izinto ezimakwe emgqeni zibe sezihlanganiswa. Ukuhlangana kwama-elementi ngokwawo kuzokwenzeka kuyo yonke idokhumenti.

Qaphela! Ukufeza umphumela oyifunayo, ezinye izindlela zokushintshela efasiteleni lokufometha zingasetshenziswa. Isibonelo, ngemuva kokukhetha imigqa, udinga ukuvula imenyu ethi "Ekhaya", bese uchofoza okuthi "Fometha", etholakala kubhulokhi elithi "Amaseli". Ohlwini oluzivelelayo kukhona “Fometha Amaseli …”.

Ngaphezu kwalokho, kumenyu ethi "Ekhaya", ungachofoza kumcibisholo otshekile otholakala kubhebhoni kwesokudla ngezansi kwesigaba esithi "Ukuqondanisa". Esimeni esinjalo, ukuguqulwa kwenziwa kubhulokhi ethi "Ukuqondanisa" yewindi lokufometha ngokwalo. Ngenxa yalokhu, awudingi ukushintsha phakathi kwamathebhu.

Futhi, ukushintshela efasiteleni elifanayo kungenzeka ngokucindezela inhlanganisela yezinkinobho ezishisayo "Ctrl + 1", uma izakhi ezidingekayo zikhethiwe. Nokho, kulesi simo, uguquko lwenziwa kuthebhu ethi “Fometha Amaseli” egcine ukuvakashelwa.

Ngezinye izinketho zoshintsho ezihlukahlukene, imisebenzi elandelayo yokuhlanganisa izici ezisemgqeni yenziwa ngokuvumelana ne-algorithm echazwe ngenhla.

Indlela yesi-2: Ukusebenzisa Amathuluzi ku-Ribbon

Ngaphezu kwalokho, kungenzeka ukuhlanganisa imigqa usebenzisa inkinobho ekwibha yamathuluzi.

• Okokuqala, sikhetha imigqa edingekayo. Okulandelayo, udinga ukuya kumenyu "Ekhaya" bese uchofoza okuthi "Hlanganisa futhi ubeke phakathi." Ukhiye utholakala esigabeni esithi "Ukuqondanisa".

• Lapho sekuqediwe, uhla olushiwo lwemigqa luxhunywe ekugcineni kwedokhumenti. Lonke ulwazi olufakwe kulo mugqa ohlanganisiwe luzotholakala phakathi.

Nokho, akumele neze kuzo zonke izimo idatha ibekwe phakathi. Ukuze ubenze babe nefomu elijwayelekile, kwenziwa i-algorithm elandelayo:

• Imigqa ezohlanganiswa igqanyisiwe. Vula ithebhu ethi Ikhaya, chofoza unxantathu otholakala kwesokudla kokuthi Hlanganisa futhi Phakathi, khetha Hlanganisa Amaseli.

• Ilungile! Imigqa ihlanganiswe ibe munye.

Indlela yesi-3: ukuhlanganisa imigqa ngaphakathi kwetafula

Nokho, akudingekile ngaso sonke isikhathi ukuhlanganisa izici ezisemgqeni kulo lonke ikhasi. Ngokuvamile inqubo yenziwa ohlwini oluthile lwetafula.

• Igqamisa izici zomugqa kudokhumenti okudingeka zihlanganiswe. Lokhu kungenziwa ngezindlela ezi-2. Eyokuqala iwukuba ubambe phansi i-LMB bese uzungeza yonke indawo edinga ukukhethwa ngekhesa.

• Indlela yesibili izoba lula enqubweni yokuhlanganisa uhlu olubalulekile lolwazi emgqeni ongu-1. Kudingeka ukuthi uchofoze ngokushesha into yokuqala ye-span ezohlanganiswa, bese, ngenkathi ubambe "Shift", kwesokudla esingezansi. Kungenzeka ukushintsha ukuhleleka kwezenzo, umphumela uzofana.

• Lapho ukukhetha kwenziwa, kufanele udlule kwenye yezindlela ezingenhla uye efasiteleni lokufometha. Lenza izenzo ezifanayo. Imigqa engaphakathi kwedokhumenti ibe isihlanganiswa. Ulwazi olutholakala phezulu kwesokunxele kuphela oluzogcinwa.

Ukuhlanganisa ngaphakathi kwedokhumenti kungenziwa ngokusebenzisa amathuluzi akuribhoni.

• Imigqa edingekayo kudokhumenti igqanyiswe ngenye yezinketho ezingenhla. Okulandelayo, kuthebhu ethi “Ekhaya”, chofoza okuthi “Hlanganisa futhi ubeke phakathi nendawo.”

• Noma unxantathu otholakala kwesokunxele sokhiye uyachofozwa, ngokuchofoza okunye kokuthi "Hlanganisa Amaseli".

• Ukuhlanganisa kwenziwa ngokuhambisana nohlobo olukhethwe umsebenzisi.

Indlela yesi-4: Ukuhlanganisa ulwazi emigqeni ngaphandle kokulahlekelwa idatha

Izindlela zokuqoqa ezingenhla zicabanga ukuthi ekupheleni kwenqubo, lonke ulwazi olusezicini ezicutshunguliwe luyabhujiswa, ngaphandle kwalolo olutholakala engxenyeni engenhla kwesokunxele yobubanzi. Kodwa-ke, kwezinye izimo kuyadingeka ukuhlanganisa amanani asezindaweni ezihlukene zedokhumenti ngaphandle kokulahlekelwa. Lokhu kungenzeka ngomsebenzi owusizo kakhulu we-CONCATENATE. Umsebenzi ofanayo ubhekiselwa ekilasini lama-opharetha ombhalo. Isetshenziselwa ukuhlanganisa imigqa eminingi ibe yisici esingu-1. I-syntax yomsebenzi onjalo ibonakala kanje: =CONCATENATE(umbhalo1,umbhalo2,…).

Kubalulekile! Izimpikiswano zebhulokhi "Yombhalo" ziwumbhalo ohlukile noma izixhumanisi zama-elementi lapho utholakala khona. Indawo yokugcina isetshenziselwa ukuqalisa inkinga ezoxazululwa. Kungenzeka ukusebenzisa izimpikiswano ezinjalo ezingama-255.

Sinetafula lapho kuboniswa khona uhlu lwemishini yekhompyutha enezindleko. Umsebenzi kuzoba ukuhlanganisa yonke idatha kukholomu “Yedivayisi” ibe into engu-1 engalahleki emgqeni.

• Sibeka ikhesa noma yikuphi kudokhumenti lapho umphumela uboniswa khona, bese uchofoza okuthi “Faka Umsebenzi”.

• Vula "Isilekeleli Somsebenzi". Udinga ukuya ku-"Text" block. Bese sithola bese ukhetha "XHUMANA", ngemva kwalokho sicindezela inkinobho "OK".

• Iwindi lezilungiselelo ze-CONCATENATE lizovela. Ngenani lezingxabano, kungenzeka ukusebenzisa amafomu angama-255 anegama elithi "Umbhalo", noma kunjalo, ukuxazulula inkinga enjalo, inani lemigqa elisetafuleni liyadingeka. Esimweni esithile, kukhona angu-6 kubo. Setha isikhombi ku-"Text1" futhi, ubambe i-LMB, chofoza into yokuqala, equkethe igama lomkhiqizo kukholamu "Idivayisi". Ikheli lento libe selivezwa ebhokisini lewindi. Ngokufanayo, amakheli ezinto ezilandelayo afakwe ezinkambini "Text2" - "Text6". Ngaphezu kwalokho, lapho amakheli ezinto eboniswa ezinkambu, chofoza inkinobho ethi "KULUNGILE".

• Uhlelo lubonisa lonke ulwazi emugqeni ongu-1. Kodwa-ke, njengoba ubona, alikho igebe phakathi kwamagama ezimpahla ezihlukahlukene, eziphikisana nezimo eziyinhloko zenkinga. Ukuze ufake isikhala phakathi kwamagama emikhiqizo ehlukene, khetha i-elementi ehlanganisa ifomula, bese uchofoza okuthi “Faka Umsebenzi”.

• Iwindi lezimpikiswano lizovuleka. Kuwo wonke amafreyimu ewindi avelayo, ngaphezu kweyokugcina, engeza: & “”
• Isisho okukhulunywa ngaso sisebenza njengohlamvu lwesikhala somsebenzi we-CONCATENATE. Ngakho-ke, asikho isidingo sokuyifaka ensimini 6. Lapho inqubo isiqediwe, inkinobho ethi "KULUNGILE" icindezelwa.

• Ngaphezu kwalokho, ungaqaphela ukuthi lonke ulwazi lubekwe emgqeni ongu-1, futhi luhlukaniswa yisikhala.

Kukhona futhi enye indlela yokuhlanganisa ulwazi oluvela emigqeni eminingana ngaphandle kokulahlekelwa ulwazi. Ngalezi zinhloso, uzodinga ukufaka ifomula evamile.

• Sibeka uphawu "=" emgqeni lapho umphumela uboniswa khona. Sichofoza inkambu yokuqala kukholamu. Uma ikheli liboniswa kubha yefomula, sithayipha inkulumo elandelayo: & “” &

Bese sichofoza isici sesi-2 kukholamu bese sifaka inkulumo eshiwo futhi. Ngendlela efanayo, amaseli asele azocutshungulwa, ulwazi okufanele lubekwe emugqeni ongu-1. Esimeni esithile, inkulumo elandelayo izotholakala: =A4&” “&A5&” “&A6&” “&A7&” “&A8&” “&A9.

• Ukuze ubonise umphumela kusiqapha, cindezela "Enter".

Indlela yesi-5: ukuhlanganisa

Ngaphezu kwalokho, kungenzeka ukuhlanganisa imigqa ngaphandle kokulahlekelwa isakhiwo sabo. I-algorithm yesenzo.

• Ekuqaleni, kukhethwa imigqa eseduze okudingeka ihlanganiswe. Kungenzeka ukukhetha izakhi ezihlukene emigqeni, hhayi umugqa wonke. Khona-ke kunconywa ukuya esigabeni "Idatha". Chofoza inkinobho ethi “Iqembu” etholakala kubhulokhi ethi “Isakhiwo”. Ohlwini lwezikhundla ezi-2 ezivelayo, khetha "Iqembu ...".

• Khona-ke udinga ukuvula iwindi elincane lapho ukhetha khona lokho okufanele kuqoqwe ngokuqondile: imigqa noma amakholomu. Njengoba udinga ukuhlanganisa imigqa, sibeka inkinobho endaweni edingekayo bese uchofoza "Kulungile".

• Uma isenzo sesiqediwe, imigqa eseduze eshiwo izoqoqwa. Ukuze ufihle iqembu, udinga ukuchofoza kusithonjana sokususa esitholakala kwesokunxele sebha yokuxhumanisa.

• Ukuze ubonise imigqa ehlanganisiwe futhi, udinga ukuchofoza uphawu "+" oluvela lapho uphawu "-" lwaluvame ukuba khona.

Ukuhlanganisa izintambo namafomula

Umhleli we-Excel unikeza amafomula athile ukusiza ulwazi lweqembu oluvela emigqeni ehlukene. Indlela elula yokusebenzisa ifomula iwumsebenzi we-CONCATENATE. Ezinye izibonelo zokusebenzisa ifomula:

Imigqa yokuqoqa nokuhlukanisa inani ngokhefana:

1. =CONCATENATE(A1,”, «,A2,», «,A3).
2. =XHUMANA(A1;», «;A2;», «;A3).

Iqoqa iyunithi yezinhlamvu, ishiya izikhala phakathi kwamanani:

1. =CONCATENATE(A1,» «,A2,» «,A3).
2. =XHUMANA(A1; “;A2;” “;A3).

Ukuqoqa ama-elementi asemgqeni ngaphandle kwezikhala phakathi kwamanani:

1. =CONCATENATE(A1,A2,A3).
2. =XHUMANA(A1;A2;A3).

Kubalulekile! Isidingo esiyinhloko sokwakhiwa kwefomula ecatshangelwayo ukuthi kuyadingeka ukuthi kubhalwe phansi zonke izakhi okufanele ziqoqwe zihlukaniswe ngokhefana, bese ufaka isihlukanisi esidingekayo phakathi kwazo ngamamaki okucaphuna.

Isiphetho

Izindlela zokuqoqa imigqa zikhethwa kubhekwa ukuthi hlobo luni lokuqoqa oludingeka ngqo, nokuthi yini okuhlelwe ukuthi itholakale ngenxa yalokho. Kungenzeka ukuhlanganisa imigqa kuze kube sekupheleni kwedokhumenti, ngaphakathi kwemingcele yetafula, ngaphandle kokulahlekelwa kolwazi usebenzisa umsebenzi noma ifomula, imigqa yeqembu. Ngaphezu kwalokho, kunezindlela ezihlukene zokuxazulula le nkinga, kodwa kuphela okuthandwayo komsebenzisi okuzothinta ukukhetha kwabo.