Faka itafula kusuka eZwini liye kwiMicrosoft Excel

Pin
Send
Share
Send

Kaningi kufanele udlulise ithebula kusuka kuMicrosoft Excel uye kwi-Word, kunokuphikisana nalokho, kepha noma kunjalo, amacala okuphinda abuyele emuva nawo ayivelakancane. Isibonelo, kwesinye isikhathi udinga ukudlulisa itafula ku-Excel, elenziwe ngeZwi, ukuze usebenzise ukusebenza komhleli wethebula ukubala imininingwane. Ake sibheke ukuthi yiziphi izindlela zokuhambisa amatafula kule ndlela ezikhona.

I-Plain Copy

Indlela elula yokufuduka kwetafula usebenzisa indlela ejwayelekile yokukopisha. Ukuze wenze lokhu, khetha itafula ohlelweni lweZwi, chofoza ngakwesokudla ekhasini, bese ukhetha into ethi "Kopisha" kumenyu yokuqukethwe evela. Esikhundleni salokho, ungachofoza inkinobho ethi "Kopisha", ebekwe ngaphezulu kwe-ribbon. Enye inketho ibandakanya, ngemuva kokuqokomisa itafula, ukucindezela izinkinobho zekhibhodi Ctrl + C.

Ngakho-ke sakopisha itafula. Manje sidinga ukukunamathisela ekhasini lokusebenzela le-Excel. Siqala uhlelo lweMicrosoft Excel. Sichofoza esitokisini endaweni yephepha lapho sifuna ukubeka khona itafula. Kufanele kwaziwe ukuthi leli seli liba iseli eliphezulu lasokunxele kwethebula elifakiwe. Kungenxa yalokhu ukuthi kufanele siqhubeke lapho sihlela ukubekwa kwetafula.

Sichofoza kwesokudla eshidi, nakwimenyu yokuqukethwe, kukhetho lokufaka, khetha inani "Longa ukufometha kwasekuqaleni". Ungafaka futhi itafula ngokuchofoza inkinobho ethi "Faka" etholakala onqenqemeni lwesobunxele. Noma, kukhona inketho yokuthayipha isinqamuleli sekhibhodi Ctrl + V.

Ngemuva kwalokho, itafula lizofakwa ekhasini lokusebenzela leMicrosoft Excel. Amaseli aseshidi kungenzeka angahambelani namaseli asetafuleni elifakiwe. Ngakho-ke, ukwenza ukuthi itafula libukeke lilihle, kufanele linwetshwe.

Ngenisa ithebula

Futhi, kunendlela eyinkimbinkimbi kakhulu yokudlulisa itafula lisuka kwiZwi liye ku-Excel, ngokungenisa idatha.

Vula itafula ngeZwi. Khetha. Okulandelayo, iya kuthebhu ethi "Ukuhlelwa", nakwiqembu le- "Idatha" iribhoni, chofoza inkinobho ethi "Guqulela ku-Umbhalo".

Iwindi lokukhetha ukuguqula liyavula. Kuhlaka "Separator", inkinobho kufanele isethwe ku- "Tab." Uma lokhu kungenjalo, hambisa ukushintshela kulesi sikhundla, bese uchofoza inkinobho "Kulungile".

Iya kuthebhu ethi "Ifayela". Khetha into ethi "Gcina njenge ...".

Ewindini elivula, gcina idokhumenti, chaza indawo oyifunayo yefayela esizoligcina, futhi silinikeze negama uma igama elizenzakalelayo lingakwenelisi. Noma, inikezwe ukuthi ifayili eligciniwe lizoba kuphela phakathi kokudlulisa itafula lisuka eZwini liye ku-Excel, akunangqondo ukushintsha igama. Into esemqoka okufanele yenziwe ukusetha iphawundi "Umbhalo Ocacile" enkampanini "yohlobo lwefayela". Chofoza inkinobho ethi "Gcina".

Iwindi lokuguqula ifayela liyavula. Lapha awudingi ukwenza izinguquko, kepha vele ukhumbule ukufaka okubhalwe kuwo lapho ugcine umbhalo. Chofoza inkinobho ethi "Kulungile".

Ngemuva kwalokho, siqala uhlelo lweMicrosoft Excel. Iya kuthebhu ethi "Idatha". Ebhokisini le- "Get data yangaphandle" block on the ribbon, chofoza inkinobho "Kusuka umbhalo".

Kuvulwa iwindi lefayela lombhalo wokungenisa. Sifuna ifayela esiligcine ngaphambilini eZwini, silikhethe, bese sichofoza inkinobho ethi "Ngenisa".

Ngemuva kwalokho, iwindi le-Umbhalo Wizard liyavula. Kuzilungiselelo zefomethi yedatha, chaza ipharamitha "Ihlukaniswe". Setha okufakiwe kokubhaliwe ngokusho kwakho owagcina kuwo umbhalo obhalwe kwiZwi. Ezimweni eziningi, kuzoba ngu- "1251: Cyrillic (Windows)." Chofoza inkinobho ethi "Okulandelayo".

Ewindini elilandelayo, kulungiselelo elithi "Umlingisi owahlukanisayo", setha ukushintshela endaweni ethi "Tab Stop", uma ingafakwanga ngokwakhona. Chofoza inkinobho ethi "Okulandelayo".

Ewindows lokugcina le-Wizard Engumbhalo, ungafometha imininingwane ngamakholomu, unaka okuqukethwe kwabo. Sikhetha ikholomu ethile ekusekelweni kwedatha yeSampula, nakuzilungiselelo zefomathi yedatha yekholomu, khetha okukodwa kokukodwa okukodwa:

  • jikelele;
  • umbhalo
  • Usuku
  • weqa ikholamu.

Senza umsebenzi ofanayo kukholomu ngalinye ngokwehlukana. Ekupheleni kokufometha, chofoza inkinobho ethi "Qeda".

Ngemuva kwalokho, iwindi lokungenisa idatha liyavula. Ensimini, chaza ngesandla ikheli leseli, okuzoba yiseli lokugcina elingaphezulu kwesokunxele kwetafula elifakiwe. Uma ulahlekelwe ukwenza lokhu ngesandla, chofoza inkinobho ngakwesokunene sensimu.

Ewindini elivulayo, vele ukhethe iseli oyifunayo. Ngemuva kwalokho chofoza inkinobho ngakwesokunene sedatha efakwe endle.

Ukubuyela ewindini lokungenisa idatha, chofoza inkinobho "Kulungile".

Njengoba ukwazi ukubona, itafula lifakiwe.

Ngaphezu kwalokho, uma kufiswa, ungazibekela imingcele ebonakalayo, futhi uyihlele usebenzisa izindlela ezijwayelekile zeMicrosoft Excel.

Izindlela ezimbili zokudlulisa itafula ukusuka eZwini kuya ku-Excel zethulwe ngaphezulu. Indlela yokuqala ilula kakhulu kuneyesibili, futhi inqubo yonke ithatha isikhathi esincane. Ngasikhathi sinye, indlela yesibili iqinisekisa ukungabikho kwezinhlamvu ezingeziwe, noma ukuthunyelwa kwamaseli, okungenzeka lapho kudluliswa indlela yokuqala. Ngakho-ke, ukunquma inketho yokudlulisa, udinga ukuqala kusukela ekubuseni kwetafula, kanye nenhloso yalo.

Pin
Send
Share
Send