Ngokuvamile, kufanele udlulise itafula kusuka ku-Microsoft Excel kuya eZwini, kunokuba uhambisane naso, kodwa namanje amacala okudluliswa okungahambisani nawo ayengavamile kakhulu. Isibonelo, ngezinye izikhathi udinga ukudlulisela itafula ku-Excel, eyenziwe ku-Word, ukuze usebenzise umhleli wethebula ukubala idatha. Ake sizithole ukuthi yiziphi izindlela zokudlulisela amatafula kulezi ziqondiso zikhona.
Ikhophi evamile
Indlela elula yokudlulisela itafula isebenzisa indlela yokwenza ikhophi evamile. Ukuze wenze lokhu, khetha ithebula eZwini, chofoza ngakwesokudla ekhasini, bese ukhetha into ethi "Kopisha" emenyu yemongo ebonakalayo. Ungakwazi, chofoza, chofoza inkinobho ethi "Kopisha", etholakala phezulu kwetheyipu. Enye inketho iqala, ngemuva kokukhetha ithebula, ngokucindezela i-Ctrl + C ekhibhodi.
Ngakho sikopishe itafula. Manje kudingeka siyinamathisele efelini le-Excel. Run Microsoft Excel. Sichofoza esitokisini endaweni lapho sifuna ukubeka khona itafula. Kumele kuqashelwe ukuthi le seli liyoba iseli eliphezulu elingenhla etafuleni efakwe. Kulokhu kubalulekile ukuqhubeka uma uhlela ukubekwa kwetafula.
Chofoza inkinobho yesokudla yegundane kushidi, futhi kumenyu yesimo sokungena kokukhethwa kukho, khetha inani "Londoloza ukufometha kwangempela". Futhi, ungafaka itafula ngokuchofoza inkinobho ethi "Faka" ehlangothini lwesobunxele lwebhande. Ngaphandle kwalokho, kukhona okukhethwa kukho ukuthayipha inhlanganisela yokhiye Ctrl + V ekhibhodi.
Emva kwalokho, itafula lizofakwa eshadini le-Microsoft Excel. Amaseli weshidi angeke afane namaseli kuthebula elifakiwe. Ngakho-ke, ukwenza ithebula libukeke libonakala kahle, kufanele lithelwe.
Ngenisa ithebula
Futhi, kunendlela eyinkimbinkimbi yokudlulisela itafula kusuka ku-Word kuya ku-Excel, ngokungenisa idatha.
Vula ithebula ku-Word program. Khetha it. Okulandelayo, iya kuthebhu ethi "Ukuhlelwa", futhi ku-"Idatha" yamathuluzi ku-tape, chofoza inkinobho ethi "Guqula kuya kumbhalo".
Ifasitela yezilungiselelo zokuguqula zivula. Kwimikhawulo ye "Separator", umshini kufanele usethe esimweni "sokubheka". Uma kungenjalo, susa inkinobho kule ndawo, bese uchofoza inkinobho ethi "Kulungile".
Yiya kuthebhu ethi "Ifayela". Khetha into "Londoloza njengo ...".
Ewindini elondolozwe idokhumenti evuliwe, cacisa indawo oyifunayo yefayela esizoyilondoloza, futhi sinikeze igama uma igama elizenzakalelayo linganelisi. Nakuba, kunikezwe ukuthi ifayela elilondoloziwe lizobe liphakathi kuphela ukudlulisela itafula kusuka ku-Word kuya ku-Excel, asikho isizathu esikhethekile sokushintsha igama. Into eyinhloko okufanele uyenze ukusetha ipharamitha "Umbhalo ophansi" kufomini "Uhlobo lwefayela". Chofoza inkinobho ethi "Londoloza".
Iwindi yokuguqulwa kwefayela ivuleka. Asikho isidingo sokwenza izinguquko, kodwa kufanele ukhumbule ukufaka ikhodi lapho ugcina khona umbhalo. Chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, sebenzisa i-Microsoft Excel. Yiya kuthebhu "Idatha". Ebhokisini lesethingi "Thola idatha yangaphandle" ku-tape chofoza inkinobho "Kusuka embhalweni."
Iwindi lefayela lokungenisa ifayela livula. Sifuna ifayela eligcinwe ngaphambilini eZwini, ukhethe, bese uchofoza inkinobho ethi "Ngenisa".
Emva kwalokhu, iwindi leWebhu leWebhu livula. Kuzilungiselelo zesakhiwo sedatha, cacisa ipharamitha ethi "Delimited". Setha ikhodidi ngokuya kulowo ogcine khona idokhumenti yombhalo ku-Word. Ezimweni eziningi, kuzoba "ngu-1251: i-Cyrillic (iWindows)." Chofoza inkinobho ethi "Okulandelayo".
Ewindini elilandelayo, ku-"I-Symbol-delimiter" ukulungiselelwa, setha inkinobho endaweni "Yokumisa", uma ingasethiwe ngokuzenzakalelayo. Chofoza inkinobho ethi "Okulandelayo".
Ewindini lokugcina leWebhu Yesevisi, ungafometha idatha emakholomu, ucabange okuqukethwe kwabo. Khetha ikholomu ethize ku-Data Sampuli, nakuzilungiselelo zefomathi yedatha yekholomu, khetha eyodwa yezinketho ezine:
- okuvamile;
- umbhalo;
- usuku;
- weqa ikholomu.
Senza ukufana okufanayo kukholomu ngayinye ngokwehlukana. Ekupheleni kokufometha, chofoza inkinobho ethi "Qedela".
Ngemuva kwalokho, iwindi lwedatha lokungenisa livuleka. Emkhakheni ucacise ikheli leseli, okuyinto ezoba yileli seli elingenhla elingakwesokunxele letafula elifakiwe. Uma uthola kunzima ukwenza lokhu ngesandla, uchofoze inkinobho ngakwesokudla kwensimu.
Ewindini evula, mane ukhethe iseli elifunayo. Bese uchofoza inkinobho ngakwesokudla kwedatha efakwe ensimini.
Ukubuyela efrinini lokungenisa idatha, chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, ithebula lifakiwe.
Khona-ke, uma ufisa, ungasetha imingcele ebonakalayo, futhi uyifomathile ngokusebenzisa izindlela ezijwayelekile ze-Microsoft Excel.
Ngezansi zalethwa izindlela ezimbili zokudlulisela itafula kusuka ku-Word kuya ku-Excel. Indlela yokuqala ilula kakhulu kuneyesibili, futhi yonke inqubo ithatha isikhathi esincane kakhulu. Ngesikhathi esifanayo, indlela yesibili iqinisekisa ukungabikho kwezimpawu ezingadingekile, noma ukufuduka kwamaseli, okusemandleni okudluliswa ngendlela yokuqala. Ngakho, ukucacisa indlela yokudluliselwa, udinga ukwakha ekubuneni kwetafula, nenhloso yalo.
