Indlela Yokuhlanganisa Amaseli ku-Excel nama-Google Spreadsheets

01 ka 01

Hlanganisa amaseli ku-Excel nama-Google Spreadsheets

Ku-Excel nama-Google Spreadsheets, iseli elihlanganisiwe lilodwa iseli elidalwe ngokuhlanganisa noma ukuhlanganisa amaseli amabili noma ngaphezulu ndawonye.

Zombili izinhlelo zinezinketho zoku:

• hlanganisa amaseli ngokuzenzekelayo
• hlanganisa amaseli ngokuqondile
• hlanganisa amangqamuzana kokubili ngokuzungeza nangemuva.

Ngaphezu kwalokho, i-Excel inenketho yokuhlanganisa idatha & isikhungo esiyisici sokufometha esivame ukusetshenziswa lapho udala izihloko noma izihloko.

Ukuhlangana kanye nendawo kwenza kube lula ukufaka izihloko ezinqumeni eziningi zamaphepha omsebenzi.

Hlanganisa i-Cell One yedatha kuphela

Hlanganisa amaseli kokubili i-Excel ne-Google Spreadsheets anomkhawulo owodwa - abakwazi ukuhlanganisa idatha kusuka kumaseli amaningi.

Uma amaseli amaningi wedatha ahlanganisiwe, kuphela idatha eseliweni eliphezulu kakhulu kwesokunxele igcinwa - yonke enye idatha izolahleka uma ukuhlanganiswa kwenzeka.

Isithenjwa seli cell for cell ehlanganisiwe yiseli ekhoneni elingenhla elingakwesokunxele lebanga elikhethiwe lokuqala noma iqembu lamaseli.

Ukuthola Ukuhlangana

Ku-Excel, ukukhetha kokuhlanganiswa kutholakala kuthebhu yaseKhaya yebhande. Isithonjana salesi sici sinesihloko esithi Ukuhlanganisa & Isikhungo, kodwa ngokuchofoza umcibisholo ophansi ngakwesokudla kwegama njengoba kuboniswe esithombeni ngenhla, imenyu yehla yezo zonke izinketho zokuhlangana zivuleka.

Ku-Google Spreadsheets, inketho yokuhlanganisa amaseli itholakala ngaphansi kwemenyu yefomethi . Isici senziwa kuphela uma amaseli amaningi aseduze akhethiwe.

Ku-Excel, uma ukuhlanganiswa & isikhungo kuvuliwe uma kuphela iseli elilodwa likhethiwe, umphumela kuphela ukuguqula ukulungiswa kweseli ukubeka isikhungo.

Indlela Yokuhlanganisa Amaseli

Ku-Excel,

1. Khetha amaseli amaningi ukuze ahlangane;
2. Chofoza kusithonjana se-Merge & Centre kuthebhu yaseKhaya yebhebhoni ukuze uhlangane amaseli bese ufaka idatha kulo lonke ibanga elikhethiwe;
3. Ukuze usebenzise enye yezinye izinketho zokuhlangana, chofoza umcibisholo ophansi eduze kwesithonjana se-Merge & Centre bese ukhetha kusuka kukho okukhethwa kukho:
   • Hlanganisa & Isikhungo;
   • Hlanganisa yonke indawo (ihlanganisa amaseli ngokuzungezile - kuwo wonke amakholomu);
   • Hlanganisa Amaseli (ahlanganisa amaseli ngokuzenzekelayo, ngokuqondile, noma kokubili);
   • Hlanganisa amaseli.

Ku-Google Spreadsheets:

1. Khetha amaseli amaningi ukuze ahlangane;
2. Chofoza kuFomathi> Hlanganisa amaseli kumamenyu ukuvula imenyu yemongo yokukhethwa kokuhlangana;
3. Khetha okukhethwa kukho okutholakalayo:
   • Hlanganisa konke (hlanganisa amaseli ngokuzenzekelayo, ngokuqondile, noma kokubili);
   • Hlanganisa ngokuzungezile;
   • Hlanganisa ngokuqondile;
   • Sula.

Ukuhlanganiswa kwe-Excel ne-Alternative

Enye indlela yokufaka idatha phakathi kwamakholomu amaningi ukusebenzisa i- Centre Across Selection esebhokisini lengxoxo yefomathi yefomathi .

Inzuzo yokusebenzisa lesi sici kunokuba ihlanganiswe & isikhungo ukuthi ayihlanganisi amaseli akhethiwe.

Ngaphezu kwalokho, uma ngaphezu kwelilodwa iseli liqukethe idatha uma isici sisetshenzisiwe, idatha kumaseli igxile kakhulu njengokushintsha ukulungiswa kweseli.

Njenge- Ukuhlangana & Isikhungo, izihloko ezisekela phakathi kwamakholomu amaningi zenza kube lula ukubona ukuthi isihloko sisebenza kulo lonke uhla.

Ukubeka isihloko noma isihloko sombhalo kumakholomu amaningi, yenza lokhu okulandelayo:

1. Khetha amaseli ebanga aqukethe umbhalo ozogxila;
2. Chofoza kuthebhu yaseKhaya yebhebhoni;
3. Esiqenjini sokuqondisa , chofoza isilawuli sebhokisi lebhokisi ukuze uvule ibhokisi lokubhalwa kwamafomu wefomathi;
4. Ebhokisini lengxoxo, chofoza kuthebhu yokuqondisa;
5. Ngaphansi kokulungiswa kombhalo , chofoza ibhokisi lohlu ngaphansi kwe- Horizontal ukubona uhlu lwezinketho ezitholakalayo;
6. Chofoza kusikhungo sokukhetha ukukhetha ukubeka umbhalo okhethiwe kuwo wonke uhla lwamaseli;
7. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Ukunciphisa kwe-Pre-Excel 2007 nokuhlanganiswa kwesikhungo

Ngaphambi kwe-Excel 2007, ukusebenzisa i-Merge & Center kungabangela izinkinga uma wenza izinguquko ezalandela endaweni ehlanganisiwe yephepha lokusebenzela .

Isibonelo, kwakungenakwenzeka ukwengeza amakholomu amasha endaweni ehlanganisiwe yephepha lokusebenzela.

Ngaphambi kokungeza amakholomu amasha, izinyathelo okumele zilandelwe ziyoba:

1. un-hlanganisa amangqamuzana okwamanje ahlangene aqukethe isihloko noma ephethe;
2. engeza amakholomu amasha kushidi lokusebenzela;
3. Phinda usebenzise ukukhetha kokuhlangana kanye nendawo.

Kusukela ku-Excel 2007 noma kunjalo, kungenzeka ukuba wengeze amakholomu engeziwe endaweni ehlanganisiwe ngendlela efanayo nezinye izindawo zeshidi ngaphandle kokulandela izinyathelo ezingenhla.