Nigute ushobora guhagarika selile muri excel

Excel nimbonerahamwe ya dinamike, mugihe ukorana nibintu bihinduka, bikemura impinduka, nibindi Ariko mubihe bimwe na bimwe ukeneye gukosora ikintu runaka cyangwa, nkuko babivuga ukundi, guhagarika kugirango bidahindura aho biherereye. Reka tumenye aho amahitamo abituma gukora.

Ubwoko bwo gukosora

Ako kanya ukeneye kuvuga ko ubwoko bwo gukosorwa mubuhungiro burashobora gutandukana rwose. Muri rusange, barashobora kwigabanyamo amatsinda atatu manini:

1. Aderesi ya Freezing;
2. Ingirabuzimafatizo;
3. Kurinda ibintu bituruka ku guhindura.

Iyo uhagaritse aderesi, ihuriro ryingirabuzimafatizo ntabwo rihinduka iyo ryandukuye, ni ukuvuga, ihagarika kuba isano. Kohereza selile bigufasha kubabona buri gihe kuri ecran, nubwo waba umukoresha atagurukiye hejuru yurupapuro cyangwa iburyo. Kurinda ibintu kuva guhindura guhagarika amakuru yose ahinduka mubintu byagenwe. Reka dusuzume birambuye buri kimwe muri aya mahitamo.

Uburyo 1: Ubukonje

Icya mbere, tuzibanda ku gutunganya aderesi. Guhagarika, uhereye kuri ugereranije, ni ubuhe butumwa ubwo ari bwo bwose mu kuba indashyikirwa mu buryo busanzwe, ugomba gukora ihuriro ryuzuye ridahinduka rihuza mugihe cyo gukoporora. Kugirango ukore ibi, ugomba gushiraho aderesi yikimenyetso cyamadorari ($) kuri buri guhuza.

Gushiraho ikimenyetso cyamadorari gifatwa ukanda ikimenyetso gikwiye kuri clavier. Iherereye kurufunguzo rumwe hamwe numubare "4", ariko gukuraho ecran ugomba gukanda urufunguzo mumiterere yicyongereza murwego rwo hejuru (hamwe na "shift"). Hariho inzira yoroshye kandi yihuse. Ugomba guhitamo aderesi yibintu muri selire runaka cyangwa kumurongo wibikorwa hanyuma ukande kurufunguzo rwa F4. Iyo ukanze bwa mbere, ikimenyetso cyamadorari kizagaragara kuri aderesi yumurongo ninkingi, mugihe cya kabiri kanda kuri uru rufunguzo bizaguma kuri aderesi yumurongo, mugihe cya gatatu - kuri aderesi yinkingi. Icya kane ukanda urufunguzo rwa F4 ukuraho ikimenyetso cyamadorari rwose, hanyuma ubutaha buratangira ubu buryo nuruziga rushya.

Reka turebe aderesi ikonje kurugero runaka.

1. Gutangira, Gukoporora Umuyoboro usanzwe mubindi bintu byinkingi. Gukora ibi, koresha ikimenyetso cyuzuye. Shyira indanga kuruhande rwiburyo bwiburyo bwa selire, amakuru aho ushaka gukoporora. Muri icyo gihe, yahinduwe kumusaraba, itwara izina ryubujurire. Shyira buto yimbeba hanyuma ukure uyu musaraba kugeza kumpera yimeza.



2. Nyuma yibyo, tugenera ibintu bitonyanga byimeza tureba formulaire, nkuko formula yahindutse mugihe cyo gukoporora. Nkuko mubibona, ihuriro ryose ryari mubintu byambere byinkingi, mugihe ukoporora. Nkigisubizo, formula itanga ibisubizo bitari byo. Ibi biterwa nuko adresse yikintu cya kabiri, bitandukanye nuwambere, ntigomba kwimurwa kubara neza, ni ukuvuga, bigomba gukorwa byuzuye cyangwa byakosowe.



3. Turasubira mubintu byambere byinkingi no gushiraho ikimenyetso cyamadorari hafi yikintu cya kabiri muri bumwe twavuze haruguru. Noneho iyi link irakonje.



4. Nyuma yibyo, ukoresheje ikimenyetso cyuzuye, uyikoporore kumeza giherereye hepfo.



5. Noneho tugenera ikintu cya nyuma cyinkingi. Nkuko dushobora kwitegereza binyuze kumurongo wa formula, guhuza ikintu cya mbere biracyahindurwa mugihe cyo kwigana, ariko aderesi ya kabiri, ibyo twagize rwose, ntabwo bihinduka.



