Uburyo bwo guhisha imirongo nu selile muri excel

Iyo ukorera muri gahunda ya Excel, akenshi birashoboka cyane kubona ibihe aho igice cyingenzi cyibabi cyakoreshejwe gusa kubara kandi ntabwo bifata amakuru yumukoresha. Amakuru nkaya afata umwanya gusa kandi arangaza. Mubyongeyeho, niba umukoresha azavuna intege kubwimpanuka, arashobora kurenga ku mubare wose wo kubara mu nyandiko. Kubwibyo, imirongo nkiyi cyangwa selile kugiti cye nibyiza kwihisha. Mubyongeyeho, urashobora guhisha ayo makuru akenewe byigihe gito kugirango badashobora kwivanga. Reka tumenye uburyo bushobora gukorwa.

Kwihisha

Guhisha selile muri Excele birashobora kuba inzira zitandukanye rwose. Reka duheke kuri buri wese kugirango uyikoresha ubwe ashobore kumva, mubihe bizaba byiza gukoresha amahitamo yihariye.

Uburyo 1: Gutsinda

Bumwe mu buryo buzwi cyane bwo guhisha ibintu ni itsinda ryabo.

1. Turagaragaza imirongo yimpapuro zigomba guhurizwa, hanyuma uhisha. Ntabwo ari ngombwa gutanga umugozi wose, kandi urashobora kugaragara hafi ya selile imwe mumirongo yisumbuye. Ibikurikira, jya kuri tab "data". Muri "imiterere", iherereye kuri kaseti ya kaseti, kanda buto ya "Gusya".



2. Idirishya rito rifungura, ritanga guhitamo ibikenewe rwose: imirongo cyangwa inkingi. Kubera ko dukeneye itsinda ryamatsinda, ntabwo dukora impinduka zose kumiterere, kuko ihinduka risanzwe rishyizwe kumwanya dukeneye. Kanda kuri buto ya "OK".



3. Nyuma yibyo, hashyizweho itsinda. Kugira ngo uhishe amakuru aherereyemo arahagije kugirango ukande ku gishushanyo muburyo bwa "anus". Ishyirwa ibumoso bwumurongo uhagaze uhagaze.



4. Nkuko mubibona, imirongo irahishe. Kugirango wongere kubereka, ugomba gukanda ikimenyetso "wongeyeho".

Isomo: Uburyo bwo Gutera Amatsinda muri Excel

Uburyo 2: Ingirabuzimafatizo

Inzira yita cyane yo guhisha ibiri muri kasho, birashoboka, ni ugukurura imipaka yumurongo.

1. Dushiraho indanga kumutwe uhagaze neza, aho umubare wumurongo washyizweho, kurugero rwo hasi rwuwo murongo, ibikubiyemo dushaka kwihisha. Muri iki kibazo, indanga igomba guhinduka ku gishushanyo muburyo bwumusaraba ufite icyerekezo cya kabiri, kiyobowe no hasi. Noneho shyira buto yimbeba hanyuma hanyuma ukurura icyerekezo kugeza hepfo hanyuma hejuru yumupaka utarafungirwa.



2. Umugozi uzaba wihishe.

Uburyo 3: Itsinda rihisha uburyo bwo kuvura

Niba ukeneye ubu buryo kugirango uhishe ibintu byinshi icyarimwe, noneho ubanza gutangwa.

1. Funga buto yimbeba yibumoso hanyuma ugaragaze guhuza inzira ihagaze neza twihishe.

   

   Niba intera nini, hanyuma uhitemo ibintu nkibi bikurikira: Kanda buto yibumoso numubare wambere wa Array kumurongo uhuza, hanyuma uzamuke buto ya Shift hanyuma ukande nimero yanyuma.

   

   Urashobora no kwerekana imirongo myinshi itandukanye. Kugirango ukore ibi, kuri buri kimwe muri byo, ugomba gukanda kuri buto yimbeba yibumoso hamwe na Ctrl pinch.



2. Duhinduka indanga kumupaka wo hasi waya mirongo iyo mirongo hanyuma turarambura kugeza imbibi zirafunzwe.



3. Muri uru rubanza, ntabwo umugozi uzahishwa gusa, ukoreramo, ariko nanone imirongo yose yurwego rwatanzwe.

Uburyo 4: Ibikubiyemo

Uburyo bubiri bwabanjirije, birumvikana, bumeze neza kandi byoroshye gukoresha, ariko ntibashobora gutanga selile zuzuye. Buri gihe hariho umwanya muto, gutsimbarara kugirango uhindure selile inyuma. Hisha byimazeyo umugozi birashoboka ukoresheje menu.

1. Turagaragaza umurongo numwe muburyo butatu twasobanuwe haruguru:
   • gusa hamwe n'imbeba;
   • ukoresheje urufunguzo rwa shift;
   • Ukoresheje urufunguzo rwa CTRL.



