Okuqukethwe
Isici sokuhlukanisa amaseli siyadingeka phakathi kwabasebenzisi okufanele bahlale besebenza ngamatafula. Bangasebenzisa izinhlobonhlobo zokufometha ukuze bathwebule inombolo enkulu yamaseli, abuye ahlanganiswe ukuze enze izindawo ezivamile zolwazi. Uma ipuleti elinjalo lidalwe ngumsebenzisi ngokwakhe, khona-ke ngeke kube nezinkinga ngokunqanyulwa. Okuyinkimbinkimbi kakhulu isimo lapho umsebenzisi kufanele asebenze nethebula eselifomethiwe kakade.
Kodwa ungajahi ukucasuka, kulesi sihloko sizocabangela izindlela ezimbili ezitholakalayo zokunqamula. Enye igxile ekusebenziseni kalula imisebenzi yohlelo, enye iklanyelwe ukusebenzisa iphaneli enamathuluzi amakhulu.
Izici zokuhlukaniswa kwamaseli
Njengoba le nqubo iwukuhlanekezela kwenqubo yokuhlanganisa, ukuze yenziwe, kwanele ukuhlehlisa uchungechunge lwezenzo ezenziwe lapho zihlanganiswa.
Nakani! Lokhu kungenzeka kukhona kuphela kuseli eliqukethe izinto ezimbalwa ezihlanganiswe ngaphambilini.
Indlela 1: Izinketho Efasiteleni Lokufometha
Abasebenzisi abaningi baphawule ukuthi bathanda ukusebenzisa Fometha Amaseli ukuze bahlanganise amaseli. Kodwa-ke, kule menyu kuzokwazi ukunqamula ngaphandle kwezinkinga, kwanele ukulandela izincomo ezilandelayo:
- Isinyathelo sokuqala ukukhetha iseli elihlanganisiwe. Bese uchofoza kwesokudla kuyo ukuze uveze imenyu yokuqukethwe, ngesikhathi esifanayo uye engxenyeni ethi “Fometha Amaseli”. Inketho efanayo yokubiza imenyu eyengeziwe ukusebenzisa isinqamuleli sekhibhodi "Ctrl + 1".
- Ewindini elivelayo, kufanele uye ngokushesha engxenyeni ethi "Ukuqondanisa", unake ingxenye ethi "Display". Kuyo ungabona uphawu oluphambene nento ethi “Hlanganisa amaseli”. Kuhlala kuphela ukususa umaki nokuhlola umphumela.
- Ngemva kokuqeda izinyathelo, ungabona ukuthi iseli libuyisele ukufometha kwasekuqaleni, futhi manje selihlukaniswa libe amaseli amaningana. Amaseli ahlanganisiwe anoma yimuphi usayizi anganqanyulwa ngale ndlela.
Kubalulekile! Ukhiye walokhu kufometha uwukufuna ulwazi olushiwo kuseli elihlanganisiwe. Ngokuzenzakalelayo, yonke idatha izothuthelwa kuseli engenhla kwesokunxele, kungakhathaliseki inani lombhalo noma olunye ulwazi olushiwo kuyo.
Indlela yesi-2: Amathuluzi eRibhoni
Manje kufanele unake izinketho eziningi zendabuko zokuhlukanisa amaseli. Ukuze wenze lokhu, kuzokwanela ukwethula uhlelo lwe-Excel, uvule ithebula elidingekayo bese wenza lezi zinyathelo ezilandelayo:
- Isinyathelo sokuqala ukukhetha iseli elihlanganisiwe. Bese uye esigabeni esithi "Ekhaya" kubha yamathuluzi eyinhloko, lapho udinga ukusebenzisa isithonjana esikhethekile entweni ethi "Ukuqondanisa", okuyiseli elinomcibisholo okabili.
- Njengomphumela wezenzo ezithathiwe, kuzokwazi ukuhlukanisa amaseli futhi ubone ukuthi umphumela ucishe ufane nalokho okutholwe ngemva kokusebenzisa indlela yokuqala.
Qaphela! Uma uthi nhlá, kungase kubonakale sengathi izindlela zicishe zifane, kodwa kunomehluko owodwa obalulekile okufanele ugcizelelwe. Isibonelo, uma unquma ukusebenzisa indlela yokuqala, umbhalo ogcinwe kuseli engenhla kwesokunxele uzoba nokuqondanisa okuqondile nokuvundlile. Futhi uma usebenzisa indlela yesibili, khona-ke ukuqondanisa kombhalo kuzoba mpo kuphela.
Isiphetho
Manje usunazo zonke izindlela ezitholakalayo zokunqamula amaseli. Sicela uqaphele ukuthi indlela yesi-2 ifaneleka kakhulu futhi idingeka kakhulu, kodwa ezinguqulweni ezintsha ze-Excel kuphela. Iqiniso liwukuthi ezinguqulweni ezintsha zohlelo, isigaba "Ekhaya" sivula ngokuzenzakalelayo. Futhi ungasebenzisa cishe ngokushesha isithonjana esifanayo sokunqamula ngaphandle kokusebenzisa noma yikuphi okunye ukukhohlisa.