Kawirikawiri, popanga matebulo mu Excel, pali gawo losiyana lomwe, mosavuta, limasonyeza manambala a mzere. Ngati tebulo silikhala lalitali kwambiri, ndiye kuti si vuto lalikulu kupanga nambala yolembera polemba manambala kuchokera ku kibokosilo. Koma chiyani choti uchite ngati ulibe ngakhale khumi, kapena mazana khumi? Pankhaniyi, kuwerengetsa mwachindunji kumawathandiza. Tiyeni tipeze momwe tingachitire kuwerengera mwatsatanetsatane mu Microsoft Excel.
Kuwerenga
Microsoft Excel imapereka ogwiritsa ntchito njira zingapo kuti awerengere mzere. Zina mwa izo ndi zophweka monga momwe zingathere, ponse pakupha ndi kumagwira ntchito, pamene zina ndi zovuta, komanso zimaphatikizapo mwayi waukulu.
Njira 1: Lembani mizere iwiri yoyamba
Njira yoyamba imaphatikizapo kudzaza mzere woyamba mu mizere iwiri yoyamba ndi nambala.
- Mu ndime yowonjezera ya mzere woyamba, ikani nambala - "1", mu yachiwiri (mzere womwewo) - "2".
- Sankhani maselo awiriwa. Timakhala ngodya yolondola yazitali kwambiri. Chizindikiro chodzaza chikuwonekera. Timakanikiza ndi batani lamanzere lachitsulo ndi batani lokanikizidwa, kukokera pansi mpaka kumapeto kwa tebulo.
Monga momwe mukuonera, mndandanda wa kulembera ndiwongoleratu.
Njirayi ndi yophweka komanso yosavuta, koma ndi yabwino pokhapokha magome ang'onoang'ono, chifukwa kukoka chizindikiro pa tebulo la mizere mazana angapo kapena zikwi zambiri kuli kovuta.
Njira 2: Gwiritsani ntchito ntchitoyi
Njira yachiwiri yodzaza modzidzimutsa ikuphatikizapo kugwiritsa ntchito ntchitoyi "LINE".
- Sankhani selo yomwe ili ndi chiwerengero cha "1" chiwerengero. Lowetsani mawuwo mu chingwe cha ma fomu "LINE (A1)"Dinani pa fungulo ENTER pabokosi.
- Monga momwe zinalili kale, timakopera mawonekedwe m'maselo apansi a tebulo la ndimeyi pogwiritsira ntchito chikhomo chodzaza. Nthawi iyi yokha sitingasankhe maselo awiri oyambirira, koma amodzi okha.
Monga mukuonera, chiwerengero cha mizere ndipo panopa chikukonzedwa.
Koma, mwa njirayi, njirayi si yosiyana kwambiri ndi yapitayi ndipo siyathetsa vutoli ndi kufunikira kodula chidindo kupyola tebulo lonse.
Njira 3: Kugwiritsa Ntchito Kupita patsogolo
Njira yachitatu yokhala ndi chiwerengero choyendera ndi yoyenera kwa matebulo aakulu ndi mizere yambiri.
- Selo yoyamba yayamba mwa njira yowonjezera, atalowa mmenemo nambala "1" kuchokera ku kibokosi.
- Pa kavalo mu barabu yowonjezera "Kusintha," yomwe ili mu "Kunyumba"pressani batani "Lembani". Mu menyu imene ikuwonekera, dinani pa chinthucho "Kupitirira".
- Window ikutsegula "Kupitirira". Muyeso "Malo" muyenera kuyika kasinthasintha kuti muthe "Ndi ndondomeko". Parameter amasintha Lembani " ayenera kukhala pamalo "Masamu". Kumunda "Khwerero" muyenera kuyika nambala "1", ngati inayikidwa yina. Onetsetsani kuti mudzaze munda "Pezani mtengo". Pano muyenera kufotokoza nambala ya mizere kuti iwerengedwe. Ngati parameter iyi ilibe, kuwerengetsa kosavuta sikungapangidwe. Pamapeto pake, dinani pakani "OK".
Monga momwe mukuonera, gawo la zonsezi m'tawuni yanu liwerengedwa mosavuta. Pachifukwa ichi, ngakhale kanthu koti kukoka sikenera.
Monga njira ina, mungagwiritse ntchito ndondomeko yotsatirayi:
- Mu selo yoyamba ikani nambala "1", ndiyeno sankhani maselo osiyanasiyana omwe mukufuna kuwerengera.
- Lumikizani zenera zenera "Kupitirira" mwa njira yomweyo yomwe tinayankhulira pamwambapa. Koma nthawi ino simukusowa kulowa kapena kusintha chirichonse. Kuphatikizapo, lowetsani deta m'munda "Pezani mtengo" Sichiyenera, chifukwa mtundu womwe ukufunidwa watsala kale. Dinani kokha pa batani "OK".
Njira iyi ndi yabwino chifukwa simusowa kuti mupeze mizere yambiri. Pa nthawi imodzimodziyo, muyenera kusankha maselo onse m'ndandanda ndi nambala, zomwe zikutanthauza kuti tibwerera ku chinthu chimodzimodzi monga kugwiritsa ntchito njira zoyamba: kufunika kopukuta tebulo mpaka pansi.
Monga momwe mukuonera, pali njira zitatu zodziwerengera mizere pulogalamuyo. Mwa izi, kusiyana kwa chiwerengero cha mizere iwiri yoyamba ndi zotsatira zotsanzira (monga zosavuta) ndi zosiyana pogwiritsa ntchito njira (chifukwa chotha kugwira ntchito ndi matebulo aakulu) ali ndi phindu lalikulu kwambiri.
