Zamkatimu
Mukamagwira ntchito muofesi, mungafunike kusamutsa deta. Nthawi zambiri timalankhula za kukopera matebulo kuchokera ku Excel kupita ku Mawu. Komabe, nthawi zina muyenera kuchita mosiyana. Ganizirani njira zomwe mungasinthire tebulo kuchokera ku Mawu kupita ku Excel.
Njira yoyamba: yosavuta kukopera ndi kumata
Njirayi ndi yachangu ndipo simafuna khama lalikulu.
"Koperani" ntchito pamndandanda womwe ukuwoneka
Mu Mawu, muyenera kusankha tebulo lomwe likufunika kusuntha. Izi zikhoza kuchitika mwa kuwonekera kumanja mbewa batani. Pambuyo pakusintha uku, muyenera dinani pagawo lomwe mwasankha ndikusankha chinthucho "Koperani" pamndandanda.
"Copy" ntchito pa "Home" tabu
Komanso pa "Home" tabu pali batani mu mawonekedwe a zikalata ziwiri. Amatchedwa Copy. Choyamba, muyenera kusankha tebulo, ndiyeno alemba pa izo.
Njira zazifupi za kiyibodi zokopera
Si zachilendo kuti mapulogalamu osiyanasiyana agwiritse ntchito njira yachidule ya kiyibodi kukopera deta. Sankhani chidutswa chomwe mukufuna ndikusindikiza "CTRL + C".
Pambuyo pa masitepe onse, tebulo lidzakopedwa pa clipboard. Muyenera kuyiyika mwachindunji mu fayilo yokha. Tsegulani chikalata chomwe mukufuna ku Excel, sankhani cell yomwe idzakhale kumanzere kumanzere. Pambuyo pake, dinani pomwepa. Kenako menyu idzawonekera pomwe mutha kusankha zosankha za phala. Pali njira ziwiri:
- gwiritsani ntchito masanjidwe apachiyambi;
- pogwiritsa ntchito mawonekedwe omaliza.
Matani mawonekedwe pa Home tabu
Mukayika deta, muyenera kuchita chimodzimodzi monga kukopera. Pitani ku "Home" tabu ndikupeza "Ikani" batani. Dinani pa izo.
Njira yachidule ya kiyibodi yophatikizira
Kuti muyike tebulo mufayilo, mutha kugwiritsa ntchito makiyi ophatikiza otentha. Ingodinani CTRL+V. Okonzeka.
Zofunika! Deta nthawi zambiri sichikwanira m'maselo mutasamuka, kotero mungafunike kusuntha malire.
Pambuyo pakusintha konse, tikhoza kunena kuti tebulo linasamutsidwa bwino.
Njira Yachiwiri: Kulowetsa Table mu Excel Document
Njira imeneyi imagwiritsidwa ntchito ndi anthu ochepa. Komabe, itha kugwiritsidwanso ntchito kusamutsa tebulo kuchokera ku chikalata cha Mawu kupita ku Excel.
Kutembenuza tebulo kukhala mawu osavuta
Choyamba muyenera kusankha tebulo. Ndiye muyenera kupeza "Kamangidwe" tabu ndi kusankha "Data" njira. Kenako sankhani "Convert to Text" kuchokera pa menyu otsika. Iwindo laling'ono lidzawonekera patsogolo panu, dinani pa "Tab sign" parameter. Tsimikizirani zomwe zikuchitika podina batani "Chabwino". Pambuyo pake, muwona kuti tebulo lasinthidwa kukhala mawu osavuta.
Kusunga tebulo mumtundu wa mawu
Muyenera kupeza "Fayilo" tabu pamwamba gulu. A zenera latsopano adzaoneka pamaso panu, kupeza "Save Monga" njira kumanzere ndiyeno kusankha "Sakatulani". Tiyenera kudziwa kuti mitundu yakale ya pulogalamuyi ilibe ntchitoyi. Pamene zenera lopulumutsa likuwonekera, muyenera kupereka dzina la fayilo ndikutchula malo omwe lidzakhala. Ndiye muyenera kusankha "Plain text" monga wapamwamba mtundu.
Kuyika tebulo mu chikalata cha Excel
Mu chikalata cha Excel, pitani ku tabu "Data". Kumeneko muyenera kupeza njira "Pezani deta kunja". Zosankha zingapo zidzawonekera patsogolo panu, muyenera kusankha "Kuchokera m'mawu". Pitani komwe kuli chikalata cha spreadsheet, dinani pamenepo, ndikusankha Import.
Kusankha encoding ndi zina
Zenera lomwe likuwoneka lidzakhala ndi zosankha zingapo. Pansi pa mawu akuti "Source data format" parameter "yokhala ndi delimiters" iyenera kuwonetsedwa. Pambuyo pake, padzakhala kofunika kufotokoza encoding yomwe idagwiritsidwa ntchito posunga tebulo mumtundu wa malemba. Nthawi zambiri muyenera kugwira ntchito ndi "1251: Cyrillic (Windows)". Pali mwayi wochepa woti kabisidwe kosiyana kagwiritsidwe ntchito. Iyenera kupezeka pogwiritsa ntchito njira yosankha (chosankha "Mawonekedwe a Fayilo"). Ngati encoding yolondola yatchulidwa, ndiye kuti mawu omwe ali pansi pawindo adzawerengedwa. Ndiye muyenera alemba pa "Next" batani.
Kusankha mtundu wa olekanitsa ndi mtundu wa data
Pazenera latsopano, muyenera kufotokozera munthu wa tabu ngati mawonekedwe a delimiter. Pambuyo sitepe, dinani "Kenako". Ndiye muyenera kusankha mzati mtundu. Mwachitsanzo, kusakhulupirika ndi "General". Dinani pa "Malizani" batani.
Kusankha Zosankha za Paste ndikumaliza Ntchito
Mudzaona zenera kumene mukhoza kusankha zina phala options. Chifukwa chake, data ikhoza kuyikidwa:
- ku pepala lamakono;
- ku pepala latsopano.
Okonzeka. Tsopano mutha kugwira ntchito ndi tebulo, mapangidwe ake, etc. Inde, ogwiritsa ntchito nthawi zambiri amakonda njira yoyamba chifukwa ndi yosavuta komanso yachangu, koma njira yachiwiri ikugwiranso ntchito komanso yothandiza.