Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani

Lapho usebenza ezinhlelweni zehhovisi, ungadinga ukudlulisa idatha. Isikhathi esiningi sikhuluma ngokukopisha amatafula kusuka ku-Excel kuye ku-Word. Nokho, ngezinye izikhathi kufanele wenze okuphambene. Cabanga ngezindlela ongadlulisa ngazo ithebula lisuka ku-Word liye ku-Excel.

Indlela yokuqala: kopisha futhi unamathisele kalula

Le ndlela iyashesha futhi ayidingi umzamo omkhulu.

"Kopisha" umsebenzi ohlwini oluvelayo

Ku-Word, udinga ukukhetha ithebula elidinga ukuhanjiswa. Lokhu kungenziwa ngokuchofoza inkinobho yegundane elingakwesokudla. Ngemuva kwalokhu kukhohlisa, udinga ukuchofoza endaweni ekhethiwe bese ukhetha into ethi "Kopisha" ohlwini.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ukusebenzisa umsebenzi othi “Kopisha” ohlwini oluvelayo uma uchofoza inkinobho yegundane engakwesokudla

"Kopisha" umsebenzi kuthebhu "Ekhaya".

Futhi kuthebhu ethi "Ekhaya" kunenkinobho esesimweni samadokhumenti amabili. Ibizwa ngokuthi Kopisha. Okokuqala, udinga ukukhetha ithebula, bese uchofoza kulo.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ukusebenzisa inkinobho ethi Kopisha kuthebhu ethi Ikhaya

Izinqamuleli zekhibhodi ezijwayelekile zokukopisha

Akuvamile ukuthi izinhlelo ezahlukene zisebenzise isinqamuleli sekhibhodi esifanayo ukukopisha idatha. Khetha ucezu olufunayo bese ubamba inhlanganisela "CTRL + C".

Umsebenzi othi "Faka" kumenyu ye-popup ku-Excel

Ngemuva kwazo zonke izinyathelo, ithebula lizokopishelwa ebhodini lokunamathisela. Udinga ukuyifaka ngqo efayelini ngokwalo. Vula idokhumenti ye-Excel oyifunayo, khetha iseli elizoba ngenhla kwesokunxele. Ngemva kwalokho, chofoza kwesokudla kuyo. Kuzovela imenyu lapho ungakhetha khona izinketho zokunamathisela. Kunezinketho ezimbili:

  • sebenzisa ukufometha koqobo;
  • usebenzisa ukufometha kokugcina.
Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ukuze usebenzise ukufometha koqobo, chofoza isithonjana sebhulashi. Ukuze usebenzise ukufometha kokugcina, chofoza isithonjana esiseduze

Namathisela isici kuthebhu ethi Ikhaya

Lapho unamathisela idatha, kufanele wenze ngendlela efanayo nokukopisha. Iya kuthebhu ethi "Ekhaya" bese uthola inkinobho ethi "Faka". Chofoza kuso.

Isinqamuleli sekhibhodi sokunamathisela

Ukufaka ithebula efayeleni, ungasebenzisa inhlanganisela yokhiye abashisayo. Vele ucindezele u-CTRL+V. Ilungile.

Kubalulekile! Idatha ngokuvamile ayingeni kumaseli ngemva kokuthutha, ngakho-ke kungase kudingeke ukuthi uhambise imingcele.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ungashintsha usayizi wemigqa namakholomu njengoba kudingeka.

Ngemuva kwakho konke ukukhohlisa, singasho ukuthi itafula lidluliselwe ngempumelelo.

Indlela Yesibili: Ukungenisa Ithebula Kumadokhumenti e-Excel

Le ndlela isetshenziswa inani elilinganiselwe labantu. Nokho, ingasetshenziswa futhi ukudlulisa ithebula lisuka kudokhumenti ye-Word liye ku-Excel.

Ukuguqula ithebula libe umbhalo ongenalutho

