Zamkatimu
Excel ndi pulogalamu yapadera, chifukwa ili ndi zinthu zambiri, zambiri zomwe zimapangitsa kuti zikhale zosavuta kugwira ntchito ndi matebulo. Nkhaniyi ifotokoza chimodzi mwazinthu izi, zomwe zimakulolani kubisa mizati patebulo. Chifukwa cha izo, zidzatheka, mwachitsanzo, kubisala mawerengedwe apakatikati omwe angasokoneze chidwi kuchokera ku zotsatira zomaliza. Pali njira zingapo zomwe zilipo, iliyonse yomwe ifotokozedwa pansipa.
Njira 1: Sinthani malire a Column
Njirayi ndiyosavuta komanso yothandiza kwambiri. Ngati tilingalira zomwe zachitikazo mwatsatanetsatane, ndiye kuti muyenera kuchita izi:
- Choyamba, muyenera kumvetsera mzere wogwirizanitsa, mwachitsanzo, wapamwamba. Ngati muyang'ana pamwamba pa malire, idzasintha kuti iwoneke ngati mzere wakuda wokhala ndi mivi iwiri m'mbali. Izi zikutanthauza kuti mutha kusuntha malire.
- Ngati malirewo abweretsedwa pafupi ndi malire oyandikana nawo, ndiye kuti mzerewo udzachepa kwambiri kotero kuti sudzawonekeranso.
Njira 2: Menyu Yachidziwitso
Njirayi ndiyotchuka kwambiri komanso yofunidwa pakati pa ena onse. Kuti mugwiritse ntchito, zidzakhala zokwanira kuchita mndandanda wazinthu zotsatirazi:
- Choyamba muyenera dinani kumanja pa dzina lazambiri.
- Menyu yankhani idzawoneka, momwe ndikwanira kusankha chinthu "Bisani".
- Pambuyo pazochita zomwe zachitika, gawoli lidzabisika. Zimangotsala pang'ono kuyesa kubwereranso ku chikhalidwe chake choyambirira, kotero kuti pakakhala cholakwika chirichonse chikhoza kukonzedwa mwamsanga.
- Palibe chovuta mu izi, ndikokwanira kusankha mizati iwiri pakati pomwe gawo lathu lalikulu linali lobisika. Dinani kumanja pa iwo ndikusankha Show. Mzerewu udzawonekera patebulo ndipo ungagwiritsidwenso ntchito.
Chifukwa cha njirayi, zitheka kugwiritsa ntchito ntchitoyi mwachangu, kupulumutsa nthawi komanso kusavutikira kukokera malire. Njira iyi ndiyosavuta kwambiri, chifukwa chake ikufunika pakati pa ogwiritsa ntchito. Chinthu china chochititsa chidwi cha njirayi ndi chakuti zimapangitsa kuti zikhale zotheka kubisa mizati ingapo nthawi imodzi.. Kuti muchite izi, zidzakhala zokwanira kuchita zotsatirazi:
- Choyamba muyenera kusankha mizati zonse zimene mukufuna kubisa. Kuti muchite izi, dinani "Ctrl" ndikudina kumanzere pazipilala zonse.
- Kenako, ingodinani kumanja pagawo losankhidwa ndikusankha "Bisani" kuchokera pamenyu yotsitsa.
- Pambuyo pakuchitapo kanthu, mizati yonse idzabisika.
Ndi mbali iyi, zidzatheka kubisala mwachangu zigawo zonse zomwe zilipo, ndikuwononga nthawi yochepa. Chinthu chachikulu ndikukumbukira dongosolo la zochita zonse ndikuyesera kuti musafulumire, kuti musalakwitse.
Njira 3: Zida za Riboni
Palinso njira ina yothandiza yomwe ingakwaniritse zotsatira zomwe mukufuna. Nthawi ino mudzagwiritsa ntchito chida pamwamba. Zochita zapachaka ndi izi:
- Gawo loyamba ndikusankha selo lazagawo lomwe mukufuna kubisa.
- Kenako pitani ku toolbar ndikugwiritsa ntchito gawo la "Home" kuti mupite ku chinthu cha "Format".
- Mu menyu omwe atsegulidwa, sankhani "Bisani kapena Onetsani", kenako sankhani "Bisani mizati".
Ngati zonse zachitika molondola, ndiye kuti zipilala zidzabisika ndipo sizidzadzaza tebulo. Njirayi imafikira kubisala ndime imodzi, komanso angapo nthawi imodzi. Ponena za kusesa kwawo, malangizo atsatanetsatane ogwiritsira ntchito izi adakambidwa pamwambapa, pogwiritsa ntchito, mutha kuwulula mizati yonse yobisika.
Kutsiliza
Tsopano muli ndi chidziwitso chonse chofunikira, chomwe m'tsogolomu chidzakulolani kugwiritsa ntchito mwakhama kubisa mizati yosafunikira, kupanga tebulo kukhala losavuta kugwiritsa ntchito. Iliyonse mwa njira zitatuzi sizovuta kugwiritsa ntchito ndipo imapezeka kwa aliyense wogwiritsa ntchito purosesa ya Excel spreadsheet - novice ndi akatswiri.