6. Niba ushize ikimenyetso cyamadorari gusa kumurongo winkingi, hanyuma muriki gihe adresse yinkingi ihuza izakosorwa, kandi imirongo yumurongo irahindurwa iyo ikoporora iyo ukoporora.



7. Ibinyuranye, niba washyizeho ikimenyetso cyamadorari hafi ya aderesi yumurongo, noneho iyo ukoporora bitazahinduka, bitandukanye na aderesi yinkingi.

Ubu buryo butanga imirongo ikonje ya selile.

Isomo: Aderesi Yuzuye muri Excel

Uburyo 2: Gukosora selile

Noneho twiga uburyo bwo gukosora selile kugirango bahoraga bakomeza kuri ecran aho umukoresha atajya mu mbibi z'ibabi. Muri icyo gihe, twakagombye kumenya ko ibintu ku giti cye bidashobora gufatirwa, ariko urashobora gukosora agace kirimo.

Niba selile yifuzwa iherereye kumurongo wo hejuru wurupapuro cyangwa mu nkingi yibumoso, noneho ibyakosowe ni ngombwa.

1. Kurinda umurongo, kora ibikorwa bikurikira. Jya kuri tab "kureba" ku ibumba kuri buto "ifunze ahantu" iherereye mu idirishya rya kikoresho cya "idirishya". Urutonde rwimyitwarire itandukanye. Hitamo izina "witondere umurongo wo hejuru".



2. Noneho nubwo wamanutse munsi yurupapuro, umurongo wambere, bivuze ko ikintu ukeneye, uherereyemo, kizakomeza kuba hejuru yidirishya.

Mu buryo nk'ubwo, urashobora guhagarika inkingi ikabije.

1. Jya kuri tab "Reba" hanyuma ukande ahanditse "gufunga". Iki gihe nahisemo amahitamo "umutekano winkingi ya mbere".



2. Nkuko mubibona, inkingi yibumoso cyane irakosowe.

Hafi yuburyo ushobora gushimangira gusa inkingi yambere numugozi, ariko muri rusange, ahantu hose hasigaye no hejuru yikintu cyatoranijwe.

1. Iyicwa algorithm kubwiki gikorwa iratandukanye cyane na kabiri yabanjirije. Mbere ya byose, birakenewe kwerekana ibintu byamababi, agace kuva hejuru n'ibumoso muri byo bizakosorwa. Nyuma yibyo, jya kuri tab "Reba" hanyuma ukande ku gishushanyo kimenyerewe "funga akarere". Muri menu ifungura, hitamo ikintu hamwe nizina rimwe.



2. Nyuma yiki gikorwa, ahantu hose uherereye ibumoso kandi hejuru yikintu cyeguriwe kizakemuka kurupapuro.

Niba ubishaka, ukureho freezing yakozwe muri ubu buryo, byoroshye. Iyicwa rya Algorithm ni zimwe mu bihe byose ko byaba umukoresha utazagira umutekano: umugozi, inkingi cyangwa agace. Twimukiye kuri tab "kureba", kanda ahanditse "Gukosora" no kurutonde rufungura, hitamo uburyo bwo "gukuraho ihungabana". Nyuma yibyo, iringaniza ryose ryurupapuro ruzagabanuka.

Isomo: Nigute ushobora gukosora agace muri Excel

Uburyo bwa 3: Kurinda Kurinda

Hanyuma, urashobora kurinda selile guhinduranya uhagarika ubushobozi bwo guhindura abakoresha. Rero, amakuru yose arimo azahagarikwa koko.

Niba ameza yawe adafite imbaraga kandi ntabwo atanga kugirango utangire impinduka zose zirimo, urashobora kurinda ingirabuzimafatizo zihariye, ahubwo no kumpapuro zose muri rusange. Biroroshye cyane.

1. Kwimukira muri tab "dosiye".



2. Mu idirishya rifungura muri menu yibumoso, jya mugice cya "Ibisobanuro". Mu gice cyo hagati cy'idirishya, ibumba ku nyandiko "ririnda igitabo". Ku rutonde rwibikorwa byumutekano bifungura, hitamo "kurinda urupapuro rwubu.



3. Idirishya rito ryatangijwe, ryitwa "kurinda urupapuro". Mbere ya byose, muri yo mu murima wihariye ugomba kwinjiza ijambo ryibanga ridasanzwe, bizakenerwa numukoresha niba bifuza guhagarika uburinzi mugihe kizaza kugirango uhindure inyandiko. Byongeye kandi, kubushake, urashobora kwinjizamo cyangwa gukuraho umubare wibindi bibujijwe, ushyiraho cyangwa ukuraho amabendera hafi yibintu biri kurutonde rwatanzwe muriyi idirishya. Ariko mubihe byinshi, igenamiterere risanzwe rihuje numurimo, kugirango ukande buto ya "OK" nyuma yo kwinjira ijambo ryibanga.



