Guqula amafayela e-Word kuya ku-Microsoft Excel

Kunezimo lapho umbhalo noma amatafula afakwe ku-Microsoft Word kudingeka adluliselwe ku-Excel. Ngeshwa, iZwi alinikezi amathuluzi okwakhiwe kuwo ukuguqulwa okunjalo. Kodwa ngesikhathi esifanayo, kunezindlela eziningi zokuguqula amafayela kule ndlela. Ake sithole ukuthi lokhu kungenziwa kanjani.

Izindlela zokuguqulwa eziyisisekelo

Kunezindlela ezintathu eziyinhloko zokuguqula amafayela e-Word ku-Excel:

• ukukopisha idatha elula;
• ukusetshenziswa kwezicelo ezikhethekile zenkampani yangaphandle;
• ukusetshenziswa kwezinsizakalo ezikhethekile ze-intanethi.

Indlela 1: Kopisha Idatha

Uma nje ukopisha idatha kusuka kudokhumenti yeZwi ku-Excel, okuqukethwe okukulo dokhumenti entsha ngeke kubonakale kuhle kakhulu. Isigaba ngasinye sizofakwa esitokisini esithile. Ngakho-ke, ngemuva kokuba umbhalo ukopishwe, udinga ukusebenza ngesakhiwo esifanayo sokubekwa kwaso kwi-Excel sheet. Umbuzo ohlukile ukukopisha amatafula.

1. Khetha ingxenye yombhalo oyifunayo noma wonke umbhalo ku-Microsoft Word. Sichofoza inkinobho yesokudla yegundane, sibiza imenyu yokuqukethwe. Khetha into "Kopisha". Esikhundleni sokusebenzisa imenyu yesimo, emva kokukhetha umbhalo, ungachofoza inkinobho "Kopisha"okufakwa kuthebhu "Ikhaya" ebhodini lamathuluzi "Ibhodi lokunamathisela". Enye indlela ingemva kokukhetha umbhalo ukucindezela inhlanganisela eyinhloko ekhibhodi Ctrl + C.



2. Vula uhlelo lwe-Microsoft Excel. Sichofoza cishe endaweni esetshe lapho sizofaka khona umbhalo. Chofoza ngakwesokudla igundane ukubiza imenyu yesimo. Kulo, ku-"Ukufaka okukhethwa kukho," khetha inani "Londoloza ukufometha kwangempela".

   Kanti futhi esikhundleni salokho, ungachofoza inkinobho Namathiselaelitholakala engxenyeni engakwesokunxele kwetheyipu. Enye indlela ukucindezela inhlanganisela eyinhloko Ctrl + V.

Njengoba ungabona, umbhalo ufakwe, kodwa, njengoba kushiwo ngenhla, unombono ongabonakali.

Ukuze athathe ifomu esiyidingayo, sidlulisela amaseli ebubanzi obudingekayo. Uma kunesidingo, fometha ngaphezulu.

Indlela 2: Ikhophi Yedatha Ethuthukisiwe

Kukhona enye indlela yokuguqula idatha kusuka ku-Word kuya ku-Excel. Yiqiniso, liyinkimbinkimbi kakhulu kunenguqulo yangaphambilini, kodwa, ngesikhathi esifanayo, ukudluliswa okunjalo kuvame ukufaneleka.

1. Vula ifayela ku-Word. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza kusithonjana "Bonisa zonke izimpawu"okuyinto efakwe kwibhande ebhodini yamathuluzi. Esikhundleni salezi zenzo, ungakwazi ukumane ucindezele inhlanganisela eyinhloko I-Ctrl +.



2. I-markup ekhethekile izovela. Ekupheleni kwesigaba ngasinye yisibonakaliso. Kubalulekile ukuqinisekisa ukuthi azikho izigaba ezingenalutho, ngaphandle kwalokho ukuguqulwa kuzobe kungalungile. Izindima ezinjalo kufanele zisuswe.



3. Iya kuthebhu "Ifayela".



4. Khetha into "Londoloza".



5. Ifayela lefayela lokulondoloza livula. Kupharamitha "Uhlobo lwefayela" khetha inani "Umbhalo Ocacile". Sicindezela inkinobho "Gcina".



6. Ewindini lokuguqulwa kwefayela elivula, akukho zinguquko ezidingekayo. Vele uchofoze inkinobho "Kulungile".



7. Vula uhlelo lwe-Excel kuthebhu "Ifayela". Khetha into "Vula".



