Momwe mungapangire mtundu wanu wa data mu Excel

Mawonekedwe a data mu Microsoft Office Excel ndi mtundu wa mawonetsedwe a zilembo m'maselo a tebulo. Pulogalamuyo yokha ili ndi zosankha zambiri zamapangidwe. Komabe, nthawi zina muyenera kupanga mtundu mwambo. Mmene tingachitire zimenezi tidzakambirana m’nkhani ino.

Momwe mungasinthire mawonekedwe a cell mu Excel

Musanayambe kupanga mawonekedwe anu, muyenera kudzidziwa bwino ndi mfundo zosinthira. Mutha kusintha mtundu umodzi wa chidziwitso m'maselo a tebulo kupita ku wina molingana ndi dongosolo ili:

1. Dinani batani lakumanzere la mbewa pa cell yofunikira yokhala ndi data kuti musankhe.
2. Dinani kumanja kulikonse komwe mwasankha.
3. Mu menyu yankhaniyo, dinani pamzere "Format Maselo ...".
4. Pazenera lomwe limatseguka, pitani kugawo la "Nambala" ndipo mu block "Mafomu a Nambala", sankhani imodzi mwazosankha zoyenera podina kawiri ndi LMB.

5. Dinani "Chabwino" pansi pa zenera kuti mugwiritse ntchito.

Tcherani khutu! Pambuyo posintha mawonekedwe, manambala omwe ali m'maselo a tebulo adzawonetsedwa mosiyana.

Momwe mungapangire mtundu wanu mu Excel

Mfundo yowonjezerera mtundu wa data mu pulogalamu yomwe ikuganiziridwa ikhoza kugawidwa m'magawo angapo:

1. Sankhani selo lopanda kanthu la tsamba logwirira ntchito ndipo, malinga ndi chiwembu pamwambapa, pitani pazenera la "Format Cells ...".
2. Kuti mupange mawonekedwe anu, muyenera kulemba ma code angapo pamzere. Kuti muchite izi, sankhani chinthu cha "Mawonekedwe Onse" ndipo pazenera lotsatira pagawo la "Mtundu" lowetsani mtundu wanu, podziwa ma encoding ake mu Excel. Pankhaniyi, gawo lililonse la code limasiyanitsidwa ndi lapitalo ndi semicolon.

3. Onani momwe Microsoft Office Excel imasungirira mtundu wina. Kuti muchite izi, sankhani njira iliyonse yolembera pamndandanda womwe ukupezeka pazenera ndikudina "Chabwino".
4. Tsopano, mu cell yosankhidwa, muyenera kulowa nambala iliyonse, mwachitsanzo, imodzi.

5. Mwachifaniziro, lowetsani mndandanda wamtundu wa cell ndikudina mawu oti "Numeric" pamndandanda wazomwe zaperekedwa. Tsopano, ngati mupitanso ku gawo la "Mawonekedwe Onse", ndiye kuti masanjidwe osankhidwa a "Numeric" awonetsedwa kale ngati encoding yokhala ndi magawo awiri: cholekanitsa ndi semicolon. Magawo adzawonetsedwa m'munda wa "Mtundu", woyamba mwa iwo akuwonetsa nambala yabwino, ndipo yachiwiri imagwiritsidwa ntchito pazinthu zoyipa.

6. Pakadali pano, wogwiritsa ntchito atazindikira kale mfundo yolembera, akhoza kuyamba kupanga mawonekedwe ake. Pachifukwa ichi, choyamba ayenera kutseka menyu Maselo a Format.
7. Patsamba lantchito la Excel, pangani mndandanda woyambira wa tebulo womwe ukuwonetsedwa pachithunzi pansipa. Gome ili limatengedwa ngati chitsanzo; pochita, mutha kupanga mbale ina iliyonse.

8. Ikani ndime yowonjezera pakati pa ziwiri zoyambirira.

Zofunika! Kuti mupange ndime yopanda kanthu, muyenera kudina kumanja pagawo lililonse lamagulu atebulo ndikudina "Ikani" mzere pazenera lazinthu.

9. Mugawo lopangidwa pamanja kuchokera pa kiyibodi ya PC, muyenera kuyika zomwe zachokera pagawo loyamba la tebulo.

10. Sankhani mzati wowonjezera ndikudina pomwepa. Pitani ku zenera la mtundu wa cell malinga ndi dongosolo lomwe takambirana pamwambapa.
11. Pitani ku "Zonse akamagwiritsa" tabu. Poyamba, mawu oti "Main" adzalembedwa pamzere wa "Type". Idzafunika kusinthidwa ndi mtengo wake.
12. Malo oyamba mumtundu wa code ayenera kukhala mtengo wabwino. Apa timapereka mawu akuti ""Osati negative". Mawu onse ayenera kuphatikizidwa muzolemba.
13. Pambuyo pa mtengo woyamba, ikani semicolon ndikulemba ""osati ziro".
14. Apanso timayika semicolon ndikulemba kuphatikiza "" popanda hyphen "".
15. Kumayambiriro kwenikweni kwa mzere, muyenera kulembanso "Akaunti No.", ndikukhazikitsa mtundu wanu, mwachitsanzo, "00-000 ″".

16. Sungani zosinthazo podina "Chabwino" pansi pazenera ndikukulitsa gawo lomwe lawonjezeredwa kale kuti muwone zofunikira m'malo mwa zilembo "####". Mawu ochokera kumtundu wopangidwa adzalembedwa pamenepo.

Zina Zowonjezera! Ngati zambiri zomwe zili m'maselo siziwonetsedwa, ndiye kuti wogwiritsa ntchitoyo adalakwitsa popanga mawonekedwe awoawo. Kuti mukonze zinthuzo, muyenera kubwereranso kuwindo la zoikamo zamtundu wa tabular ndikuwona kulondola kwa zomwe mwalowa.

Momwe mungachotsere mawonekedwe osafunikira mu Microsoft Office Excel

Ngati munthu sakufuna kugwiritsa ntchito mtundu umodzi kapena wina wa pulogalamu, ndiye kuti akhoza kuyichotsa pamndandanda wazomwe zilipo. Kuti muthane ndi ntchitoyi munthawi yochepa kwambiri, mutha kugwiritsa ntchito algorithm iyi:

1. Dinani ndi batani lakumanzere la mbewa pa selo iliyonse ya mndandanda wa tebulo. Mutha kungodinanso patsamba lopanda kanthu.
2. Mu bokosi la mtundu wa nkhaniyo, dinani mzere wa "Format Cells".
3. Pitani ku gawo la "Nambala" pazida zapamwamba za menyu yomwe imatsegulidwa.
4. Sankhani mtundu woyenera wa manambala pamndandanda wamabokosi omwe ali kumanzere ndikusankha ndikudina LMB.
5. Dinani pa "Chotsani" batani, limene lili m'munsi pomwe ngodya ya "Format Maselo" zenera.
6. Gwirizanani ndi chenjezo ladongosolo ndikudina Chabwino kuti mutseke zenera. The anasankha muyezo kapena mwambo mtundu ayenera zichotsedwa ku MS Excel popanda kuthekera kuchira m'tsogolo.

Kutsiliza

Chifukwa chake, kuwonjezera mawonekedwe amtundu ku Microsoft Office Excel ndi njira yosavuta yomwe mungathe kuchita nokha. Kuti tisunge nthawi komanso kuti ntchitoyi ikhale yosavuta, tikulimbikitsidwa kugwiritsa ntchito malangizo omwe ali pamwambapa.