Nthawi zambiri mumayenera kusamutsa tebulo kuchokera ku Microsoft Excel kupita ku Mawu, kuposa pamenepo, komabe, zochitika zosinthira kusuntsanso sizosowa kwambiri. Mwachitsanzo, nthawi zina muyenera kusamutsa tebulo kupita ku Excel, yopangidwa m'Mawu, kuti mugwiritse ntchito kusintha kwa magwiritsidwe a tebulo kuti muwerenge zowerengera. Tiyeni tiwone njira zosunthira matebulo panjira iyi.
Copy Copy
Njira yosavuta yosunthira tebulo ndikugwiritsa ntchito njira yokhazikika yokopera. Kuti muchite izi, sankhani tebulo mu pulogalamu ya Mawu, dinani kumanja patsamba, ndikusankha "Copy" pazosankha zomwe zikuwoneka. Mutha, m'malo, dinani batani "Copy", lomwe lili pamwamba pa riboni. Njira inanso ikuphatikiza, mutatsindikiza tebulo, ndikanikiza makatani a Ctrl + C.
Chifukwa chake tinatsata tebulo. Tsopano tikuyenera kuyiyika mu worksheet ya Excel. Timayamba pulogalamu ya Microsoft Excel. Timadina cell pamalo pomwe pepalalo tikufuna kuyika tebulo. Dziwani kuti khungu ili lidzakhala gawo lamanzere lamanzere patebulo. Kuchokera pamenepa tiyenera kupitiliza kukonzekera magawo a tebulo.
Timangodula pepalalo, ndipo mndandanda wazosankha, pazosintha, ndikusankha mtengo "Sungani mawonekedwe oyambira". Mutha kuyikanso tebulo ndikudina batani "Ikani" lomwe lili kumanzere kwa riboni. Kapenanso, pali mwayi wosankha mtundu wamtundu wa Ctrl + V.
Pambuyo pake, tebulo lidzayikidwa mu worksheet ya Microsoft Excel. Ma cell mu pepalali sangagwirizane ndi maselo omwe ali patebulo. Chifukwa chake, kuti gome liziwoneka bwino, liyenera kutambasulidwa.
Tengani tebulo
Komanso, pali njira yovuta kwambiri yosamutsira tebulo kuchokera ku Mawu kupita ku Excel, ndikutumiza deta.
Tsegulani tebulo m'Mawu. Sankhani. Kenako, pitani pa tabu ya "Layout", ndipo pagulu la chida cha "Data" pa riboni, dinani batani "Sinthani kulemba".
Zenera la kutembenuka limatseguka. Mu gawo la "Separator", kusinthaku kuyenera kuyikidwa ku "Tab." Ngati sichoncho, sinthani izi kuti musinthe, ndikudina "batani".
Pitani pa tabu ya "Fayilo". Sankhani chinthu "Sungani ngati ...".
Pazenera lomwe limatsegulira, sungani chikalatacho, tchulani malo omwe mukufuna kuti tikasunge, ndikupatsenso dzina ngati dzina lokhalo silikukwaniritsa. Ngakhale, kupatsidwa kuti fayilo yomwe yasungidwa idzangokhala yapakatikati posamutsa tebulo kuchokera ku Mawu kupita ku Excel, sizikupanga nzeru kusintha dzinalo. Chofunikira kuchita ndikukhazikitsa gawo la "Plain text" mu gawo la "File file". Dinani pa batani "Sungani".
Tsamba losintha fayilo limatsegulidwa. Apa simukuyenera kusintha, koma ingokumbukirani zomwe mukusunga zomwe zalembedwazo. Dinani pa "Chabwino" batani.
Pambuyo pake, timayamba pulogalamu ya Microsoft Excel. Pitani ku tabu ya "Data". Mu "Get data kunja" mawonekedwe pa block ku riboni, dinani batani "Kuchokera pamawu".
Tsamba lamafayilo obwera limatsegulidwa. Tikuyang'ana fayilo lomwe tidasunga m'mawu mu Mawu, kusankha, ndikudina batani "Tengani".
Pambuyo pake, zenera la Text Wizard limatsegulidwa. Mu makonda a fomati ya data, tchulani chizindikiro "Cholekanitsidwa". Khazikitsani kukhazikitsa malinga ndi momwe mudasungira zolemba m'Mawu. Mwambiri, zidzakhala "1251: Cyrillic (Windows)." Dinani pa "Kenako" batani.
Pazenera lotsatira, pamasamba "Wopatula", ikani kusintha kwa "Tab kusiya", ngati sikunayikidwe mwachisawawa. Dinani pa "Kenako" batani.
Pazenera lomaliza la Text Wizard, mutha kusintha fomali m'makola, kukumbukira zomwe zili. Timasankha mtundu winawake mu Zitsanzo za tsambalo, ndipo pazosintha zochotsera, mumasankha imodzi mwanjira zinayi:
- chonse;
- zolemba
- Tsiku
- dumphani mzati.
Timagwiranso ntchito iliyonse pambali iliyonse. Mukamaliza kupanga fomati, dinani batani "kumaliza".
Pambuyo pake, zenera lotumizira deta limatseguka. M'mundamo, fotokozerani adilesi ya foniyo, yomwe idzakhale foni yomaliza kumanzere kwa tebulo lomwe laliikidwalo. Ngati mukulephera kuchita izi pamanja, dinani batani kumanja kwa munda.
Pazenera lomwe limatsegulira, ingosankha foni yomwe mukufuna. Kenako, dinani batani kumanja kwa deta yomwe yalowetsedwa kumunda.
Kubwereranso ku zenera lotumizira deta, dinani batani "Chabwino".
Monga mukuwonera, tebulo limayikidwa.
Kuphatikiza apo, ngati mukufuna, mutha kukhazikitsa malire oti muwoneke, komanso kuwapanga pogwiritsa ntchito njira za Microsoft Excel.
Njira ziwiri zosinthira tebulo kuchokera ku Mawu kupita ku Excel zidafotokozedwa pamwambapa. Njira yoyamba ndi yosavuta kuposa yachiwiri, ndipo njira yonseyo imatenga nthawi yocheperako. Nthawi yomweyo, njira yachiwiri imatsimikizira kusowa kwa zilembo zowonjezera, kapena kusamutsidwa kwa maselo, zomwe ndizotheka posamutsa njira yoyamba. Chifukwa chake, kuti musankhe njira yosamutsira, muyenera kuyambira pazovuta za tebulo, ndi cholinga chake.