2. Kanda ku gipimo gihagaritse gihurirana na buto yimbeba iburyo. Ibikubiyemo biragaragara. Twizihiza ikintu "guhisha".



3. Imirongo yatoranijwe kubera ibikorwa byavuzwe haruguru bizahishwa.

Uburyo 5: Tape ya tape

Urashobora kandi guhisha imigozi ukoresheje buto kumurongo wibikoresho.

1. Hitamo selile ziri kumurongo kugirango zihishe. Bitandukanye nuburyo bwambere, ntabwo ari ngombwa gutanga umurongo wose. Jya kuri tab "urugo". Kanda kuri buto kumurongo wibikoresho bya rubbon, iherereye muri charver block. Mu rutonde rwatangijwe, tuzana indanga ku ngingo yonyine yitsinda "kugaragara" - "guhisha cyangwa kwerekana". Muri menu yinyongera, hitamo ikintu gikenewe kugirango ukore intego - "Hisha imirongo".



2. Nyuma yibyo, imirongo yose irimo selile yagenewe mugika cya mbere izahishwa.

Uburyo 6: Kuyungurura

Kugirango uhishe ibikubiye mu rupapuro, ibyo bitazabikenera mugihe cya vuba kugirango kitubangamira, urashobora gukoresha akazu.

1. Turagaragaza imbonerahamwe yose cyangwa imwe muri selile mumutwe wacyo. Muri tab "urugo", kanda kuri "Sort hanyuma uyunguruzo", uherereye muri Toolbar. Urutonde rwibikorwa rufungura aho uhitamo ikintu "Akayunguruzo".

   

   Urashobora kandi gukora ukundi. Nyuma yo guhitamo imbonerahamwe cyangwa ingofero, jya kuri tab. Kanda kuri buto ya "Akayunguruzo". Iherereye kuri lebbon muburyo bwa "Sort na Akayunguruzo".



2. Ibyo ari byo byose mu buryo bubiri bwasabwe udakoresha, igishushanyo cyo kuyungurura kizagaragara muri selile zimbonerahamwe. Ni inyabutatu ntoya yibara ryirabura, icyerekezo cyerekezo hasi. Kanda kuri iki gishushanyo mu nkingi, aho ikimenyetso gikubiyemo tuzayungurura amakuru.



3. Ibikubiyemo bifungura. Kuraho amatiku muri iyo ndangagaciro zikubiye mumirongo yagenewe kwihisha. Hanyuma ukande kuri buto "OK".



4. Nyuma yibi bikorwa, imirongo yose ahari indangagaciro twakuyeho agasanduku kazahishwa ukoresheje akayunguruzo.

Isomo: Gutondekanya no Gushungura amakuru kuri Excel

Uburyo 7: Guhisha selile

Noneho reka tuvuge uburyo bwo guhisha selile. Mubisanzwe, ntibashobora gukurwaho burundu, nkumurongo cyangwa inkingi, nkuko bizasenya imiterere yinyandiko, ariko biracyafite inzira niba idahishe ibintu ubwabo, hanyuma uhishe ibikubiye.

1. Hitamo selile imwe cyangwa nyinshi zo kwihisha. Kanda ahanditse wenyine hamwe na buto yimbeba iburyo. Ibikubiyemo bifungura. Hitamo muri IT "imiterere ngendanwa ...".



2. Idirishya ryashyizwe ahagaragara. Tugomba kujya kuri tab ya "umubare". Ibikurikira, muri "Imiterere yumubare" wibipimo, hitamo umwanya wa "format zose". Kuruhande rwiburyo bwidirishya muri "Ubwoko", bigatwara imvugo ikurikira:

   ;;;

   Kanda kuri buto ya "OK" kugirango ubike igenamiterere ryinjiye.



3. Nkuko mubibona, nyuma yibyo, amakuru yose mumasetu yatoranijwe yazimiye. Ariko barazimiye gusa kumaso, kandi mubyukuri bakomeje kuba bahari. Kugirango umenye neza ko ibi bihagije kugirango urebe umurongo wibintu byerekanwe. Niba ukeneye gufungura kwerekana amakuru mu kigari, uzakenera guhindura imiterere kugirango uhindure imiterere muri zo ukoresheje idirishya.

Nkuko mubibona, hariho inzira nyinshi zitandukanye ushobora guhisha imirongo muri Excel. Byongeye kandi, benshi muribo bakoresha tekinoroji itandukanye rwose: kuyungurura, kwinjiza, guhindura imipaka ya selile. Kubwibyo, umukoresha afite ibikoresho byinshi byo guhitamo ibikoresho kugirango bikemure icyo gikorwa. Irashobora gukoresha amahitamo atekereza neza mubihe runaka, kimwe norohewe kandi byoroshye kuri we. Byongeye kandi, ukoresheje imiterere birashoboka guhisha ibiri muri selile.