Pamene mukugwira ntchito ndi Excel, nthawi zambiri ndi koyenera kuyendetsa njira yochotsera mizere. Izi zingathe kukhala zomodzi komanso gulu, malingana ndi ntchito. Chochititsa chidwi makamaka pankhaniyi ndi kuchotsa chikhalidwecho. Tiyeni tiwone njira zosiyanasiyana zomwe mungachite.
Njira yochotsera njira
Mizere yochotsa ikhoza kuchitidwa mosiyana. Kusankha yankho linalake kumadalira ntchito zomwe wogwiritsa ntchito wapanga. Ganizirani njira zosiyanasiyana, kuyambira zosavuta ndi zomaliza ndi njira zovuta.
Njira 1: kuchotsa osakwatiwa kupyolera pa menyu
Njira yosavuta yochotsera mizere ndi njira imodzi yokha. Mukhoza kuyendetsa pogwiritsa ntchito menyu yoyenera.
- Dinani molondola pa maselo aliwonse a mzera kuti achotsedwe. M'ndandanda wamakono imene ikuwonekera, sankhani chinthucho "Chotsani ...".
- Fasilo yaing'ono imatsegulidwa kumene muyenera kufotokoza zomwe zimayenera kuchotsedwa. Chotsani chosinthira ku malo "Mzere".
Pambuyo pake, chinthu chofotokozedwacho chidzachotsedwa.
Mukhozanso kudinkhani batani lamanzere pamsana pa nambala ya mndandanda pamphindi wowonongeka. Ndiye muyenera kudinkhani pasankhidwe ndi batani lamanja la mouse. Mu menyu yoyanjidwa, sankhani chinthucho "Chotsani".
Pankhaniyi, ndondomeko yowonongeka imachitika mwamsanga ndipo palibe chifukwa chochitira zinthu zina pazenera posankha chinthu chopangira.
Njira 2: Kuchotsa Modzigwiritsira Ntchito Zida Zamatepi
Kuwonjezera apo, njirayi ingagwiritsidwe ntchito pogwiritsa ntchito zida pa tepi, zomwe zayikidwa pa tepi "Kunyumba".
- Sankhani kusankha kulikonse pamzere umene mukufuna kuchotsa. Pitani ku tabu "Kunyumba". Dinani pa chithunzicho mwa mawonekedwe a katatu kakang'ono, komwe kuli kumanja kwa chithunzi "Chotsani" mu chigawo cha zipangizo "Maselo". Mndandanda umaonekera momwe muyenera kusankha chinthu. "Chotsani mizere kuchokera pa pepala".
- Mzere udzachotsedwa pomwepo.
Mukhozanso kusankha mzere wonse mwa kudindira batani lamanzere pa nambala yake pazowonongeka. Pambuyo pake, pokhala pa tab "Kunyumba"dinani pazithunzi "Chotsani"anaikidwa mu chida cha zipangizo "Maselo".
Njira 3: Chotsani Bulk
Kuti gulu lichotse mizere, choyamba, muyenera kusankha zosankhidwazo.
- Kuti muchotse mizere yambiri yapafupi, mukhoza kusankha maselo omwe ali pafupi ndi mzerewu womwe uli m'mbali yomweyo. Kuti muchite izi, gwiritsani batani lamanzere ndi kugwedeza chithunzithunzi pazinthu izi.
Ngati mzerewu ndi waukulu, ndiye kuti mungasankhe selo lapamwamba kwambiri ponyanikiza ndi batani lamanzere. Ndiye gwirani chinsinsi Shift ndipo dinani selo yotsika kwambiri ya mtundu umene mukufuna kuchotsa. Zinthu zonse pakati pawo zidzasankhidwa.
Ngati m'pofunika kuchotsa mzere wa mzere umene uli patali kuchokera kwa wina ndi mzake, kuti uwasankhe, dinani pa selo limodzi lomwe liri ndi batani lamanzere pomwe panthawiyi muli ndi fungulo Ctrl. Zinthu zonse zosankhidwa zidzasindikizidwa.
- Kuti tichite mwatsatanetsatane pochotsa mizere, timatchula mndandanda wa zochitikazo kapena kupita ku zida za pa kaboni, ndiyeno tsatirani malangizo omwe anaperekedwa pofotokozera njira zoyamba ndi ziwiri za bukuli.
Mukhozanso kusankha zinthu zomwe mumazifuna kupyolera muzowonongeka. Pachifukwa ichi, osati maselo osiyana adzapatsidwa, koma mizere idzakhala kwathunthu.
- Kuti musankhe gulu lapafupi la mzere, gwiritsani botani lamanzere la khomo ndikukoka kolojekiti pamzere wozungulira wowonongeka kuchokera pamwamba pa mzere kuti muchotsedwe pansi.
Mukhozanso kugwiritsa ntchito njirayi pogwiritsa ntchito fungulo Shift. Dinani batani lamanzere la mzere pamzere woyamba mndandanda wamtundu womwe uyenera kuchotsedwa. Ndiye gwiritsani chinsinsi Shift ndipo dinani pa chiwerengero chomaliza cha malo omwe tawunikira. Mzere uliwonse wa mizere pakati pa manambala awa udzawonetsedwa.
Ngati mzere wochotsedwawo wasakalalikidwa pa pepala lonse ndipo musayimilirane wina ndi mzake, ndiye pakadali pano, muyenera kodina batani lamanzere pamasamba onse a mzerewu pamphindi wogwirizanitsa ndi fungulo lotsekedwa pansi Ctrl.
- Kuchotsa mizere yosankhidwa, dinani pa chisankho chilichonse ndi batani labwino la mouse. M'mawonekedwe a nkhani, timayima pa chinthucho "Chotsani".
Kuchita kuchotsa zinthu zonse zosankhidwa kudzachitika.
Phunziro: Momwe mungasankhire kusankha mu Excel
Njira 4: Chotsani Zinthu Zopanda
Nthawi zina tebulo ikhoza kukhala ndi mizere yopanda kanthu, deta yomwe idachotsedwa kale. Zinthu zoterezi zimachotsedwa bwino pa pepala konse. Ngati ali pafupi ndi wina ndi mzake, ndiye kuti n'zotheka kugwiritsa ntchito njira imodzi yomwe yanenedwa pamwambapa. Koma nanga bwanji ngati pali mizere yambiri yopanda kanthu ndipo idabalalika kudutsa lonse la tebulo lalikulu? Ndipotu, ndondomeko ya kufufuza ndi kuchotsa ikhoza kutenga nthawi yambiri. Kuti muthamangitse yankho la vutoli, mungagwiritse ntchito ndondomeko yotsatirayi.
- Pitani ku tabu "Kunyumba". Chida chotsekeka pajambulani pindani pazithunzi "Pezani ndi kuonetsa". Ipezeka mu gulu Kusintha. M'ndandanda yomwe imatsegula, dinani pa chinthucho "Kusankha gulu la maselo".
- Dindo laling'ono la kusankha gulu la maselo likuyamba. Ikani kusinthana pamalo "Maselo opanda kanthu". Pambuyo pake, dinani pa batani "Chabwino".
- Monga mukuonera, titagwiritsa ntchito izi, zinthu zonse zopanda kanthu zimasankhidwa. Tsopano mungagwiritse ntchito njira iliyonse yomwe takambirana pamwambapa kuti muwachotse. Mwachitsanzo, mukhoza kukhoza pa batani "Chotsani"yomwe ili pa thaboni mu tabu lomwelo "Kunyumba"kumene tikugwira ntchito tsopano.
Monga mukuonera, zolemba zonse zopanda kanthu zachotsedwa.
Samalani! Mukamagwiritsa ntchito njirayi, mzerewu uyenera kukhala wopanda kanthu. Ngati tebulo liri ndi zinthu zopanda kanthu zomwe ziri mu mzere zomwe ziri ndi deta, monga mu fano ili m'munsiyi, njira iyi siingagwiritsidwe ntchito. Kugwiritsa ntchito kwake kungaphatikize kusintha kwa zinthu ndi kuphwanya kapangidwe ka gome.
Phunziro: Momwe mungachotsedwe mzere wopanda kanthu mu Excel
Njira 5: Kugwiritsa Ntchito
Kuti muchotse mizere ndi chikhalidwe china, mukhoza kugwiritsa ntchito. Pambuyo pokonza zochitikazo malinga ndi zomwe zakhazikitsidwa, tidzatha kusonkhanitsa mizere yonse yomwe imakhutitsa chikhalidwe pamodzi ngati imabalalitsidwa patebulo, ndikuchotsa mwamsanga.
- Sankhani mbali yonse ya tebulo yomwe mungasankhe, kapena imodzi mwa maselo ake. Pitani ku tabu "Kunyumba" ndipo dinani pazithunzi "Sankhani ndi kusefera"yomwe ili mu gululo Kusintha. Pa mndandanda wa zosankha zomwe zatsegula, sankhani chinthucho "Yambani Mwambo".
Mukhozanso kuchita zinthu zina zomwe zingayambitse kutsegula mawindo. Mukasankha chinthu chilichonse cha tebulo, pitani ku tabu "Deta". Kumeneko mu gulu la machitidwe "Sankhani ndi kusefera" pressani batani "Sungani".
- Chizolowezi choyang'ana zenera chikuyamba. Onetsetsani kuti muwone bokosi ngati likusowa "Deta yanga ili ndi mutu"ngati tebulo lanu liri ndi mutu. Kumunda "Sankhani" muyenera kusankha dzina la ndimeyo, yomwe idzakhala yosankhidwa mwa mfundo zoyenera kuchotsa. Kumunda "Sungani" muyenera kufotokoza kuti ndiyiti yomwe idzagwiritsidwe ntchito kusankha:
- Miyambo;
- Mtundu wa selo;
- Mtundu wa mtundu;
- Chithunzi cha selo
Zonsezi zimadalira zochitika zina, koma nthawi zambiri izi ndizofunikira. "Makhalidwe". Ngakhale m'tsogolo tidzakambirana za kugwiritsa ntchito malo osiyana.
Kumunda "Dongosolo" muyenera kufotokoza momwe deta idzasinthidwe. Kusankhidwa kwa zofunika pamundawu kumadalira maonekedwe a deta ya gawoli. Mwachitsanzo, kwa deta zamtundu, dongosolo likanakhala "Kuyambira A mpaka Z" kapena "Z kwa A"ndi tsiku "Kuyambira kalekale kupita kwatsopano" kapena "Kuyambira kwatsopano kufikira yakale". Kwenikweni, dongosololo palokha sililibe kanthu, popeza zilizonse, zikhalidwe zomwe timachita chidwi nazo zidzakhala pamodzi.
Pambuyo pazenera pazenera iyi, dinani pa batani "Chabwino". - Deta yonse ya gawo losankhidwa idzasankhidwa ndi ndondomeko yoyenera. Tsopano tikhoza kusankha zinthu zoyandikana ndi zomwe mwasankha zomwe zinkakambidwa pokambirana njira zam'mbuyomu, ndi kuzichotsa.
Mwa njira, njira yomweyi ingagwiritsidwe ntchito popanga gulu ndi kuchotsa mitsinje yopanda kanthu.
Chenjerani! Tiyenera kukumbukira kuti pokonza mtundu uwu, mutachotsa maselo opanda pake, malo a mizera idzakhala yosiyana ndiyomweyo. Nthawi zina sikofunikira. Koma, ngati inu mukufunikira kubwezeretsa malo oyambirira, ndiye musanayambe kusankha, muyenera kumanga ndime yowonjezerapo ndikuwerengera mizere yonseyo, kuyambira yoyamba. Pambuyo pa zinthu zosafunikira zikuchotsedwa, mutha kuyisankhasanso ndi ndime yomwe chiwerengerochi chikupezeka kuchokera chaling'ono kwambiri mpaka chachikulu. Pachifukwa ichi, tebulo lidzakhala ndi dongosolo loyambirira, mwachibadwa kuchotsa zinthuzo.
Phunziro: Dongosolo lachidule mu Excel
Njira 6: Gwiritsani ntchito Kuwonetsa
Mukhozanso kugwiritsira ntchito chida monga kusinthana kuchotsa mizere yomwe ili ndi mfundo zenizeni. Ubwino wa njira iyi ndikuti ngati mutayesanso mzerewu, mukhoza kuwubwezera nthawi zonse.
- Sankhani tebulo lonse kapena mutu ndi chithunzithunzi chogwedezeka ndi batani lamanzere. Dinani pa batani lomwe tidziwa kale. "Sankhani ndi kusefera"yomwe ili pa tabu "Kunyumba". Koma nthawi ino, kuchokera mndandanda umene umatsegulira, sankhani malo "Fyuluta".
Mofanana ndi njira yapitayi, vuto lingathetsedwenso kudzera mu tabu "Deta". Kuti muchite izi, pokhala mmenemo, muyenera kutsegula pa batani "Fyuluta"yomwe ili mu chida chogwiritsa ntchito "Sankhani ndi kusefera".
- Pambuyo pochita zochitika zili pamwambazi, chizindikiro cha fyuluta chidzawonekera mu mawonekedwe a katatu katatu ndi mpweya wotsika pansi pafupi ndi malire abwino a selo iliyonse ya mutu. Dinani pa chizindikiro ichi mu gawo limene mtengo ulipo, umene tidzachotsa mzere.
- Mndandanda wa fyuluta imatsegula. Timachotsa nkhupakupa kuchokera ku mfundo zomwe tikufuna kuchotsa. Pambuyo pake muyenera kusindikiza batani "Chabwino".
Motero, mizere yomwe ili ndi zikhalidwe zomwe mwachotsa zizindikirozo zidzabisika. Koma iwo amatha kubwezeretsedwa kachiwiri mwa kuchotsa kufutukula.
Phunziro: Kugwiritsa ntchito fyuluta moposa
Njira 7: Kujambula Momwemo
Mukhoza kupatula bwino magawo osankha mizere, ngati mugwiritsira ntchito zipangizo zojambula zovomerezeka pamodzi ndikusankha kapena kusamba. Pali zambiri zomwe mungachite kuti mulowe muyesoyi, choncho tiwone chitsanzo chapadera kuti muthe kuzindikira momwe mungagwiritsire ntchito mbaliyi. Tiyenera kuchotsa mizere yomwe ili patebulo lomwe ndalama zomwe zili ndi ndalama zosakwana 11,000.
- Sankhani ndimeyi "Kuchuluka kwa ndalama"Kumene tikufuna kugwiritsa ntchito maonekedwe ovomerezeka. Kukhala mu tab "Kunyumba", dinani pazithunzi "Mafomu Okhazikika"zomwe ziri pa tepi mu chipika "Masitala". Pambuyo pake mndandanda wa zochitika zimatsegulidwa. Sankhani malo pamenepo "Malamulo a kusankha kusankhidwa". Menyu ina yowonjezera imayambika. Ndikofunikira kuti musankhe mwachindunji chomwe chilipo cha lamulolo. Payenera kukhala kale kusankha kuchokera pa vuto lenileni. Mulimonsemo, muyenera kusankha malo. "Pang'ono ...".
- Fenje yowonongeka yokha imayamba. Kumanzere kumanzere kuyika mtengo 11000. Miyezo yonse yomwe ili yochepa kuposa yomwe idzapangidwe. Kumalo abwino mungasankhe mtundu uliwonse wa maonekedwe, ngakhale mutha kuchoka mtengo wosasintha pamenepo. Pambuyo mapangidwe apangidwa, dinani pa batani "Chabwino".
- Monga momwe mukuonera, maselo onse omwe ali ndi chiwerengero cha ndalama zopitirira 11,000 rubles, anajambula mu mtundu wosankhidwa. Ngati tifunika kusunga dongosolo loyambirira, titachotsa mizere, timapitiriza kuwerengera m'ndandanda pafupi ndi tebulo. Timayambitsa zenera zowonekera, zomwe tidziwa kale "Kuchuluka kwa ndalama" Njira iliyonse yomwe takambirana pamwambapa.
- Kuwonekera mawindo kumatsegulira. Monga nthawi zonse, samalirani za chinthu "Deta yanga ili ndi mutu" panali chongani. Kumunda "Sankhani" timasankha khola "Kuchuluka kwa ndalama". Kumunda "Sungani" ikani mtengo Cell Colour. Mu gawo lotsatila, sankhani mtundu, mizere yomwe mukufuna kuchotsa, malingana ndi malembawo. Kwa ife ndi pinki. Kumunda "Dongosolo" sankhani kumene zidutswa zija zidzaikidwa: pamwamba kapena pansi. Komabe, ziribe kanthu. Ndiyeneranso kukumbukira kuti dzina "Dongosolo" akhoza kusinthidwa kumanzere kwa munda wokha. Pambuyo pokonza zonsezi tawonani, dinani pa batani. "Chabwino".
- Monga momwe mukuonera, mizere yonse yomwe ilipo maselo osankhidwa ndi chikhalidwecho pamodzi. Zidzakhala pamwamba kapena pansi pa gome, malingana ndi zomwe zimagwiritsidwa ntchito ndi wosuta pazenera. Tsopano timangosankha mizere iyi mwa njira yomwe timasankha, ndipo timayisula pogwiritsa ntchito makina ozungulira kapena batani pa ndodo.
- Ndiye mutha kukonza malingaliro ndi chiwerengero ndi chiwerengero kuti tebulo lathu lilowetsedwe kale. Khola losafunika ndi manambala lingachotsedwe pakusankha ilo ndi kudindikiza batani limene tikulidziwa "Chotsani" pa tepi.
Ntchito yodalirikayi imathetsedwa.
Kuphatikizanso, mungathe kuchita zofananako ndi zolemba zovomerezeka, koma pambuyo pake mutha kufotokoza deta.
- Choncho, gwiritsani ntchito maonekedwe ovomerezeka ku khola. "Kuchuluka kwa ndalama" chifukwa cha zochitika zofanana. Timathandiza kuwonetsera mu tebulo chimodzi mwa njira zomwe zafotokozedwa kale pamwambapa.
- Kamodzi pamutu pali zithunzi zosonyeza fyuluta, dinani pa yomwe ili m'mbali "Kuchuluka kwa ndalama". Mu menyu yomwe imatsegula, sankhani chinthucho "Fyulani ndi mtundu". Muzitsulo zamkati "Sakanizani ndi selo" sankhani mtengo "Osadzaza".
- Monga mukuonera, mutatha izi, mizere yonse yomwe idadzazidwa ndi mtundu pogwiritsa ntchito maonekedwe ovomerezeka inatheratu. Zili zobisika ndi fyuluta, koma ngati mutachotsa kufutukula, pakadali pano, zinthu zomwe zafotokozedwa zidzawonekera kachidwi.
Phunziro: Mafomu omvera mu Excel
Monga mukuonera, pali njira zazikulu kwambiri zochotsera mizere yosafunika. Njira yomwe mungagwiritse ntchito ikudalira ntchito ndi chiwerengero cha zinthu zomwe ziyenera kuchotsedwa. Mwachitsanzo, kuchotsa mzere umodzi kapena awiri ndizotheka kuchita ndi zida zowonongeka. Koma kuti musankhe mizere yambiri, maselo opanda kanthu kapena zinthu mogwirizana ndi mkhalidwe wapatsidwa, palinso zinthu zomwe zimapangitsa kuti ntchitoyi ikhale yosavuta kwa ogwiritsa ntchito ndikusunga nthawi yawo. Zida zoterezi zikuphatikizapo mawindo posankha gulu la maselo, kusankha, kufuta, maonekedwe ovomerezeka, ndi zina zotero.
