Sinthani kusinthitsa ku Microsoft Excel

Kufunika kosinthira zolembalemba nthawi zambiri kumakumananso ndi ogwiritsa ntchito asakatuli, osintha zolembalemba ndi maprosesa. Komabe, mukamagwira ntchito mu processor ya processor ya Excel, kufunikira koteroko kumatha kubweranso, chifukwa pulogalamu iyi sikuti imangokhala manambala, komanso malembo. Tiyeni tiwone momwe angasinthire kukhazikitsa ku Excel.

Phunziro: Kulembeka mu Microsoft Mawu

Gwirani ntchito polemba zilembo

Kulembera zolemba ndi makina amagetsi omwe amasinthidwa kukhala ogwiritsira ntchito ogwiritsa ntchito. Pali mitundu yambiri yosungira, iliyonse yomwe ili ndi malamulo ake ndi chilankhulo. Kutha kwazomwe pulogalamu imazindikira chilankhulo china ndikuchimasulira mu zizindikiritso zomveka kwa munthu wamba (zilembo, manambala, zizindikiro zina) kumatsimikizira ngati pulogalamuyo ingagwire ntchito ndi mawu enaake kapena ayi. Mwa zina mwamalemba otchuka pali izi:

• Windows-1251;
• KOI-8;
• ASCII;
• ANSI
• UKS-2;
• UTF-8 (Unicode).

Dzinalo lachiwiri ndilofala kwambiri pakati pa zosungidwa padziko lapansi, chifukwa limawerengedwa kuti ndi mtundu wanthawi zonse.

Nthawi zambiri, pulogalamuyi imazindikira kusinthaku ndikusintha kwayokha, koma nthawi zina wosuta amafunika kuuzako mawonekedwe ake. Pokhapokha amatha kugwira ntchito moyenera ndi zilembo zokhazikika.

Excel imakumana ndi chiwerengero chachikulu kwambiri cha zovuta kuzikondweretsa potsegula poyesa kutsegula mafayilo a CSV kapena kutumiza mafayilo txt. Nthawi zambiri, mmalo mwa zilembo zamasiku onse tikatsegula mafayilo awa kudzera mu Excel, titha kuwona zilembo zachilendo, zotchedwa "krakozyabry". Muzochitika izi, wogwiritsa ntchito amayenera kuchita zojambula zina kuti pulogalamuyo iyambe kuwonetsa deta molondola. Pali njira zingapo zothetsera vutoli.

Njira 1: sinthani kusinthidwa pogwiritsa ntchito Notepad ++

Tsoka ilo, Excel ilibe chida chokwanira chomwe chimalola kuti musinthe mwachangu zolemba zamtundu uliwonse. Chifukwa chake, wina ayenera kugwiritsa ntchito njira zingapo pazosankha izi kapena kusintha njira kuti athandizidwe ndi anthu ena. Njira imodzi yodalirika ndikugwiritsa ntchito zolemba za Notepad ++.

1. Timakhazikitsa pulogalamu ya Notepad ++. Dinani pazinthuzo Fayilo. Kuchokera pamndandanda womwe umatsegulira, sankhani "Tsegulani". Kapenanso, mutha kulemba njira yachidule pa kiyibodi Ctrl + O.



2. Fayilo yotsegulira fayilo imayamba. Timapita ku dawunilodi komwe kuli chikalatacho, chomwe chikuwonetsedwa molakwika ku Excel. Sankhani ndikudina batani. "Tsegulani" pansi pazenera.



3. Fayilo imatsegulidwa pawindo la Notepad ++. Pansi pazenera kumbali yakumanzere kwa bar ya mawonekedwe ndiye kusungira zikwatu pano. Popeza Excel siziwonetsa molondola, kusintha kumafunika. Timalemba makiyi osakanikirana Ctrl + A pa kiyibodi kusankha mawu onse. Dinani pazosankha "Encodings". Pamndandanda womwe umatsegulira, sankhani Sinthani ku UTF-8. Uku ndi kutsata kwa Unicode ndipo Excel imagwira nawo ntchito molondola monga momwe kungathekere.



4. Pambuyo pake, kuti musunge zosintha ku fayilo, dinani batani pazida zawotchi mu mawonekedwe a diskette. Tsekani Notepad ++ polemba batani loyang'ana mtanda wopyapyala lalikulu masikono awiri akunyumba kumanja kwa zenera.



5. Timatsegula fayiloyo m'njira zofananira kudzera mwa wofufuzayo kapena kugwiritsa ntchito njira ina iliyonse ku Excel. Monga mukuwonera, zilembo zonse zikuwonetsedwa molondola.

Ngakhale kuti njirayi ndiyotengera kugwiritsa ntchito mapulogalamu a chipani chachitatu, ndi njira imodzi yosavuta yosinthira zomwe zili m'mafayilo kupita ku Excel.

Njira yachiwiri: gwiritsani ntchito Wizard walemba

Kuphatikiza apo, mutha kusintha kutembenuza pogwiritsa ntchito zida zomwe mwapangazo pulogalamuyo, yomwe ndi Wizard yalemba. Mosadabwitsa, kugwiritsa ntchito chida ichi ndizovuta kwambiri kuposa kugwiritsa ntchito pulogalamu yachitatu yomwe tafotokozeredwa njira yapita.

1. Timayamba pulogalamu ya Excel. Ndikofunikira kuyambitsa pulogalamuyo, osatsegula chikalatacho ndi thandizo lake. Ndiko kuti, pepala lopanda kanthu likuyenera kuonekera pamaso panu. Pitani ku tabu "Zambiri". Dinani pa batani la riboni "Kuchokera palemba"kuyikidwa m'bokosi la chida "Kupeza deta yakunja".



