Kanjani ukuhlanganisa amafayela we-Excel kwelilodwa

Imvamisa lapho usebenza esitokisini se-tabular kwenzeka ngendlela yokuthi imininingwane edingekayo itholakala kumashidi ahlukene womsebenzi noma amafayela. Ngaphambi kwabasebenzisi, umsebenzi wokuhlanganisa amashidi amaningi namafayela kwinombolo eyodwa. Yebo, ungakwazi, ngokukopisha amaseli kusuka kudokhumenti eyodwa bese uwafaka kwelinye ifayela ukuze usebenzise inqubo yokuhlanganisa, kepha akunangqondo futhi akunangqondo futhi akunangqondo futhi akunangqondo futhi akunangqondo futhi akunangqondo futhi kungasebenzi kahle. Esikhathini esihlokweni, sizocubungula ngokuningiliziwe izindlela eziningana ezisebenzayo ezikuvumela ukuthi usebenzise ukuhlanganisa amadokhumenti etafula kube munye.

Ukuhlanganisa abasebenzi endaweni eyodwa kumhleli wethebula

Ekuqaleni, cabanga ngenqubo enjalo njengokuhlanganisa abasebenzi edokhumenti elilodwa. Imiyalo enemininingwane ibukeka kanjena:

1. Siveza ukuvulwa kwamashidi asebenzayo esihlela ukuhlanganisa kufayela elilodwa.
2. Ukuhamba esigatshaneni esinegama elithi "Ikhaya". Lapha ku-formation command block, sithola into ngaphansi kwegama elithi "hambisa noma ukopishe ishidi" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele.
3. Uhlu oluvulekile, chofoza ukhiye wesobunxele wegundane ku-"(New Book)".
4. Ngemuva kokuqaliswa kwazo zonke izenzo, sichofoza ku- "Kulungile".
5. Ukusebenza okufanayo kumele kwenziwe namanye amashidi wedokhumenti yethebula.

Inhlanganisela yolwazi kufayela elilodwa

Imvamisa kunezimo ezinjalo lapho kunesidingo sokuhlanganisa ezinye zezingcezwana zolwazi zibe yifayela elilodwa. Le nqubo yenziwa kalula usebenzisa amathuluzi wethebula. Into ebaluleke kakhulu ukuthi imininingwane etholakala ezimpawu kufanele ifomelwe kusengaphambili ukuze esikhathini esizayo ukuze kungasebenzisi isikhathi esikhulu sokubukwa okujwayelekile. Imiyalo enemininingwane ibukeka kanjena:

1. Isibonelo, sinedatha elandelayo okufanele idluliselwe kufayela elilodwa. Inqubo yale nhlangano izosebenza kahle ngaphansi komkhosi wamaphuzu athile athile. Amaqabunga asebenzayo azobhekana nenqubo yokuhlanganisa kufanele anikezwe ukufomatha okufanayo ngezihloko ezifanayo nezindlela zolwazi. Konke okunye, imininingwane ehlanganisiwe akufanele ibe nemigqa engenalutho namakholomu.

okukodwa

1. Ngemuva kokuthi silethe imininingwane evela ezicini ezahlukene zomsebenzi ukufometha umfaniswano, kudingeka sisebenzise ukwakhiwa kwephepha elisha lokusebenza. Ungakwenza lokhu ngokucindezela inkinobho yegundane kwesobunxele ekufakweni okuncane kombala omnyama, otholakala ezansi kwesixhumi esihleli setafula eduze kwamathebhu wamanye amashidi.

1. Esigabeni esilandelayo, sithuthela esigabeni esinegama elithi "idatha". Kungenzeka ukukuthola kusuka phezulu, kwimenyu enkulu yomhleli wethebula. Lapha sithola into ebizwa ngokuthi "ukuhlanganisa", bese uqhafaza kuyo ngenkinobho yegundane kwesobunxele.

2.

1. Kuhlu olusetshenzisiwe, chofoza ukhiye wesobunxele wegundane ngaphezulu kwezinto "Inani". Okulandelayo, sifaka izixhumanisi zamaseli esihlela ukuwahlanganisa.

3.

1. Izenzo ezifanayo esizikhiqizayo nolunye ulwazi esihlela ukuhlanganisa kufayela elilodwa.
2. Ngemuva kwazo zonke izenzo ezidingekayo, sichofoza ku- "Kulungile" ukuqinisekisa izinguquko ezenziwe.

okune

Ukuhlanganisa amafayela nge-vba

Ama-macros, anqunywe eVba, ahle kakhulu ukusebenzisa inqubo yokuhlanganisa amadokhumenti amaningi we-tabular abe yifayela elilodwa. Inqubo ayinzima kangako, njengoba kubonakala ekuqaleni. Into esemqoka ukulandela izinto zemiyalo enemininingwane:

1. Kuqala, kufanele uqiniseke ukuthi yonke imibhalo edingekayo yethebhulawulwa itholakala endaweni eyodwa yekhompyutha yomuntu siqu.
2. Esigabeni esilandelayo, kuyadingeka ukuya kumhleli wethebula ka-Eksel bese udala incwadi entsha kuyo, ezosebenza njengethuluzi lokuhlanganisa eminye imibhalo yamathebula.
3. Kusetshenziswa inhlanganisela ekhethekile yezinkinobho ezishisayo "Alt + F11", sithuthela ekuboneni okuyisisekelo.

isihlanu

1. Okokuqala, chofoza ku- "Namathisela", bese kufakwa ohlwini oluvelayo, chofoza ukhiye wesobunxele wegundane kwisiza segama elinegama elithi "module".
2. Manje udinga ukubhala ikhodi encane elandelayo lapha:

1. Endleleni ehlukile Kubalulekile ukubhala indlela eya endaweni yekhompyutha yomuntu siqu, equkethe amadokhumenti ethebula ukuhlanganiswa.
2. Sikhiqiza ukonga idokhumenti ye-tabular kufomethi ye- "XLSM" ukwenza kusebenze ama-macros adaliwe.
3. Senza ukwethulwa kwe-macro.
4. Silungele! Sihlanganise wonke amafayela kwifolda kudokhumenti elilodwa le-tabular.

Ukugcina

Sithole ukuthi kunezindlela eziningi zokusebenzisa ukuhlangana kwamafayela amaningi kudokhumenti elilodwa le-tabular. Sebenzisa umsebenzi obizwa nge- "Consolidation" kuphela kuphela uma amafayela aqukethe kuphela imininingwane yenombolo, ngoba umsebenzi awukwazi ukusebenza nedatha yefomethi yombhalo kahle. Indlela ephumelela kunazo zonke yokuhlanganisa amadokhumenti we-tabular ngefayela elilodwa ngaphandle kokulahlekelwa imininingwane ukusetshenziswa kolimi oluhlanganisiwe lwezinhlelo "kanye nokwenza kusebenze ama-macros akhethekile. Kodwa-ke, umsebenzisi ngamunye uzokwazi ukukhetha indlela elula yokuhlanganisa amadokhumenti ethebula.

Umlayezo wokuthi ungahlanganisa kanjani amafayela we-Excel ku-One avele kuqala kubuchwepheshe bolwazi.