Enye yezinto ezithakazelisayo neziwusizo ku-Excel yikhono lokuhlanganisa amaseli amabili noma ngaphezulu abe munye. Lesi sici sinesidingo ngokukhethekile lapho udala izihloko nama-caps wethebula. Nakuba, ngezinye izikhathi lisetshenziswa ngisho ngaphakathi ngaphakathi kwetafula. Ngesikhathi esifanayo, kubalulekile ukucabangela ukuthi uma uhlanganisa izakhi, ezinye imisebenzi ziyeka ukusebenza kahle, isibonelo, ukukhetha. Kukhona nezinye izizathu eziningi ngenxa yokuthi umsebenzisi uthatha isinqumo sokunqamula amangqamuzana ukuze akhe isakhiwo setafula ngokuhlukile. Qala ukuthi yiziphi izindlela ongazenza lokhu.
Ukuxhuma amaseli
Inqubo yokwehliswa kwamaseli iyinto ehlukile yokuhlanganisa nabo. Ngakho-ke, ngamazwi alula, ukuze ufeze, kubalulekile ukukhansela lezo zenzo ezenziwa ngesikhathi sokuhlanganiswa. Into eyinhloko ukuqonda ukuthi kuphela iseli elihlanganisa izakhi eziningana ezihlangene ngaphambilini zingahlukaniswa.
Indlela 1: Ifomathi Yokufometha
Abasebenzisi abaningi bajwayele ukwenza inqubo yokuhlanganiswa efasiteleni lokufometha nokuguqulwa lapho ngokusebenzisa imenyu yomongo. Ngenxa yalokho, bazophinde bahlukane.
- Khetha iseli elihlanganisiwe. Chofoza inkinobho yesokudla yegundane ukubiza imenyu yesimo. Kulolu hlu oluvula, khetha into "Fometha amaseli ...". Esikhundleni salezi zenzo, ngemuva kokukhetha isici, ungamane uthayiphe inhlanganisela yezinkinobho kukhibhodi Ctrl + 1.
- Ngemuva kwalokho, iwindi lokufometha idatha liqalisiwe. Hambisa kuthebhu "Ukuqondanisa". Ebhokisini lesethingi "Bonisa" phenya ipharamitha "Ukuhlanganiswa Kwamaselula". Ukufaka isenzo, chofoza inkinobho. "Kulungile" phansi kwefasitela.
Emva kwalezi zenzo ezilula, iseli lapho umsebenzi owenziwe khona uzohlukaniswa zibe yizici zayo ezizimele. Kulesi simo, uma idatha igcinwe kuyo, khona-ke bonke bazobe bekhona engxenyeni engenhla kwesokunxele.
Isifundo: Ukufometha amathebula we-Excel
Indlela 2: inkinobho ku-ribbon
Kodwa ngokushesha kakhulu futhi kulula, ngokuqondile ngokuchofoza okukodwa, ungenza ukwahlukana kwezakhi ngokusebenzisa inkinobho ebhethini.
- Njengendlela yangaphambilini, okokuqala, kudingeka ukhethe iseli elihlangene. Bese eqenjini lamathuluzi "Ukuqondanisa" kwi-tape chofoza inkinobho "Hlanganisa futhi ubeke phakathi".
- Kulokhu, naphezu kwegama, ngemuva kokucindezela inkinobho, okungafani kuyokwenzeka: izakhi zizoxhunyiwe.
Eqinisweni, yilapho zonke izinketho zokunqamula i-cell ziphela. Njengoba ubona, kunezinhlobo ezimbili kuphela: ifasitela yokufometha kanye ne-inkinobho ku-tape. Kodwa lezi zindlela zanele ukufeza okusheshayo nokulula kwalenqubo engenhla.
