Pamene mukugwira ntchito ndi Excel spreadsheets, nthawizina mumayenera kubisa maulendo kapena deta yosafunikira kuti musasokoneze. Koma posachedwa nthawi ikubwera pamene mukufunika kusintha machitidwewo, kapena zomwe zili mu maselo obisika, wogwiritsa ntchito mwadzidzidzi. Ndi pamene funso la momwe mungasonyezere zinthu zobisika zimakhala zofunikira. Tiyeni tione momwe tingathetsere vutoli.
Ndondomeko yowathandiza kuwonetsera
Nthawi yomweyo ndikuyenera kunena kuti chisankho chosankha kuwonetsa zinthu zobisika poyamba chimadalira m'mene iwo anabisika. Kawirikawiri njira zimenezi zimagwiritsa ntchito makompyuta osiyanasiyana. Pali njira zoterezi zobisira zomwe zili mu pepala:
- kusuntha malire a zipilala kapena mizere, kuphatikizapo kudzera m'ndandanda wamakono kapena batani pa riboni;
- gulu la deta;
- kusamba;
- kubisa zomwe zili mu maselo.
Ndipo tsopano tiyeni tiyese kupeza momwe tingasonyezere zomwe zili mkati mwa zinthu zobisika pogwiritsa ntchito njira zapamwambazi.
Njira 1: Tsegulani malire
Kawirikawiri, ogwiritsa ntchito akubisa zipilala ndi mizere, kutseka malire awo. Ngati malirewo adasunthika kwambiri, ndiye kuti n'zovuta kumamatira kumapeto kuti awakankhire. Pezani momwe izi zingakhalire mosavuta ndi mofulumira.
- Sankhani maselo awiri oyandikana nawo, pakati pawo omwe ali ndi zipilala zobisika kapena mizere. Pitani ku tabu "Kunyumba". Dinani pa batani "Format"yomwe ili mu chida chogwiritsa ntchito "Maselo". Mu mndandanda womwe ukuwonekera, sutsani cholozera ku chinthucho "Bisani kapena Kuwonetsa"zomwe ziri mu gulu "Kuwoneka". Kenako, mu menyu imene ikuwonekera, sankhani chinthucho "Sonyezani Zamphamvu" kapena Onetsani Ma Columns, malinga ndi zomwe zili zobisika.
- Zitatha izi, zinthu zobisika zikuwoneka pa pepala.
Palinso njira ina yomwe ingagwiritsidwe ntchito kusonyeza zobisika mwa kusuntha malire a zinthu.
- Pazithunzi zosakanikirana kapena zowonongeka, malingana ndi zomwe zili zobisika, zigawo kapena mizere, timasankha magawo awiri omwe ali pafupi ndi chithunzithunzi ndi batani lamanzere lomwe likugwiritsidwa pansi, pakati pa zinthu zomwe zili zobisika. Dinani kusankhidwa ndi batani lamanja la mouse. Mu menyu yachidule, sankhani chinthucho "Onetsani".
- Zinthu zobisika zidzawonetsedwa pomwepo pazenera.
Zosankha ziwirizi zingagwiritsidwe ntchito kokha ngati malire a selo adasinthidwa mwadongosolo, komanso ngati atabisika pogwiritsa ntchito zipangizo pazenera kapena mndandanda.
Njira 2: Kugwirana
Mukhozanso kubisa mizere ndi mizere pogwiritsa ntchito magulu, pamene amasonkhanitsidwa ndikubisidwa. Tiyeni tiwone momwe tingawawonetsere pawindo.
- Zisonyezero kuti mizera kapena zipilala zagululidwa ndi zobisika ndi chithunzi "+" kumanzere kwa malo ozungulira ofanana kapena pamwamba pa mawonekedwe osakanikirana, motero. Kuti muwonetse zinthu zobisika, dinani pazithunzi izi.
Mukhozanso kuwawonetsa mwa kudindira pa chiwerengero chomaliza cha magulu owerengera. Ndiko kuti, ngati digiti yomaliza ili "2"ndiye dinani apo ngati "3", kenako dinani chiwerengerochi. Nambala yeniyeniyi imadalira magulu angati omwe akugulitsana wina ndi mzake. Ziwerengerozi zili pamwamba pazithunzi zosakanikirana kapena kumanzere kwa ofanana.
- Pambuyo pazochitika zonsezi, zomwe zili mu gululo zidzatsegulidwa.
- Ngati izi sizikukwanira kuti iwe ndi iwe ukhale wopangika kwathunthu, ndiye choyamba sankhani ma coloni kapena mizere yoyenera. Ndiye, pokhala mu tab "Deta"dinani pa batani "Guluzani"yomwe ili mu block "Chikhalidwe" pa tepi. Monga njira ina, mukhoza kusindikizira mabatani otentha Mzere Wotsalira Wotsitsira Shift +.
Magulu adzasulidwa.
Njira 3: Chotsani fyuluta
Pofuna kubisala deta yosafunikira, nthawi zambiri kusefera kumagwiritsidwa ntchito. Koma, pokhudzana ndi kufunikira kubwerera kuti agwire ntchito ndi chidziwitso ichi, fyuluta iyenera kuchotsedwa.
- Dinani pa chithunzi cha fyuluta m'ndandanda, pazifanizo zomwe zimasankhidwa. Zili zosavuta kupeza zipilala zoterezi, chifukwa ali ndi chithunzi chopangidwa ndi fyuluta yomwe ili ndi katatu yosandulika yomwe ikuphatikizidwa ndi chithunzi china ngati madzi.
- Mndandanda wa fyuluta imatsegula. Ikani bokosili kutsogolo kwa mfundo zomwe zikusowa. Mizere iyi siyiwonetsedwa pa pepala. Kenaka dinani pa batani. "Chabwino".
- Pambuyo pazimenezi, mizere idzawonekera, koma ngati mukufuna kuchotsa fyuluta yonseyo, ndiye kuti mukuyenera kutsegula pa batani "Fyuluta"yomwe ili pa tabu "Deta" pa tepi mu gulu "Sankhani ndi kusefera".
Njira 4: Kukonza
Pofuna kubisa zomwe zili m'maselo, kupangidwira kumagwiritsidwa ntchito polowera mawu akuti ";;;" mu gawo la mtundu. Kuti musonyeze zobisika zobisika, muyenera kubwezeretsanso zoyambirirazo kuzinthu izi.
- Sankhani maselo omwe ali ndi zobisika. Zinthu zoterezi zingatsimikizidwe ndi kuti palibe deta yomwe imawonetsedwa m'ma maselo okha, koma zikasankhidwa, nkhaniyi idzawonetsedwa mu bar.
- Pambuyo pasankhidwayo, dinani pabokosi lamanja la mouse. Yayambitsa mndandanda wamakono. Sankhani chinthu "Sungani maselo ..."podalira pa izo.
- Fesitimu yokongoletsa ikuyamba. Pitani ku tabu "Nambala". Monga mukuonera, kumunda Lembani " mtengo umasonyezedwa ";;;".
- Chabwino, ngati mukukumbukira zomwe mawonekedwe oyambirira a maselo anali. Pachifukwa ichi, mutha kukhalabe muyeso yodalirika. "Maofomu Owerengeka" onetsani chinthu choyenera. Ngati simukukumbukira mawonekedwe enieni, khulupirirani zomwe zili mu selo. Mwachitsanzo, ngati pali zambiri zokhudza nthawi kapena tsiku, sankhani "Nthawi" kapena "Tsiku"ndi zina. Koma kwa mitundu yowonjezera, chinthu "General". Sankhani ndikusankha pa batani. "Chabwino".
Monga mukuonera, patatha izi, zikhalidwe zobisika zikuwonetsedwanso pa pepala. Ngati mukuganiza kuti mawonetsedwe a zowonongeka sizolondola, ndipo, mwachitsanzo, mmalo mwa tsiku mumawona chiwerengero cha nambala, ndikuyesetsani kusintha kachiwiri.
Phunziro: Mmene mungasinthire selo mtundu mu Excel
Pothetsa vuto la kusonyeza zinthu zobisika, ntchito yaikulu ndi kudziwa ndi zipangizo zamakono zomwe zinabisika. Ndiye, pogwiritsa ntchito izi, gwiritsani ntchito imodzi mwa njira zinayi zomwe tafotokozedwa pamwambapa. Ndikofunika kumvetsetsa kuti ngati, mwachitsanzo, zokhudzanazo zimabisika potseka malire, ndiye kuti kuchotsa kapena kuchotsa fyuluta sikuthandiza kusonyeza deta.