8. Ewindini "Idokhumenti yokuvula" kupharamitha yamafayela avulwe asetha inani "Wonke Amafayela". Khetha ifayela elondolozwe ngaphambilini kwi-Word, njengombhalo ocacile. Sicindezela inkinobho "Vula".



9. I-Text Import Wizard ivulwa. Cacisa ifomethi yedatha "Unlimited". Sicindezela inkinobho "Okulandelayo".



10. Kupharamitha "Umlingiswa we-delimiter" ucacise inani "Comma". Ngawo wonke amanye amaphuzu sisusa uphawu, uma lukhona. Sicindezela inkinobho "Okulandelayo".



11. Ewindini lokugcina, khetha ifomethi yedatha. Uma unombhalo ocacile, kutuswa ukuba ukhethe ifomethi. "Jikelele" (isethwe ngokuzenzakalelayo) noma "Umbhalo". Sicindezela inkinobho "Yenzelwe".



12. Njengoba sibona, manje isigaba ngasinye asifakiwe esitokisini esithile, njengendlela yangaphambilini, kepha emgqeni ohlukile. Manje sidinga ukwandisa le migqa ukuze amagama ngabanye alahleke. Ngemva kwalokho, ungafometha amaseli ngokuqonda kwakho.

Cishe ngokuvumelana nesimiso esifanayo, ungakwazi ukukopisha ithebula kusuka ku-Word kuya ku-Excel. I-nuances yale nqubo ichazwe kusifundo esihlukile.

Isifundo: indlela yokufaka itafula kusuka ku-Word kuya ku-Excel

Indlela 3: Sebenzisa Izicelo Zokuguqula

Enye indlela yokuguqula iZwi kuma-Excel amadokhumenti ukusebenzisa izinhlelo ezikhethekile zokuguqulwa kwedatha. Enye yezinto ezilula kunazo zonke i-Abex Excel kuya ku-Word Converter.

1. Vula Umbuso. Sicindezela inkinobho "Engeza amafayela".



2. Ewindini evula, khetha ifayela elizoguqulwa. Sicindezela inkinobho "Vula".



3. Ku-block "Khetha uhlobo lokukhipha" Khetha eyodwa yamafomethi amathathu e-Excel:
   • xls;
   • xlsx;
   • xlsm



4. Ebhokisini lesethingi "Ukuhlelwa kokukhipha" khetha indawo lapho ifayela elizoguqulwa khona.



5. Uma zonke izilungiselelo zicacisiwe, chofoza inkinobho. "Guqula".

Emva kwalokhu, inqubo yokuguqulwa iyenzeka. Manje ungavula ifayela ku-Excel, futhi uqhubeke usebenza nayo.

Indlela 4: Ukuguquguquka Ukusebenzisa Amasevisi E-inthanethi

Uma ungafuni ukufaka isofthiwe eyengeziwe ku-PC yakho, ungasebenzisa amasevisi e-intanethi akhethekile ukuguqula amafayela. Omunye wabaguquli be-intanethi elula kakhulu ekuqondeni kweZwi - i-Excel yi-Convertio yemithombo.

Online Converter Convertio

1. Yiya kuwebhusayithi ye-Convertio bese ukhetha amafayela wokuguqulwa. Lokhu kungenziwa ngezindlela ezilandelayo:
   • Khetha kusuka kukhompyutha;
   • Hudula kusuka ewindini elivulekile le-Windows Explorer;
   • Landa kusuka kuDropbox;
   • Landa kusuka ku-Google Drayivu;
   • Landa nge-reference.



2. Ngemuva kokuthi ifayela lomthombo lilayishwe kusayithi, khetha ifomethi yokugcina. Ukuze wenze lokhu, chofoza ohlwini lokudonsa ngakwesokunxele kokubhalisiwe "Ukulungele". Iya endaweni "Idokhumenti"bese ukhetha ifomethi ye-xls noma i-xlsx.



3. Sicindezela inkinobho "Guqula".



4. Emva kokuguqulwa sekuphelile, chofoza inkinobho. "Landa".

Emva kwalokho, idokhumenti ye-Excel izolandwa kukhompyutha yakho.

Njengoba ungabona, kunezindlela eziningana zokuguqula amafayela e-Word ku-Excel. Uma usebenzisa izinhlelo ezikhethekile noma abaguquli be-intanethi, izinguquko zenzeka ngokuchofoza okumbalwa nje. Ngesikhathi esifanayo, ukukopisha ngesandla, nakuba kuthatha isikhathi eside, kodwa kukuvumela ukufometha ifayela ngokunembile ngangokunokwenzeka ukuze uvumelane nezidingo zakho.