Ungafaka kanjani itafula kusuka ku-Excel

Anonim

Dlulisa itafula kusuka kuZwi kuya kuMicrosoft Excel

Kaningi kufanele udlulise itafula kusuka kuhlelo lweMicrosoft Excel kuhlelo lokusebenza lwamagama, okuhlukile, kepha namacala okudluliselwa kwembuyiselo nakho akuvamile. Isibonelo, kwesinye isikhathi udinga ukudlulisa itafula ku-Excel, elenziwe ngeZwi, ukuze usebenzise ukusebenza komhleli wethebula, ukubala imininingwane. Ake sibheke ukuthi yiziphi izindlela zokuhambisa amatafula kuleli qondiso zikhona.

Ikhophi Ejwayelekile

Indlela elula yokudlulisa itafula yenziwa yindlela ejwayelekile yekhophi. Ukuze wenze lokhu, khetha itafula ohlelweni lwamagama, uchofoza inkinobho yegundane elifanele ekhasini, futhi kumenyu yemenyu evelayo, khetha into ethi "Kopisha". Ungakwazi, esikhundleni, chofoza inkinobho ethi "Kopisha", ebekwe phezulu ethepheni. Enye inketho isikisela, ngemuva kokuthi itafula likhethiwe, licindezela izinkinobho zekhibhodi CTRL + C.

Kopisha itafula kusuka emagameni

Ngakho-ke, sakopisha itafula. Manje kudingeka sikufake ekhasini le-Excel. Qalisa uhlelo lwe-Microsoft Excel. Chofoza esitokisini endaweni yeshidi, lapho sifuna ukubeka khona itafula. Kumele kwaziwe ukuthi leli ngcebo lizoba yiseli ephezulu esele esele. Kusuka kulokhu okudingeka uze, uhlela ukubekwa kwetafula.

Qhafaza kwesokudla eshidini, nakumenyu yokuqukethwe kumapharamitha wokufaka, khetha inani "Gcina ukufomatha kokuqala". Futhi, ungafaka itafula ngokuchofoza inkinobho ethi "Namathisela" atholakala onqenqemeni lwesobunxele lwetheyipu. Noma, kukhona inketho yokushayela inhlanganisela ye-Ctrl + V ekhibhodi kwikhibhodi.

Ukufaka amatafula ku-Microsoft Excel

Ngemuva kwalokho, itafula lizofakwa ekhasini le-Microsoft Excel. Amaseli eshidi angeke ahambisane namaseli afakwe etafuleni. Ngakho-ke, ukuthi itafula libukeka livele, kufanele lelulwe.

Ukunwetshwa kwamakholomu wethebula ku-Microsoft Excel

Ngenisa itafula

Futhi, kunendlela eyinkimbinkimbi yokudlulisa itafula kusuka emazwini kuya ku-Excel, ngokungenisa idatha.

Vula ithebula ohlelweni lwamagama. Siyakugqama. Okulandelayo, iya kuthebhu ethi "Layout", bese kuthi "Idatha" ye-Tool Group etheyipini Sichofoza ku- "Guqula ku-Inkinobho".

Uguquko lube umbhalo ngegama

Kuvulwa iwindi lamapharamitha. Esihlathini "seSekelazi", ukushintshwa kufanele kusethwe ku "Tab Sign". Uma lokhu kungenjalo, sihumushela ukushintshela kulesi sikhundla, bese uqhafaza inkinobho ethi "KULUNGILE".

Izilungiselelo zokuguqula zibe umbhalo ngegama

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

Igcina itafula kusuka egameni

Efasiteleni elisindisa idokhumenti elivula, licacisa indawo oyifunayo yefayela ozoligcina, futhi unikeze igama kulo uma igama elizenzakalelayo lingagculisi. Noma, inikezwe ukuthi ifayela eligcinwe lizobe liphakathi nendawo kuphela ngokudlulisela itafula kusuka emazwini kuya ku-Excel, awukho umqondo othile wokushintsha igama. Into esemqoka ukuthi udinga ukukwenza ensimini ethi "Uhlobo lwefayela" setha i-parameter "yombhalo ojwayelekile". Chofoza inkinobho ethi "Gcina".

Iwindi lokulondolozwa kwembona

