Momwe mungamasulire liwu kuti liziwonjezera

Anonim

Kutembenuka kwa mafayilo a Mawu ku Microsoft Excel

Pali zochitika zomwe zolemba kapena matebulo amapatulidwa mu Microsoft Mawu amafunika kusinthidwa kuti akwaniritse bwino. Tsoka ilo, liwulo silikupereka zida zopangidwa ndi zopangidwazo. Koma, nthawi yomweyo, pali njira zingapo zosinthira mafayilo mbali iyi. Tiyeni tiwone momwe zitha kuchitikira.

Njira zosinthira

Mutha kusankha njira zitatu zoyambira kuti musinthe mafayilo oyenera:
  • Kukopera kosavuta;
  • kugwiritsa ntchito kaphwando kachitatu;
  • Kugwiritsa ntchito ntchito zapadera pa intaneti.

Njira 1: Koperani deta

Ngati mukungokopera deta kuchokera ku chikalata cha mawu kuti muchite bwino, zomwe zili mu chikalata chatsopano sizikhala ndi mawonekedwe owoneka bwino. Ndime iliyonse iikidwa mu khungu lenileni. Chifukwa chake, malembedwewo atakopedwa, muyenera kulimbikira kapangidwe kake kake pa pepala labwino. Funso linalake limakopera matebulo.

  1. Sankhani gawo lomwe mukufuna kapena lembani kwathunthu mu Microsoft Mawu. Ndi batani la mbewa lamanja, lomwe limatcha menyu. Sankhani "Copy". Mutha kugwiritsa ntchito menyu, mutasankha zolemba, dinani batani la "Copy", lomwe limayikidwa mu tabu yakunyumba. Njira ina ndi yomwe itatha kusankha lembalo. Kukakamiza kuphatikiza kwakukulu pa kiyibodi ya CTRL + C.
  2. Kukopera mawu kuchokera ku mawu

  3. Tsegulani pulogalamu ya Microsoft Excorl. Dinani Pafupifupi ndi malo pa pepalalo, kuti muike kuti mutu. Mbewa yoyenera Dinani foni. Mmenemo mu "kuyikapo magawo" block, sankhani "Sungani Zoyambira".

    Komanso, mmalo mwa izi, mutha kudina batani la "phala", lomwe limayikidwa m'mphepete lamanzere la tepi. Njira ina ndikusindikiza Ctrl + v zazikulu.

Kuyika kwa ma Microsoft Excel

Monga mukuwonera, lembalo limayikidwa, koma, monga tafotokozera pamwambapa, lili ndi mawonekedwe osafunikira.

Kuti tivomereze mitundu yomwe timafunikira, kambikitso maselo athu m'lifupi. Ngati pakufunika kuphatikizira ena.

Microsoft Chuma Chuma Chowonjezera

Njira 2: Kukopera Kwambiri

Pali njira ina yosinthira deta kuchokera ku Mawu kuti ikwaniritse. Inde, nkwachikulu kwambiri ndi mtundu wakale, koma, nthawi yomweyo, kusamutsa kotereku nthawi zambiri kumakonzedwa.

  1. Tsegulani fayiloyo mu pulogalamu yamawu. Pokhala mnyumba tabu, dinani pa "kuwonetsa zizindikiro zonse" chithunzi chomwe chili pa tepi m'sipilo. M'malo mwa zochita izi, mutha kungokakamiza Ctrl + * *.
  2. Onetsani zilembo zobisika m'mawu

  3. chizindikiro patsambali Special adzaoneka. Kumapeto kwa ndime iliyonse waima chizindikiro. Nkofunika younikira kuti palibe ndime kanthu, mwinamwake kutembenuka adzakhala pachithunzichi. ndime ziyenera kuchotsedwa.
  4. ndime kanthu m'Mawu

  5. Pitani ku "fayilo" tabu.
  6. Pitani ku tsamba file m'Mawu

  7. Sankhani katunduyo "Save Monga".
  8. Yopulumutsa ngati m'Mawu

  9. Zenera lopulumutsa fayilo limatseguka. Mu "Buku Type" chizindikiro, kusankha "Normal Text" mtengo. Dinani batani la "Sungani".
  10. Yopulumutsa monga lemba wamba mu Mawu

  11. Mu kutembenuka zenera file kuti atsegula, palibe kusintha safuna. Ingoni batani la "OK".
  12. Kupala Kutembenuka Tsamba m'Mawu

  13. Kutsegula pulogalamu kupambana mu "Buku" tabu. Sankhani katunduyo "Open".
  14. Kutsegula fayilo ku Microsoft Excel

  15. Mu "Tsamba Oyamba" zenera mu magawo a owona kutsegula, anakhazikitsa 'owona onse ". Sankhani file amene pamaso panu anapitiriza mu Mawu monga lemba mwachizolowezi. Dinani batani la "Lotseguka".
  16. Sankhani file mu Microsoft Excel

  17. mbuye wa imports malemba chikuyamba. Lembani mtundu deta "ndi delimiters". Dinani pa batani "lotsatira".
  18. Master of Microsoft Excel

  19. Mu "Chizindikiro-olekanitsa" chizindikiro, kusonyeza "koma" mtengo. Ndi zinthu zina zonse, kuchotsa checkboxes ngati alipo. Dinani pa batani "lotsatira".
  20. Yoika koma monga olekanitsa mu Microsoft Excel

  21. Mu zenera otsiriza, kusankha mtundu deta. Ngati muli mawu wamba, Ndi bwino kusankha "nawo" mtundu (anapereka pofikira) kapena "mawu". Dinani batani la "Maliza".
  22. Kumaliza ntchito mfiti lemba mu Microsoft Excel

  23. Monga mukuonera, tsopano ndime iliyonse ndi anaikapo anaikapo mu chipinda osiyana, monga pa njira m'mbuyomu, koma chingwe osiyana. Tsopano inu muyenera kuti mukulitse mizere zimenezi kuti mawu amene ali sanataye. Pambuyo pake, mukhoza mtundu maselo pa nzeru zanu.