4. Nyuma yibyo, indi idirishya ritangira, aho ijambo ryibanga ryinjiye mbere rigomba gusubirwamo. Ibi bikorwa kugirango uyikoresha yizeye ko yazanye ijambo ryibanga nibutse kandi yanditse muburyo bukwiye bwa clavier hamwe na resilet irashobora gutakaza uburyo bwo guhindura inyandiko. Nyuma yo kongera kwinjira ijambo ryibanga, kanda buto "OK".



5. Noneho mugihe ugerageza guhindura ikintu icyo aricyo cyose, iki gikorwa kizahagarikwa. Idirishya ryamakuru rizafungura, ritanga raporo idashoboka guhindura amakuru kurupapuro rwarinzwe.

Hariho ubundi buryo bwo guhagarika impinduka zose mubintu kurupapuro.

1. Jya kuri "gusubiramo" ku ibumba kuri "kimuringe" igishusho "kirimo kuri kaseti mu" mpinduka ".



2. Yafunguwe yamenyereye idirishya ryo kurinda idirishya. Ibindi bikorwa byose bikora muburyo bumwe nkuko byasobanuwe muri verisiyo ibanza.

Ariko icyo gukora niba ukeneye guhagarika selile imwe cyangwa nyinshi gusa, kandi mubandi ifatwa, nka mbere, kugirango ukore amakuru kubuntu? Hariho inzira yo kuva muriyi myanya, ariko igisubizo cyacyo kiba kigoye kuruta umurimo wabanjirije.

Muri selile zose zinyandiko zisanzwe mumitungo, uburinzi bwerekanwe, iyo urupapuro rufunze muri rusange, amahitamo yavuzwe haruguru. Tuzakenera gukuraho ibipimo byo kurinda ibintu byimpapuro zose zimpapuro zose, hanyuma uyishyiremo gusa muri ibyo bintu twifuza guhagarika impinduka.

1. Kanda ku rukiramende, ruherereye mu ihuriro rya horizontal na parike. Na none, niba indanga iri ahantu hose yurupapuro hanze yimeza, kanda urufunguzo rushyushye kuri Ctrl + clavier. Ingaruka zizaba zimwe - ibintu byose kurupapuro byerekanwe.



2. Noneho tumenaga ahantu hagaragara hirya no gukanda iburyo. Muri menu ikora, hitamo "imiterere ngendanwa ...". Kandi, ahubwo, urashobora gukoresha CTRL + 1 urufunguzo rwo guhuza urutonde.



3. "Imiterere ya selire" irakora. Guhita uhindura kuri tab "kurinda". Igomba kuvaho agasanduku kari hafi ya "Coxt Cover". Kanda kuri buto ya "OK".



4. Ibikurikira, dusubira ku rupapuro tunatanga element cyangwa itsinda aho tugiye guhagarika amakuru. Tugasanduku tukabasi-igice cyabugenewe no muri menu, tujye mwizina "imiterere ngenda.".



5. Nyuma yo gufungura idirishya, ongera ujye kuri tab "kurinda" hanyuma ushyireho agasanduku kari hafi ya "Cell Fork". Noneho urashobora gukanda kuri buto "OK".



6. Nyuma yibyo, twashizeho uburinzi nkumwe muriyo buryo bubiri bwasobanuwe mbere.

Nyuma yo gukora inzira zose zasobanuwe zidusobanurira Amerika hejuru, gusa utwo tugari dusubizwamo uburinzi binyuze mumitungo izahagarikwa nimpinduka. Mubindi bintu byose byurupapuro, nka mbere, urashobora gutanga kubuntu.

Isomo: Nigute ushobora kurinda selile impinduka kuri excel

Nkuko mubibona, hariho inzira eshatu zo guhagarika selile. Ariko ni ngombwa kumenya ko bitandukanye muri buri kimwe muri byo atari ikoranabuhanga ryo gukora ubu buryo, ahubwo ni kandi ishingiro ry'ubukonje ubwabwo. Mu rubanza rumwe, gusa adresse yibiti yibabi yanditswe, mu bya kabiri - Agace kakosowe kuri ecran, no mu cya gatatu - kurengera ibibazo byamakuru muri selile. Kubwibyo, ni ngombwa cyane kubyumva mbere yo gukora inzira, mubyukuri ugiye guhagarika kandi kuki ubikora.