2. Tsamba lamafayilo obwera limatsegulidwa. Imathandizira kutsegulidwa kwa mawonekedwe awa:
   • Txt;
   • CSV;
   • PRN.

   Pitani ku dongosololi la malo omwe fayilo yomwe yatumizidwayo, isankhe ndikudina batani "Idyani".



3. Zenera la Wizard la Wizard limatsegulidwa. Monga mukuwonera, m'munda wa zowonetseratu zilembo akuwonetsedwa molakwika. M'munda "Fayilo ya fayilo" tsegulani mindandanda-yotsitsa ndikusintha zolemba zikomo kuti zikhale Unicode (UTF-8).

   

   Ngati tsatanetsataneyo akuwonetsedwa molakwika, ndiye kuti timayesa kugwiritsa ntchito zolemba zina mpaka malembedwe agawo loti awerenge. Zotsatira zikakukhutitsani, dinani batani "Kenako".



4. Windo la wizard lotsatira likutsegulidwa. Apa mutha kusintha mawonekedwe achinyengo, koma tikulimbikitsidwa kusiya zoikika (tabu). Dinani batani "Kenako".



5. Pazenera lomaliza, mutha kusintha mtundu wa zomwe mwasankha:
   • General;
   • Zolemba
   • Tsiku
   • Dumphani mzati.

   Apa makonda akuyenera kukhazikitsidwa, poganizira mtundu wa zomwe zakonzedwa. Pambuyo pake, dinani batani Zachitika.



6. Pa zenera lotsatira, fotokozerani zogwirizanitsa za selo lakumanzere la masanjidwewo papepala pomwe pulogalamuyo idzaikemo. Izi zitha kuchitidwa ndikuyendetsa adilesi pamunda woyenera kapena kungowunikira tsamba lomwe mukufuna. Mapulogalamu atatha kuwonjezeredwa, dinani batani pazenera "Zabwino".



7. Pambuyo pake, malembawo adzawonetsedwa pa pepala pazinthu zomwe tikufuna. Imasinthasintha kapena kubwezeretsa kapangidwe ka tebulo, ngati inali masamba, popeza kusintha ndikumawononga.

Njira 3: sungani fayilo mu kusungitsa kwina

Pali zinthu zomwe zingasinthe pamene fayilo sifunikira kutsegulidwa ndikuwonetsa deta yolondola, koma kusungidwa pakukhazikitsa komwe kumakhazikitsidwa. Mu Excel, mutha kugwira ntchito imeneyi.

1. Pitani ku tabu Fayilo. Dinani pazinthuzo Sungani Monga.



2. Tsamba la chikalata chopulumutsa likutsegulidwa. Pogwiritsa ntchito mawonekedwe a Explorer, timazindikira komwe file ikasungidwa. Kenako timayika mtundu wa fayilo ngati tikufuna kuti tisunge bukhu la ntchito mu mtundu wosiyana ndi mtundu wamba wa Excel (xlsx). Kenako dinani papulogalamu "Ntchito" ndi mndandanda womwe umatsegula, sankhani Zosankha Zolemba pa Tsamba.



3. Pazenera lomwe limatsegulira, pitani tabu "Kutsegula". M'munda Sungani Chikalata Monga tsegulani mindandanda ndikutsitsa mtundu wa zolemba zomwe tikuwona kuti ndizofunikira. Pambuyo pake, dinani batani "Zabwino".



4. Bwerelani pazenera "Sungani Chikalata" kenako dinani batani Sungani.

Chikalatachi chidzasungidwa pa hard drive kapena zochotsa zochotseka pakukonzekera zomwe mwatsimikiza. Koma muyenera kudziwa kuti zikalata zomwe zimasungidwa ku Excel nthawi zonse zizisungidwa pakukhazikitsa kumeneku. Kuti musinthe izi, muyenera kupita pawindo kachiwiri Zosankha Zolemba pa Webusayiti ndikusintha makonzedwe.

Pali njira inanso yosinthira makonzedwe a zilembo zomwe zasungidwa.

1. Kukhala mu tabu Fayilodinani pachinthucho "Zosankha".



2. Tsamba la zosankha za Excel limatseguka. Sankhani sub "Zotsogola" kuchokera mndandanda womwe uli kumanzere kwa zenera. Pitani pakati pazenera kupita pazenera "General". Kenako dinani batani Zosintha patsamba.



3. A zenera kale kuti tidziwe Zosankha Zolemba pa Webusayiti, komwe timachita zofanana zonse zomwe tidakambirana kale.



Tsopano chikalata chilichonse chosungidwa mu Excel chidzakhala ndi kutsata komwe mudakukhazikitsa.

Monga mukuwonera, Excel ilibe chida chomwe chimalola kuti muthe kusintha mwachangu komanso momveka bwino kuchokera kuzowonjezera zina kupita kwina. Wizard yamalemba ili ndi magwiridwe antchito kwambiri ndipo ili ndi zambiri zomwe sizofunikira pakuchita. Kugwiritsa ntchito, muyenera kudutsa njira zingapo zomwe sizikukukhudzani mwachindunji, koma muzigwirira ntchito zina. Ngakhale kutembenuza kudzera pa cholembera cha tatu-notepad ++ pankhaniyi kumawoneka kosavuta. Kusunga mafayilo mu encoding yomwe mwapatsidwa ku Excel kumakhalanso kovuta chifukwa nthawi iliyonse yomwe mukufuna kusintha chizindikiro ichi, muyenera kusintha makonzedwe apadziko lonse lapansi.

Share
Pin
Tweet
Send
Share
Send