Goqa umbhalo bese uhlanganisa amaseli ku-Excel

Kulesi sifundo, sizofunda izici eziwusizo ze-Microsoft Excel njengokugoqa umbhalo emigqeni kanye nokuhlanganisa amaseli amaningi abe munye. Usebenzisa le misebenzi, ungakwazi ukugoqa umbhalo emigqeni eminingi, udale izihloko zamathebula, ufake umbhalo omude emugqeni owodwa ngaphandle kokwandisa ububanzi bamakholomu, nokunye okuningi.

Ngokuvamile, okuqukethwe kungase kungavezwa ngokuphelele esitokisini, ngoba. ububanzi bayo abanele. Ezimweni ezinjalo, ungakhetha okukodwa kokubili: goqa umbhalo emigqeni noma uhlanganise amaseli amaningana ube owodwa ngaphandle kokushintsha ububanzi bekholomu.

Njengoba umbhalo usongwa, ubude bomugqa buzoshintsha ngokuzenzakalelayo, kuvumele okuqukethwe ukuthi kuvele emigqeni eminingi. Ukuhlanganisa amaseli kukuvumela ukuthi udale iseli elilodwa elikhulu ngokuhlanganisa amaningana aseduze.

Goqa umbhalo ku-Excel

Esibonelweni esilandelayo, sizosebenzisa ukugoqa umugqa kukholomu D.

  1. Khetha amaseli ofuna ukubonisa kuwo umbhalo emigqeni eminingi. Esibonelweni sethu, sizogqamisa amaseli kukholamu D.
  2. Khetha iqembu Hambisa umbhalo ithebhu Ikhaya.
  3. Umbhalo uzogoqa umugqa ngomugqa.

Phusha umyalo Hambisa umbhalo futhi ukukhansela ukudluliswa.

Ukuhlanganisa amaseli ku-Excel

Uma amaseli amabili noma ngaphezulu ehlanganiswa, iseli eliwumphumela lithatha indawo yeseli elihlanganisiwe, kodwa idatha ayengezwa ndawonye. Ungakwazi ukuhlanganisa noma yibuphi ububanzi obuseduze, ngisho nawo wonke amaseli eshidini, nolwazi kuwo wonke amaseli ngaphandle kwephezulu kwesokunxele luzosuswa.

Esibonelweni esingezansi, sizohlanganisa ububanzi A1:E1 ukuze sakhe isihloko seshidi lethu.

  1. Khetha amaseli ofuna ukuwahlanganisa.
  2. Phusha umyalo Hlanganisa futhi ubeke phakathi nendawo ithebhu Ikhaya.
  3. Amaseli akhethiwe azohlanganiswa abe elilodwa, futhi umbhalo uzobekwa phakathi nendawo.

Inkinobho Hlanganisa futhi ubeke phakathi nendawo isebenza njengeswishi, okungukuthi ukuyichofoza futhi kuzokhansela ukuhlanganisa. Idatha esusiwe ngeke itholwe.

Izinketho Eziningi Zokuhlanganisa Amaseli ku-Excel

Ukuze ufinyelele izinketho ezengeziwe zokuhlanganisa amaseli, chofoza umcibisholo oseduze nesithonjana somyalo Hlanganisa futhi ubeke phakathi nendawo. Kuzovela imenyu yokudonsela phansi, enemiyalo elandelayo:

  • Hlanganisa bese Umaphakathi: Ihlanganisa amaseli akhethiwe abe elilodwa bese ibeka okuqukethwe phakathi nendawo.
  • Hlanganisa ngemigqa: Ihlanganisa amaseli ngomugqa, okungukuthi iseli elihlukile liyakhiwa emugqeni ngamunye wobubanzi obukhethiwe.
  • Hlanganisa amaseli: Ihlanganisa amaseli kwelinye ngaphandle kokubeka okuqukethwe phakathi nendawo.
  • Susa ukuhlanganisa amaseli: Ikhansela inyunyana.

shiya impendulo