Text mu Microsoft kupambana pambuyo kutengerapo

Pafupifupi chiwembu chomwecho mukhoza kukopera tebulo ku Mawu kupambana. Mokoma njirayi yafotokozedwa mu phunziro osiyana.

Phunziro: Kodi amaika tebulo ku Mawu mu kupambana

Njira 3: Phunziro pankhaniyi Mapulogalamu kwa Kutembenuka

Njira ina kutembenuza zikalata Mawu kupambana ndi kutsatira ntchito apadera kutembenuza deta. Mmodzi mwa anthu ambiri yabwino ndi Abex kupambana kwa Mawu Converter pulogalamu.

  1. Tsegulani zofunikira. Dinani pa batani la "Onjezani mafayilo".
  2. Pitani kuwonjezera file kuti Abex kupambana kwa Mawu Converter

  3. Pawindo kuti atsegula, sankhani file kuti umamumvera kutembenuka. Dinani batani la "Lotseguka".
  4. Sankhani file mu Abex kupambana kwa Mawu Converter

  5. Mu Select linanena bungwe Mtundu chipika, kusankha mmodzi wa atatu akamagwiritsa kupambana:
    • XL;
    • Xlsx;
    • Xsm.
  6. Mtundu wosankhidwa mu Abex kupambana kwa Mawu Converter

  7. Mu chipika zoikamo linanena bungwe atakhala, sankhani malo kumene wapamwamba adzatembenukanso.
  8. Sankhani file kupulumutsa malo Abex kupambana kwa Mawu Converter

  9. Pamene zoikamo onse ananenera, alemba pa "Convert" batani.

Kutembenuka kwachangu ku Abex Excel kwa Renring

Pambuyo pake, njira zotembenukira zimachitika. Tsopano mutha kutsegula fayiloyo mu pulogalamu ya Excel, ndikupitiliza kugwira nawo ntchito.

Njira 4: Kutembenuka Kugwiritsa Ntchito Ntchito Zapaintaneti

Ngati simukufuna kukhazikitsa pulogalamu yowonjezera pa PC yanu, mutha kugwiritsa ntchito intaneti yapadera kuti musinthe mafayilo. Chimodzi mwazosinthidwa pa intaneti kwambiri mu Mawu - excel ndi chiwonetsero chamiyala.

Wotembenukira pa intaneti

  1. Pitani ku Webusayiti ya Custio ndikusankha mafayilo otembenuka. Izi zitha kuchitika m'njira zotsatirazi:
    • Sankhani kuchokera pa kompyuta;
    • Kokerani kuchokera ku Windows Explorer Openler;
    • Tsitsani kuchokera ku ntchito ya Dropbox;
    • Kutsitsa kuchokera ku Google drive;
    • Lowetsani ulalo.
  2. Pitani ku mafayilo a mafayilo

  3. Pambuyo pa fayilo ya gwero ladzaza pamalopo, sankhani mtundu wovomerezeka. Kuti muchite izi, dinani pamndandanda wotsika kumanzere kwa mawu oti mawu oti "akonzekere". Pitani ku "Chikalata", kenako sankhani XLS kapena XLSX.
  4. Kusankha Kusankhidwa Kwakusintha

  5. Dinani batani la "Sinthani".
  6. Kutembenuka kwa kusinthasintha ku Cunio

  7. Pambuyo potembenuka ukumalizidwa, dinani batani la "Tsitsani".

Pitani ku fayilo yolumpha ku Cunio

Pambuyo pake, chikalata chopambana chidzatsitsidwa pakompyuta yanu.

Monga mukuwonera, pali njira zingapo zosinthira mafayilo a Mawu kuti azipambana. Mukamagwiritsa ntchito mapulogalamu apadera kapena otembenuka pa intaneti, kusinthaku kumachitika makamaka ku dinks. Nthawi yomweyo, kukopera kwamanja, ngakhale kumatenga nthawi yambiri, koma kumakupatsani mwayi kuti mupange fayilo molondola.

Werengani zambiri