Iwindi lokuguqulwa kwefayela livuleka. Asikho isidingo sokwenza noma yiziphi izinguquko, kepha nguwe kuphela okufanele ukhumbule ukufakwa okukhonkotha lapho ugcine khona umbhalo. Chofoza inkinobho ethi "KULUNGILE".

Ukuguqulwa kwefayela kuZwi

Ngemuva kwalokho sebenzisa uhlelo lwe-Microsoft Excel. Iya kuthebhu "yedatha". Ku- "Thola idatha yangaphandle" Izilungiselelo ze-Block On the tepe sichofoza inkinobho ethi "Kusuka Embhalweni".

Ukuthola idatha yangaphandle ku-Microsoft Excel

Kuvulwa iwindi lokungenisa umbhalo. Sifuna ifayela eligcinwe ngaphambili egameni, siliqokomise, bese uqhafaza inkinobho ethi "Ngenisa".

Ngenisa ifayela ku-Microsoft Excel

Emva kwalokho, iwindows wizard yombhalo iyavula. Kuzilungiselelo zefomethi yedatha, chaza ipharamitha "nabahlukanisi". Faka ukufaka ikhodi ngokusho kwaleyo lapho ugcine khona idokhumenti yombhalo egameni. Ezimweni eziningi kuzoba "1251: Cyrillic (Windows). Chofoza inkinobho "elandelayo".

Master of Imibhalo ku-Microsoft Excel

Ewindini elilandelayo, esimisweni se- "Symbol-Sahlukanisi", usetha i-switch kuthebhu "I-Tab Sign", uma ingafakwanga ngokuzenzakalelayo. Chofoza inkinobho "elandelayo".

Ustanovka-Razleliielya-V-Master-Tekstov-V-Excel-Excel

Ewindini lokugcina lombhalo wizard, ungafometha idatha kumakholomu, unaka okuqukethwe kwawo. Khetha ikholomu ethile kwisampula yesampula yesampula, nakuzilungiselelo zefomethi yedatha yekholomu, khetha eyodwa yezinketho ezine:

  • Okuvamile;
  • Imibhalo;
  • usuku;
  • Phamba ikholomu.

Lokhu kusebenza kwenziwa kwikholamu ngayinye ngokwehlukana. Ekupheleni kokufomatha, chofoza inkinobho ethi "Qede".

Ukufaka ifomethi ku-Wizard Yombhalo ku-Microsoft Excel

Ngemuva kwalokho, iwindi lokungenisa idatha liyavula. Ku-mathupha, chaza ikheli leseli elizoba yiseli elingaphezulu kwesokunxele eliphakeme. Uma wenza kube nzima ukwenza lokhu ngesandla, bese sicindezela inkinobho ngakwesokudla kwensimu.

Ukushintsha ukukhetha iseli ku-Microsoft Excel

Ewindini elivula, mane wabela iseli oyifunayo. Ngemuva kwalokho, chofoza inkinobho ngakwesokudla kwedatha efakwe kwinkambu yedatha.

Icacisa amaseli ku-Microsoft Excel

Ukubuyela ewindini lokungenisa idatha, chofoza inkinobho ethi "Kulungile".

Ukuqinisekiswa kweseli ku-Microsoft Excel

Njengoba ubona, itafula liyafakwa.

Ithebula lifakwe ku-Microsoft Excel

Okulandelayo, uma ufisa, ungayifaka imingcele ebonakalayo, kanye nokufomatha izindlela ezijwayelekile ze-Microsoft Excel.

Ithebula elifomethiwe ku-Microsoft Excel

Ngaphezulu kwezindlela ezimbili zokudlulisela itafula elisuka ezwini kuya ku-Excel kwethulwa. Indlela yokuqala ilula kakhulu okwesibili, futhi inqubo yonke isikhathi esincane kakhulu. Ngasikhathi sinye, indlela yesibili iqinisekisa ukungabikhona kwezinhlamvu ezengeziwe, noma ukuthunyelwa kwamaseli, okungenzeka lapho kudluliswa ngendlela yokuqala. Ngakho-ke, ukuze kunqunywe ngenketho yokudlulisa, udinga ukuphindisela ekubumbeni kobulukhuni betafula, nezinhloso zalo.

Funda kabanzi