Enye yezinto ezithokozisayo neziwusizo ku-evecle yikhono lokuhlanganisa amaseli amabili noma ngaphezulu abe munye. Lesi sici sifunwa ikakhulukazi lapho sidala izihloko nezihloko zetafula. Noma, kwesinye isikhathi kusetshenziswa ngisho nasetafuleni. Ngasikhathi sinye, udinga ukubheka ukuthi lapho uhlanganisa izinto, eminye imisebenzi iyayeka ukusebenza kahle, ngokwesibonelo, ukuhlunga. Futhi kunezinye zezinye izizathu, ngenxa yokuthi umsebenzisi uzoxazulula ukunqamula amaseli ukwakha isakhiwo setafula ngendlela ehlukile. Sithola ukuthi yiziphi izindlela ezingenziwa.
Ukuxhumeka kwamaseli
Inqubo yokuxhuma amaseli okuxhumanisa yi-inverse inyunyana yabo. Ngakho-ke, ngamazwi alula, ukukwenza, udinga ukukhansela isenzo esenziwa lapho sibumbene. Into esemqoka ukuqonda ukuthi kuphela iseli eliqukethe izinto eziningi ezihlanganisiwe ngaphambili linganqanyulwa.Indlela 1: Ukufomatha Window
Abasebenzisi abaningi basetshenziselwa ukukhiqiza inqubo yokuhlanganisa ewindini lokufometha ngokushintshwa lapho kungena ngemenyu yokuqukethwe. Ngakho-ke, futhi anqamule nabo.
- Khetha iseli elihlanganisiwe. Chofoza ngokuchofoza kwesokudla ukuze ushayele imenyu yokuqukethwe. Uhlu oluvula, khetha into "ifomethi yeseli ...". Esikhundleni salezi zenzo, ngemuva kokukhetha into, ungamane ushayele inhlanganisela yezinkinobho kukhibhodi ye-CTRL + 1.
- Ngemuva kwalokho, iwindi lokufometha idatha liyaqalwa. Dlulela kuthebhu "yokuqondanisa". Ku-Izilungiselelo ze- "Display" Vimbela izilungiselelo, susa ibhokisi lokuhlola kusuka kupharamitha "eCorging". Ukuze usebenzise isenzo, chofoza inkinobho ethi "Kulungile" ezansi kwewindi.
Ngemuva kwalezi zenzo ezilula, iseli lapho ukusebenza kwenziwa khona kuzohlukaniswa ngezingxenye zezinto zalo. Ngasikhathi sinye, uma idatha igcinwe kuyo, ngakho-ke bonke bayoba sento engenhla yangakwesobunxele.
Isifundo: Ukufomatha amatafula ku-Excel
Indlela 2: Inkinobho ku-Ribbon
Kepha ngokushesha okukhulu futhi okulula, ngokoqobo ngokuchofoza okukodwa, ungahlukanisa izinto ngenkinobho ku-ribbon.
- Njengasendleleni edlule, okokuqala, udinga ukugqamisa iseli ehlanganisiwe. Bese kuthi "i-Alignment" ithuluzi le-Tool Group ethepheni, sichofoza ku- "Hlola bese ubeka enkabeni".
- Kulokhu, naphezu kwegama, ngemuva kokucindezela inkinobho, isenzo sokubuyela emuva sizokwenzeka: Izinto zizonqanyulwa.
Empeleni, zonke izinketho zokuxhuma amaseli nokuphela. Njengoba ubona, kukhona ezimbili zazo kuphela: iwindi lokufomatha kanye nenkinobho ethepheni. Kepha lezi zindlela zanele ngokuzibophezela okusheshayo nokulula kule nqubo engenhla.