Okokuqala udinga ukukhetha ithebula. Khona-ke kufanele uthole ithebhu "Isakhiwo" bese ukhetha inketho "Idatha". Bese ukhetha okuthi “Guqulela Umbhalo” kumenyu yokudonsela phansi. Iwindi elincane lizovela phambi kwakho, chofoza ipharamitha "yesibonakaliso sethebhu". Qinisekisa isenzo ngokuchofoza inkinobho ethi "OK". Ngemuva kwalokho, uzobona ukuthi ithebula liguqulelwe kumbhalo ongenalutho.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ukuguqula ithebula libe umbhalo ongenalutho

Ilondoloza ithebula ngefomethi yombhalo

Udinga ukuthola ithebhu "Ifayela" kuphaneli ephezulu. Iwindi elisha lizovela phambi kwakho, thola inketho ethi "Gcina Njengo" kwesokunxele bese ukhetha "Phequlula". Kufanele kuqashelwe ukuthi izinguqulo zangaphambili zohlelo azinawo lo msebenzi. Lapho kuvela iwindi lokulondoloza, uzodinga ukunikeza ifayela igama futhi ucacise indawo lapho lizotholakala khona. Bese udinga ukukhetha "Umbhalo ongenalutho" njengohlobo lwefayela.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ilondoloza ithebula ngefomethi yombhalo

Ukufaka itafula kudokhumenti ye-Excel

Kudokhumenti ye-Excel, yiya kuthebhu "Idatha". Lapho udinga ukuthola inketho "Thola idatha yangaphandle". Izinketho ezimbalwa zizovela phambi kwakho, kufanele ukhethe "Kusuka kumbhalo". Zulazula uye endaweni yedokhumenti yesipredishithi, chofoza kuso, bese ukhetha okuthi Ngenisa.

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Ingenisa ithebula efayelini lombhalo

Ukukhetha kokufaka ikhodi nezinye izinketho

Iwindi elivelayo lizoba nezinketho ezimbalwa. Ngaphansi kombhalo othi "Ifomethi yedatha yomthombo" ipharamitha "enama-delimiters" kufanele ikhonjiswe. Ngemva kwalokho, kuyodingeka ukuba ucacise umbhalo wekhodi owawusetshenziswa lapho ulondoloza ithebula ngefomethi yombhalo. Ngokuvamile kufanele usebenze nge-"1251: Cyrillic (Windows)". Mancane amathuba okuthi kusetshenziswe umbhalo wekhodi ohlukile. Kuzodingeka kutholwe kusetshenziswa indlela yokukhetha (inketho "Ifomethi yefayela"). Uma umbhalo olungile ucacisiwe, umbhalo ongezansi kwewindi uzofundeka. Khona-ke udinga ukuchofoza inkinobho ethi "Okulandelayo".

Ithebula lisuka ku-Word liye ku-Excel - lidluliswa kanjani
Kulokhu, umbhalo ojwayelekile uyasetshenziswa, umbhalo uyafundeka

Ukukhetha uhlamvu lwesihlukanisi nefomethi yedatha yekholomu

Ewindini elisha, kufanele ucacise uhlamvu lwethebhu njengohlamvu lwe-delimiter. Ngemva kwalesi sinyathelo, chofoza "Okulandelayo". Bese udinga ukukhetha ifomethi yekholomu. Isibonelo, okuzenzakalelayo "Okuvamile". Chofoza inkinobho ethi "Qeda".

Ukukhetha Izinketho zokunamathisela bese uqedela umsebenzi

Uzobona iwindi lapho ungakhetha khona izinketho zokunamathisela ezengeziwe. Ngakho, idatha ingafakwa:

  • eshidini lamanje;
  • eshidini elisha.

Ilungile. Manje usungakwazi ukusebenza netafula, ukuklama kwalo, njll Yiqiniso, abasebenzisi bavame ukukhetha indlela yokuqala ngoba ilula futhi ishesha, kodwa indlela yesibili nayo iyasebenza futhi iyasebenza.

shiya impendulo