Pamene mukugwira ntchito mu Excel, nthawizina mumayenera kuwerenga chiwerengero cha mizera ya mtundu wina. Izi zikhoza kuchitika m'njira zingapo. Tiyeni tifufuze ndondomekoyi kuti tigwiritse ntchito njirayi pogwiritsa ntchito njira zosiyanasiyana.
Kusankha nambala ya mizere
Pali njira zambiri zodziwira nambala ya mizere. Pogwiritsa ntchito, zipangizo zosiyanasiyana zimagwiritsidwa ntchito. Choncho, muyenera kuyang'ana nkhani yeniyeni kuti musankhe njira yabwino kwambiri.
Njira 1: pointer muzenera bar
Njira yosavuta yothetsera ntchitoyo mwasankhidwa ndi kuyang'ana kuchuluka kwazomwe zilili. Kuti muchite izi, mungosankha mtundu womwe mukufuna. Ndikofunika kuganizira kuti dongosolo limaganizira selo iliyonse ndi deta ya gawo limodzi. Choncho, kuti tipewe kuwerengera kawiri, popeza tikuyenera kudziwa chiwerengero cha mizere, timasankha kokha limodzi m'dera lomwe taphunzira. Muzenera zobwereza pambuyo pa mawu "Zambiri" Chizindikiro cha nambala yeniyeni ya zinthu zodzazidwa muzithunzi zosankhidwa zidzawonekera kumanzere kwa mabatani kuti mutsegule machitidwe owonetsera.
Komabe, zimakhalanso ngati palibe ndondomeko zodzazidwa patebulo, ndipo pali mfundo mumzere uliwonse. Pankhaniyi, ngati titasankha mzere umodzi wokha, ndiye kuti zinthu zomwe zilibe zikhulupiliro pazomwezi sizingaphatikizidwe muwerengedwe. Kotero, nthawi yomweyo timasankha ndime yeniyeni yeniyeni, ndiyeno, titagwira batani Ctrl dinani maselo odzaza m'mitsinje yomwe inali yopanda kanthu m'kaundula yosankhidwa. Pankhaniyi musasankhe selo limodzi pamzere. Choncho, chiwerengero cha mizere yonse yosankhidwa yomwe selo imodzi yadzaza idzawonetsedwa muzenera zadongosolo.
Koma palinso zochitika pamene mumasankha maselo odzaza m'mizera, ndipo chiwonetsero cha nambala pa barolo ladindo sichiwonekera. Izi zikutanthawuza kuti gawo ili ndilolemale. Kuti muwathandize, dinani pomwepa pa barre yavota ndi menyu yomwe ikuwoneka, yikani nkhuni kutsutsana ndi mtengo "Zambiri". Tsopano chiwerengero cha mizere yosankhidwa chidzawonetsedwa.
Njira 2: Gwiritsani ntchito ntchitoyi
Koma, njira yomwe ili pamwambayi siyilola kulemba zotsatira zowerengera m'malo enaake pa pepala. Kuphatikiza apo, zimapereka mphamvu yokha kuwerenga mizere yomwe ili ndi mfundo, ndipo nthawi zina ndikofunikira kuwerengera zinthu zonse kuphatikizapo zopanda kanthu. Pankhaniyi, ntchitoyi idzapulumutsidwa. PUTSANI. Mawu ake omasulira ndi awa:
= NKHANI (gulu)
Ikhoza kuyendetsedwa mu selo iliyonse yopanda kanthu pa pepala, ndipo ngati mkangano "Mzere" alowetsani zigawo zosiyana siyana zomwe mungachite.
Kuti muwonetse zotsatirapo pazenera, tangoyanikizani batani. Lowani.
Komanso, ngakhale mizera yonse yopanda kanthu idzawerengedwa. Ndikoyenera kuzindikira kuti, mosiyana ndi njira yapitayi, ngati mutasankha malo omwe ali ndi zipilala zingapo, woyendetsa adzawerengera mizere yokha.
Kwa ogwiritsa ntchito omwe sadziwa zambiri mu Excel, zimakhala zosavuta kugwira ntchito ndi wogwiritsa ntchito Mlaliki Wachipangizo.
- Sankhani selo momwe zotsatira zazomwe zatha zisonyezedwa. Timakanikiza batani "Ikani ntchito". Imaikidwa nthawi yomweyo kumanzere kwa bar.
- Fenje yaing'ono ikuyamba. Oyang'anira ntchito. Kumunda "Magulu" ikani malo "Zolumikizana ndi zolemba" kapena "Mndandanda wathunthu wa alfabeti". Ndikuyang'ana mtengo CHSTROKsankhani ndipo dinani pa batani "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. Ikani cholozera mmunda "Mzere". Timasankha pa pepala lomwe liripo, nambala ya mizere yomwe mukufuna kuwerenga. Pambuyo pa makonzedwe a malo awa akuwonetsedwa mmunda wa zenera zotsutsana, dinani pa batani "Chabwino".
- Purogalamuyi imagwiritsa ntchito deta ndikuwonetsera zotsatira za kuwerengera mizere mu selo yoyambirira. Tsopano zotsatirazi zidzawonetsedwa kwamuyaya m'dera lino ngati simusankha kuchotsa pachokha.
Phunziro: Excel ntchito wizara
Njira 3: Gwiritsani ntchito Fyuluta ndi Kujambula Momwemo
Koma pali milandu pamene kuli kofunikira kuwerengera mizere yonse yosiyanasiyana, koma okhawo omwe amakumana ndi chikhalidwe china. Pachifukwa ichi, kufotokozera mwachidindo ndi kusungunula komweko kudzakuthandizira.
- Sankhani mtundu umene chikhalidwecho chidzayang'aniridwa.
- Pitani ku tabu "Kunyumba". Pa tepiyi mu chida cha zipangizo "Masitala" pressani batani "Mafomu Okhazikika". Sankhani chinthu "Malamulo a kusankha kusankhidwa". Kuwonjezera apo mfundo ya malamulo osiyanasiyana imatsegulidwa. Kwa chitsanzo chathu, timasankha chinthucho "Zambiri ...", ngakhale kuti nthawi zina chisankhocho chikhoza kuimitsidwa pamalo osiyana.
- Fenera ikutsegula momwe chikhalidwecho chikhazikidwira. Kum'mbali kwamanzere, timasonyeza nambala, maselo omwe ali ndi phindu lalikulu kuposa ilo, adzalengedwa ndi mtundu wina. Mu malo abwino muli mwayi wosankha mtundu uwu, koma mukhoza kuchoka mwachinsinsi. Pambuyo pa kukhazikitsa chikhalidwecho, tamitsani pa batani. "Chabwino".
- Monga mukuonera, patatha izi, maselo omwe amakhutitsa vutoli anadzazidwa ndi mtundu wosankhidwa. Sankhani zonse zamtengo wapatali. Kukhala mu onse omwe ali tab "Kunyumba", dinani pa batani "Sankhani ndi kusefera" mu gulu la zida Kusintha. Mundandanda womwe ukuwonekera, sankhani chinthucho "Fyuluta".
- Pambuyo pake, chithunzi chafyuluta chimapezeka m'mitu ya mndandanda. Dinani pazomwe zili m'ndandanda yomwe inakonzedwa. Mu menyu yomwe imatsegula, sankhani chinthucho "Fyulani ndi mtundu". Kenaka, dinani pa mtundu, umene uli ndi maselo ophatikizidwa omwe amakwaniritsa vutoli.
- Monga momwe mukuonera, maselo osatchulidwa mtundu pambuyo pochita izi. Sankhani maselo osiyanasiyana otsala ndikuyang'ana chizindikiro "Zambiri" mu barre ya udindo, monga pothetsa vutoli mwanjira yoyamba. Ndi nambala iyi yomwe idzasonyeze chiwerengero cha mizere yomwe imakwaniritsa vuto linalake.
Phunziro: Mafomu omvera mu Excel
Phunziro: Sakanizani ndi kusinkhira deta mu Excel
Monga momwe mukuonera, pali njira zingapo zodziwira nambala ya mizere pakusankhidwa. Njira iliyonseyi ndi yoyenera kugwiritsa ntchito zolinga zenizeni. Mwachitsanzo, ngati mukufuna kukonza zotsatirazi, ndiye kuti ntchitoyo ndi yoyenera, ndipo ngati ntchitoyo iyenera kuwerengera mizere yomwe imakhala ndi vuto linalake, ndiye kuti mapangidwe amodzimodzi amatha kupulumutsidwa, otsatiridwa ndi kufufuza.
