Nthawi zambiri, muyenera kutengera tebulo kuchokera ku Microsoft Excel mpaka ku Mawu, m'malo mosiyana ndi ena, komabe milandu yodzisinthira imakhalanso yosawerengeka. Mwachitsanzo, nthawi zina pamafunika kutumiza tebulo ku Excel, yopangidwa m'Mawu, kuti, pogwiritsa ntchito ndondomeko ya mkonzi wa tebulo, kuti awerengere deta. Tiyeni tipeze njira zomwe tingasamutsire matebulo kumbali iyi zilipo.
Kawirikawiri Kopi
Njira yosavuta yosamutsira tebulo ikugwiritsa ntchito njira yowonetsera nthawi zonse. Kuti muchite izi, sankhani tebulo mu Mawu, dinani pomwepa pa tsamba, ndipo sankhani chinthu "Kopani" muzolemba zomwe zikuwonekera. Mukhoza, m'malo mwake, dinani pa "Kopani" batani, yomwe ili pamwamba pa tepi. Njira ina imaganizira, mutasankha tebulo, kukanikiza Ctrl + C pa makiyi.
Kotero ife tinakopera tebulo. Tsopano tikufunika kuziyika mu pepala la Excel. Kuthamanga Microsoft Excel. Timakani pa selo pamalo omwe tikufuna kuyika tebulo. Tiyenera kukumbukira kuti selo iyi idzakhala selo lakumapeto la tebulo lolowetsedwa. Kuchokera pa izi ndikofunikira kupitiliza pamene mukukonzekera kukonza tebulo.
Dinani botani lamanja la mouse pamasamba, ndipo pazenera zamkati mwazomwe mungasankhe, sankhani mtengo "Sungani maonekedwe oyambirira". Komanso, mukhoza kuyika tebulo podalira pakani "Insert" yomwe ili kumanzere kwa riboni. Mwinanso, pali njira yoti muyimire fungulo lachinsinsi Ctrl + V pa kambokosi.
Pambuyo pake, tebulo idzaikidwa mu pepala la Microsoft Excel. Masepala a mapepala sangagwirizane ndi maselo mu tebulo loyikidwa. Choncho, kuti tebulo liwoneke bwino, liyenera kutambasula.
Tengerani tebulo
Ndiponso, pali njira yowonjezereka yosamutsira tebulo kuchokera ku Word to Excel, poitanitsa deta.
Tsegulani tebulo pulogalamu ya Mawu. Sankhani. Kenaka, pitani ku tabu "Layout", ndi mu "Gulu la Zida" papepala, dinani pa batani la "Convert to Text".
Mawindo otsegulira otsegula amatsegula. Mu "Separator" parameter, kusinthana kuyenera kukhazikitsidwa ku malo "Kuwonetsera". Ngati izi sizomwezo, sungani kasinthasintha ku malo awa, ndipo dinani "Bwino".
Pitani ku "Fayilo" tab. Sankhani chinthu "Sungani monga ...".
Muwindo lotsegulira tsamba losindikizidwa, tchulani malo omwe mukufuna kuti tiwasunge, ndipo tipezerani dzina ngati dzina losasintha silikukhutitsa. Ngakhale, atapatsidwa kuti fayilo yosungidwa ikhale yokhayokhayo yosamutsa tebulo kuchokera ku Word to Excel, palibe chifukwa chapadera chosinthira dzina. Chinthu chachikulu choti muchite ndikutsegula gawo la "Plain text" mu gawo la "Fayilo". Dinani pa batani "Sungani".
Fayilo yotembenuza mafayilo imatsegula. Palibe chifukwa chopanga kusintha kulikonse, koma muyenera kukumbukira ma encoding omwe mumasunga. Dinani pa batani "OK".
Pambuyo pake, muthamangitse Microsoft Excel. Pitani ku tabu la "Deta". Mu bokosi lamasewero "Pezani deta zakunja" pa tepicho dinani batani "Kuchokera m'malemba."
Fayilo lolemba mafayilo olembera liyamba. Tikuyang'ana fayilo yomwe idasungidwa kale m'mawu, ikani iyo, ndipo dinani pa "Import".
Pambuyo pake, mawindo a Wadindo a Mauthenga amatsegula. Muzokonzekera zamtundu wa deta, tchulani parameter "Yopanda malire". Ikani encoding molingana ndi yomwe mudasungira chikalata cholembedwa mu Mawu. Nthawi zambiri, zidzakhala "1251: Cyrillic (Windows)." Dinani pa batani "Yotsatira".
Muzenera yotsatira, mu "Symbol-delimiter" ikukhazikitsidwa, ikani kasinthasintha ku malo "Owonetsera", ngati sichiyika chosasinthika. Dinani pa batani "Yotsatira".
Muwindo lotsiriza la Wachipangizo Wowonetsera, mukhoza kupanga ma deta muzitsulo, poganizira zomwe zili. Sankhani ndondomeko yeniyeni mu Data Sample, ndi mu machitidwe a machitidwe a deta, sankhani chimodzi mwazinthu zinayi:
- wamba;
- malemba;
- tsiku;
- tsika mzere.
Ife timachita ntchito yofanana pa gawo lirilonse padera. Pamapeto pake, dinani "batani".
Pambuyo pake, mawindo obweretsera deta amayamba. M'munda mwatsatanetsatane tsatanetsatane wa adiresi ya selo, yomwe idzakhala selo lakumbuyo kwambiri lamanzere la tebulo lolowetsedwa. Ngati mukuvutika kuti muchite izi, pindani pa batani kumanja.
Pawindo lomwe limatsegula, ingosankha selo lofunidwa. Kenaka, dinani batani kudzanja lamanja la deta yomwe inalowa m'munda.
Pobwerera kuwindo lazakolowetsa deta, dinani pakani "OK".
Monga mukuonera, gome laikidwa.
Ndiye, ngati mukufuna, mukhoza kuyika malire owonetsetsa, komanso kuikonza pamagwiritsidwe ntchito a Microsoft Excel njira.
Pamwambayi zinaperekedwa njira ziwiri zosamutsira tebulo kuchokera ku Word to Excel. Njira yoyamba ndi yosavuta kuposa yachiwiri, ndipo njira yonseyo imatenga nthawi yochepa. Panthawi imodzimodziyo, njira yachiwiri imatsimikizira kuti palibe zizindikiro zosafunikira, kapena kuthamangitsidwa kwa maselo, kumene kuli kotheka pamene akusamutsidwa ndi njira yoyamba. Choncho, kuti mudziwe njira yosinthira, muyenera kumangika pa zovuta pa tebulo, ndi cholinga chake.
