Vuto kuwonetsa manambala mumtundu wa deti ku Excel

Pin
Send
Share
Send

Pali nthawi zina pamene, akugwira ntchito ku Excel, atalowa nambala angapo mu foni, akuwonetsedwa ngati deti. Izi zimakwiyitsa kwambiri ngati muyenera kuyika deta ya mtundu wina, ndipo wosuta sadziwa momwe angachitire. Tiyeni tiwone chifukwa chake ku Excel, m'malo mwa manambala, tsikuli likuwonetsedwa, komanso ndikuwona momwe angakonzere izi.

Kuthetsa vuto lowonetsa manambala ngati madeti

Chifukwa chokhacho chomwe chidziwitso mu foni mutha kuwonetsedwa ngati tsiku ndi chakuti chili ndi mtundu woyenera. Chifukwa chake, kuti asinthe mawonekedwe owonetsa momwe akufunira, wosuta ayenera kusintha. Izi zitha kuchitika m'njira zingapo.

Njira 1: mndandanda wanthawi zonse

Ogwiritsa ntchito ambiri amagwiritsa ntchito menyu wazonse kuti athane ndi vutoli.

  1. Dinani kumanja pamndandanda womwe mukufuna kusintha mawonekedwe. Pazosankha zomwe zikuwoneka pambuyo pa izi, sankhani "Mtundu wamtundu ...".
  2. Tsamba losintha likutsegulidwa. Pitani ku tabu "Chiwerengero"ngati idatsegulidwa mwadzidzidzi tabu lina. Tiyenera kusintha chizindikiro "Mawerengero Amanambala" kuchokera pamtengo Tsiku kwa wogwiritsa ntchito. Nthawi zambiri izi "General", "Numeric", "Ndalama", "Zolemba"koma pakhoza kukhala ena. Zonse zimatengera momwe zinthu zilili komanso cholinga cha zomwe zatsimikizidwazo. Pambuyo posintha chizindikiro, dinani batani "Zabwino".

Pambuyo pake, zambiri zomwe zili m'maselo osankhidwa sizikuwonetsedwanso ngati tsiku, koma zidzawonetsedwa mu mtundu wofunikira kwa wogwiritsa ntchito. Ndiye kuti, cholinga chidzakwaniritsidwa.

Njira 2: sinthani mawonekedwe pa tepi

Njira yachiwiri ndiyosavuta kuposa yoyamba, ngakhale pazifukwa zina ndiyotchuka pakati pa ogwiritsa ntchito.

  1. Sankhani khungu kapena mtundu wokhala ndi mtundu wa deti.
  2. Kukhala mu tabu "Pofikira" mu bokosi la zida "Chiwerengero" tsegulani gawo lapadera lojambula. Amapereka mitundu yotchuka kwambiri. Sankhani yomwe ili yoyenera kwambiri mwatsatanetsatane.
  3. Ngati pakati pazomwe zafotokozedwayi njira yomwe sinapezeke, ndiye dinani chinthucho "Makonda ena manambala ..." mndandanda womwewo.
  4. Chimodzimodzi zenera zomwe zimasanja momwe zimatsegukira monga momwe zimakhalira kale. Ili ndi mndandanda wambiri wosintha zosintha mu khungu. Chifukwa chake, zochita zina zidzakhalanso zofanana ndendende ndi yankho lavutoli. Sankhani chinthu chomwe mukufuna ndikudina batani "Zabwino".

Pambuyo pake, mawonekedwe mu maselo osankhidwa adzasinthidwa kukhala omwe mukufuna. Tsopano manambala omwe ali mkati mwawo sawonetsedwa tsiku, koma atenga mawonekedwe ofotokoza.

Monga mukuwonera, vuto la kuwonetsa madeti mu maselo m'malo manambala si nkhani yovuta kwambiri. Kuchepetsa ndikosavuta, kungodina mbewa pang'ono ndikokwanira. Ngati wogwiritsa ntchito amadziwa zamagulu a zochita, ndiye kuti njirayi imakhala yoyambira. Pali njira ziwiri zochitira izi, koma onse awiri amadzayamba kusintha mawonekedwe amtunduwu kuchokera tsiku mpaka tsiku lina.

Pin
Send
Share
Send