Nthawi zambiri popanga matebulo ku Excel, mzere womwe umagawidwa, womwe, kuti uzitha kugwiritsa ntchito, manambala amzere amasonyezedwa. Ngati tebulo silitali kwambiri, ndiye kuti si vuto lalikulu kuti manambala manambala mwa kulowa manambala kuchokera ku kiyibodi. Koma chochita ngati chikhala ndi mizere yoposa dazeni, kapena kuposanso mizere zana? Poterepa, kuwerenga manambala kumangodzipulumutsa. Tiyeni tiwone momwe mungachitire kuchuluka kwaumwini mu Microsoft Excel.
Kuwerenga
Microsoft Excel imapatsa ogwiritsa ntchito njira zingapo zowerengetsera mizereyo. Zina mwazo ndizosavuta momwe zingathere, zonse mu ntchito ndikupanga magwiridwe antchito, pomwe zina ndizovuta, koma zilinso ndi mwayi waukulu.
Njira 1: lembani mizere iwiri yoyambirira
Njira yoyamba imaphatikizapo kudzaza pamanja mizere iwiri yoyamba ndi manambala.
- Mu mzere woyamba wa mzere womwe udaperekedwa manambala, ikani manambala - "1", m'gawo lachiwiri (la mzere womwewo) - "2".
- Sankhani ma cell awiri awa. Tikufika pakona ya m'munsi mwa otsika kwambiri. Chizindikiro Dinani kumanzere ndikugwira batani, kokerani mpaka kumapeto kwa tebulo.
Monga mukuwonera, kuwerengera kwa mizere kumangodzazidwa mwadongosolo.
Njirayi ndiyosavuta komanso yosavuta, koma ndiyabwino kwa magome ochepa, popeza ndizovuta kujambula chizindikiro patebulo la mazana angapo kapena masauzande angapo.
Njira 2: gwiritsani ntchito ntchito
Njira yachiwiri yakukwanira kugwiritsa ntchito ntchitoyi LERO.
- Sankhani khungu lomwe nambala ya "1" ya manambala idzakhala. Lowetsani mawuwo mu mzere wa njira "= STRING (A1)".Tanizani batani ENG pa kiyibodi.
- Monga momwe zinalili kale, pogwiritsa ntchito chodzaza, ikani mawu am'magawo am'munsi mwa tebulo la mgawo Pokhapokha pano sitisankha maselo awiri oyamba, koma amodzi.
Monga mukuwonera, mzere kuwerengera mzerewu wakonzedwa mwadongosolo.
Koma, mokulira, njirayi siyosiyana kwambiri ndi yapita ndipo siyi yankho la vuto lakufunika kokoka chikhomo patebulo lonse.
Njira 3: kugwiritsa ntchito momwe munthu akufotokozera
Njira yachitatu yokha yogwiritsira ntchito kupitirira patsogolo ndiyoyenera matebulo aatali okhala ndi mizere yambiri.
- Timawerenga nambala yoyamba mwa njira yanthawi zonse, ndikulowetsa nambala ya "1" pa kiyibodi.
- Pa nthiti ya "Editing" yamatayala, yomwe ili patsamba "Pofikira"dinani batani Dzazani. Pazosankha zomwe zimawonekera, dinani chinthucho "Kupita patsogolo".
- Zenera limatseguka "Kupita patsogolo". Pamagawo "Malo" muyenera kukhazikitsa kusintha Column ndi safu. Paramu switch "Mtundu" ayenera kukhala m'malo "Arithmetic". M'munda "Khwerero" muyenera kukhazikitsa nambala ya "1", ngati ina yayikidwa pamenepo. Onetsetsani kuti mwadzaza mundawo "Mtengo wochepera". Apa muyenera kuwonetsa kuchuluka kwa mizere yomwe ikuyenera kuwerengedwa. Ngati gawo ili silinadzazidwe, kuwerengetsa kokha sikungachitike. Pamapeto, dinani batani "Chabwino".
Monga mukuwonera, gawo la izi, mizere yonse ya tebulo lanu idzawerengeka yokha. Pankhaniyi, simuyenera kukoka chilichonse.
Njira ina, mutha kugwiritsa ntchito njira yotsatira:
- Mu foni yoyamba, ikani manambala "1", kenako sankhani maselo onse omwe mukufuna kuti muwerenge.
- Imbani chida chida "Kupita patsogolo" momwemonso momwe tidakambirana pamwambapa. Koma nthawi ino, palibe chomwe chikufunika kulowa kapena kusinthidwa. Kuphatikiza, ikani zambiri m'munda "Mtengo wochepera" Sadzayenera, chifukwa mtundu womwe ukufunidwa udawonetsedwa kale. Ingodinani batani "Chabwino".
Izi ndi zabwino chifukwa simuyenera kudziwa kuti mizereyo ili ndi mizere ingati. Nthawi yomweyo, muyenera kusankha maselo onse am'mizindayo ndi manambala, zomwe zikutanthauza kuti tibwereranso ku zomwe zinali momwe tinali kugwiritsa ntchito njira zoyambirira: kufunika kosuntha tebulo mpaka pansi.
Monga mukuwonera, pali njira zitatu zazikulu zolembetsera mizere mu pulogalamu. Mwa izi, kusankha ndi kuwerengera kwa mizere iwiri yoyambirira ndikutengera (monga yosavuta) komanso kusankha kugwiritsa ntchito kupitirira (chifukwa chogwira ntchito ndi miyala yayikulu) kuli ndi phindu lalikulu kwambiri.
