Pogwira ntchito ndi matebulo, nthawi zambiri ndikofunikira kuti muwerenge manambala. Zachidziwikire, izi zitha kuchitika pamanja, payekhapayekha poyendetsa nambala yolumikizana pachidutswa chilichonse. Ngati tebulo lili ndi mizati yambiri, zimatenga nthawi yambiri. Excel ili ndi zida zapadera zomwe zimakuthandizani kuti muwerengere mwachangu. Tiyeni tiwone momwe amagwirira ntchito.
Njira Zowerengetsera
Pali zosankha zingapo zamakalata odzilemba okha mu Excel. Ena mwa iwo ndi osavuta kumva komanso omveka, ena ndi ovuta kuwazindikira. Tiyeni tikhazikike pa aliyense wa iwo kuti tiwone kuti ndi njira yanji yomwe angagwiritsire ntchito bwino.
Njira 1: lembani chikhomo
Njira yodziwika kwambiri yolemba manambala ndi kugwiritsa ntchito chikhomo.
- Timatsegula tebulo. Onjezani chingwe, komwe adzaika mzere. Kuti muchite izi, sankhani khungu lililonse mzere lomwe likhala m'munsi mwa manambala, dinani kumanja, ndikusintha menyu yanu. Pamndandanda, sankhani "Patani ...".
- Windo laling'ono lophimba limatsegulidwa. Sinthani kusintha "Wonjezerani mzere". Dinani batani "Zabwino".
- Ikani manambala mu foni yoyamba ya mzere wowonjezerapo "1". Kenako sunthani chofikira kumakona akumunsi a tsamba ili. Chopereka chimasandulika mtanda. Amatchedwa chikhomo chodzaza. Nthawi yomweyo gwiritsani batani lakumanzere ndi kiyi Ctrl pa kiyibodi. Kokani chodzaza kumanja kumapeto kwa tebulo.
- Monga mukuwonera, mzere womwe timafunikira umadzazidwa ndi manambala mwadongosolo. Ndiko kuti, kuwerengera kwa mizati kunachitika.
Mutha kuchitanso zina. Dzazani maselo awiri oyambira mzere wowonjezerawo ndi manambala "1" ndi "2". Sankhani maselo onse awiri. Khazikitsani cholowezera kumunsi chakumanja kwa dzanja lamanja la iwo. Ndi batani la mbewa ndikanikizidwa, kokerani chikhomo mpaka kumapeto kwa tebulo, koma pano pofika Ctrl palibe chifukwa chokanikiza. Zotsatira zake zidzakhala chimodzimodzi.
Ngakhale mtundu woyamba wa njirayi umawoneka wosalira zambiri, komabe, ogwiritsa ntchito ambiri amakonda kugwiritsa ntchito yachiwiri.
Palinso njira ina yogwiritsira ntchito cholozera.
- Mu foni yoyamba timalemba nambala "1". Pogwiritsa ntchito chikhomo, koperani zomwe zili kumanja. Pankhaniyi, kachiwiri batani Ctrl palibe chifukwa chowomba.
- Akamaliza kukopera, tikuwona kuti mzere wonse udadzazidwa ndi nambala ya "1". Koma timafunikira manambala mwadongosolo. Timadina pachizindikiro chomwe chidawoneka pafupi ndi foni yotsiriza yomaliza. Mndandanda wazomwe zikuwoneka. Khazikitsani kusintha Dzazani.
Pambuyo pake, maselo onse amtundu wosankhidwa adzadzazidwa ndi manambala mwatsatanetsatane.
Phunziro: Momwe mungachite mosamalitsa mu Excel
Njira 2: kuwerenga manambala pogwiritsa ntchito batani la "Dzazani" pa riboni
Njira ina yowerengera makolamu mu Microsoft Excel ndikugwiritsa ntchito batani Dzazani pa tepi.
- Mzere utawonjezedwa polemba manambala, timalowetsa nambala mu foni yoyamba "1". Sankhani mzere wonse wa tebulo. Kukhala mu "Home" tabu, pa riboni dinani batani Dzazaniili mu chipangizo "Kusintha". Menyu yotsitsa ikuwoneka. Mmenemo, sankhani chinthucho "Kupita patsogolo ...".
- Zenera lakutsogolo limatseguka. Magawo onse pamenepo ayenera kukhala atakonzedwa kale monga tikufunikira. Komabe, sikungakhale kopepuka kuyang'ana momwe alili. Mu block "Malo" kusinthana kuyenera kukhazikitsidwa Mzere ndi mzere. Pamagawo "Mtundu" ziyenera kusankhidwa "Arithmetic". Kukhazikika kwa magawo oyendetsa galimoto kuyenera kulemala. Ndiye kuti, sikofunikira kuti pali cheke pafupi ndi dzina lofananira. M'munda "Khwerero" onani kuti nambala ndi "1". Mundawo "Mtengo wochepera" ikhale yopanda kanthu. Ngati gawo lililonse silikugwirizana ndi zomwe zanenedwa pamwambapa, sintha monga momwe tikulimbikitsira. Mukatha kuwonetsetsa kuti magawo onse adzazidwe molondola, dinani batani "Zabwino".
Pambuyo pa izi, zipilala za tebulo zidzawerengedwa mu dongosolo.
Simungathe kusankha mzere wonse, koma ingoikani manambala mu foni yoyamba "1". Kenako imbani zenera la momwe zinthu zikuyendera monga momwe tafotokozera pamwambapa. Magawo onse amayenderana ndi omwe takambirana kale, kupatula pamunda "Mtengo wochepera". Iyenera kuyika kuchuluka kwa mizati patebulopo. Kenako dinani batani "Zabwino".
Kudzaza kudzachitika. Njira yotsirizayi ndi yabwino kwa matebulo okhala ndi ziphuphu zochulukirapo, chifukwa mukamachigwiritsa ntchito, simuyenera kukoka tembeyo kulikonse.
Njira 3: Ntchito ya ColUMN
Muthanso kuwerengera mzati pogwiritsa ntchito ntchito yapadera, yomwe imatchedwa NKHANI.
- Sankhani khungu lomwe nambala iyenera kukhalamo "1" polemba manambala. Dinani batani "Ikani ntchito"atayikidwa kumanzere kwa barula yamu formula.
- Kutsegula Fotokozerani Wizard. Ili ndi mndandanda wa ntchito zosiyanasiyana za Excel. Tikufuna dzina STOLBETS, sankhani ndikudina batani "Zabwino".
- Ntchito yotsutsana ndi ntchito imatsegulidwa. M'munda Lumikizani Muyenera kutchulapo ulalo wa khungu lililonse patsamba loyamba la pepalalo. Pakadali pano, ndikofunikira kulipira chidwi, makamaka ngati gawo loyambirira la gome siliri loyamba la pepalalo. Adilesi yolumikizira imatha kuikidwa pamanja. Koma ndikosavuta kuchita izi ndikukhazikitsa temberero m'munda Lumikizani, kenako ndikudina foni yomwe mukufuna. Monga mukuwonera, zitatha izi, ma mgwirizano ake amawonetsedwa m'munda. Dinani batani "Zabwino".
- Pambuyo pa izi, nambala imawonekera mu foni yosankhidwa "1". Kuti tiwerenge mzati wonse, timayimilira pakona yake ya kumunsi ndikutcha chikhomo. Monga m'nthawi zam'mbuyomu, kokerani kumanja kumapeto kwa tebulo. Gwirani fungulo Ctrl osafunikira, dinani batani loyenera lam mbewa.
Mukamaliza masitepe onse pamwambapa, zipilala zonse za tebulo zidzawerengedwa mu dongosolo.
Phunziro: Ntchito Wizard ku Excel
Monga mukuwonera, pali njira zingapo zowerengera zigawo za Excel. Chodziwika kwambiri mwa izi ndi kugwiritsa ntchito cholemba. Matebulo athunthu omveka bwino amagwiritsa ntchito batani Dzazani ndi kusintha kwa makonzedwe akukula. Njirayi sikuphatikiza kuwongolera chidziwitso mu ndege yonse. Kuphatikiza apo, pali ntchito yapadera. NKHANI. Koma chifukwa chovuta kugwiritsa ntchito komanso kuchenjera, njirayi siyotchuka ngakhale pakati pa ogwiritsa ntchito apamwamba. Inde, ndipo njirayi imatenga nthawi yochulukirapo kuposa momwe amagwiritsira ntchito chikhomo.
