Uburyo bwo Gutanga selile muri Excel

Kenshi na kenshi mugihe ukorana nameza, abakoresha bakeneye guhindura selile. Rimwe na rimwe, amakuru ntabwo ashyirwa mubintu byubunini bwubu kandi bagomba kwaguka. Akenshi hariho ibihe bitandukanye, kugirango ukize aho ukorera urupapuro no kwemeza ko amakuru yo kohereza amakuru, asabwa kugabanya ubunini bwa selile. Dusobanura ibikorwa ushobora guhindura ubunini bwa selile muri excel.

Guhindura ubugari bw'impapuro ukurura imipaka ibaho mu ihame rimwe.

1. Twitwaje indanga kumupaka ukwiye wumurenge winkingi kuri panel ihuriweho na horizontal ya horizontal aho iherereye. Nyuma yo guhindura indanga umwambi werekana, dukora buto yimbeba yibumoso kuri buto yibumoso hamwe nuburenganzira bwo kuba bwiza (niba imbibi zisabwa gusunika) cyangwa ibumoso (niba imipaka igomba kugabanuka).



2. Iyo ugeze ku gaciro kemewe cyikintu, ibyo duhindura ingano, reka buto yimbeba.

Niba ushaka guhindura ibintu byinshi icyarimwe, noneho muriki kibazo ukeneye kubanza kwerekana imirenge ihuye kuri vertical or connel, bitewe nibisabwa kugirango bihindurwe murubanza runaka: ubugari cyangwa uburebure.

1. Uburyo bwo gutandukana, haba kumirongo ninkingi ari hafi. Niba ukeneye kongera selile kumurongo, hanyuma ukande buto yimbeba yibumoso kumurenge kuri panel ijyanye ninama zijyanye nayo iheruka. Nyuma yibyo, muburyo bumwe kanda kumurenge wanyuma, ariko iki gihe icyarimwe ufashe urufunguzo rwa Shift. Rero, imirongo yose cyangwa inkingi zose zitangwa hagati yiyi nzego.

   

   Niba ukeneye guhitamo selile zidayegeranye, hanyuma muriki gihe algorithm yibikorwa iratandukanye. Kanda buto yimbeba yibumoso kuri imwe mu nzego z'inkingi cyangwa imirongo igomba kugaragara. Noneho, ukanda urufunguzo rwa CTRL, ibumba mubindi bintu byose biherereye kumurongo wihariye uhuza nibintu bigamije kugabanywa. Inkingi cyangwa imirongo yose aho iyi selile iherereye, izahindurwa.



2. Noneho, dukwiye guhindura ingano yingirabuzimafatizo zifuzwa, tumure imbibi. Hitamo umupaka uhuye kumurongo uhuza kandi, utegereje kugaragara kwumwambi utanga amasoko, vuga buto yimbeba yibumoso. Noneho shyira umupaka kumurongo uhuza ukurikije ibikenewe rwose (kwagura (gufunga) ubugari cyangwa uburebure bwimpapuro) nkuko byasobanuwe muri variant hamwe na virusi imwe.



3. Nyuma yubunini bugera agaciro wifuza, reka reka imbeba. Nkuko mubibona, ubunini bwa ntabwo bwahindutse gusa cyangwa inkingi byahindutse, hamwe nimipaka ya manipulation, ariko nanone ibintu byose byitabigenewe.

Uburyo 2: Guhindura agaciro mumagambo yimibare

Noneho reka tumenye uburyo bwo guhindura ingano yimpapuro tuyishyiraho imvugo yihariye mumirima yagenewe izo ntego.

Muri indashyikirwa muburyo busanzwe, ingano yimpapuro zashyizwe mubice byihariye byo gupima. Igice kimwe nkiki kingana niki ikimenyetso kimwe. Mburabuzi, ubugari bwa selire ni 8.43. Ni ukuvuga, mubihe bigaragara byimpapuro imwe, niba bidasubirwaho, urashobora kwinjiza inyuguti zirenga 8. Ubugari ntarengwa ni 255. Umubare munini winyuguti ziri mu kagari uzananirwa. Ubugari ntarengwa niro. Ikintu hamwe nubunini bwihishe.

Uburebure bwumurongo ni amanota 15. Ingano yacyo irashobora gutandukana kuva 0 kugeza 409.

1. Kugirango uhindure uburebure bwibibabi byamababi, hitamo. Noneho, shakisha tab "urugo", ibumba kuri "imiterere", riherereye kuri kaseti mumatsinda "selile". Kuva kurutonde rwamanutse, hitamo Ihitamo "Uburebure bwumurongo".



2. Idirishya rito rifungura umurima "uburebure bwumurongo". Hano niho tugomba kubaza agaciro wifuza mumanota. Dukora igikorwa n'ibumba kuri buto "OK".



3. Nyuma yibi, uburebure bwumurongo aho ikintu cyamababi yagenewe cyahinduwe kubiciro byagenwe mumanota.

Hafi yuburyo urashobora guhindura ubugari bwinkingi.

1. Hitamo urupapuro rugomba guhindukamo ubugari bugomba guhinduka. Nyuma yo kuguma muri tab "urugo", kanda buto ya "format". Muri menu ifungura, hitamo Ihitamo "Ubugari bw'inkingi ...".



2. Hano hari idirishya rimwe kuri uwo twabonye mugihe cyabanjirije. Hano, mumurima, ugomba kwerekana umubare mubice bidasanzwe, ariko iki gihe kizerekana ubugari bwinkingi. Nyuma yo gukora ibi bikorwa, kanda buto "OK".



3. Nyuma yo gukora ibikorwa byagenwe, ubugari bwinkingi, bivuze ko selile ukeneye, izahindurwa.

Hariho ubundi buryo bwo guhindura urupapuro rwigipapuro mugushiraho agaciro kerekanwe mumagambo yubwishingizi.

1. Kugirango ukore ibi, hitamo inkingi cyangwa umugozi aho uhembwa uherereye, bitewe nibyo ushaka guhindura: Ubugari nuburebure. Guhitamo bikozwe binyuze mumwanya uhuza ukoresheje ayo mahitamo twasuzumye muburyo 1. Noneho ibumba kugirango ugaragaze buto yimbeba iburyo. Ibikubiyemo birakora, aho ukeneye guhitamo "uburebure bwumurongo ..." cyangwa "ubugari bwa" inkingi ... ".



2. Idirishya rifite idirishya rifungura, ryaganiriweho hejuru. Ikeneye kwinjira muburebure cyangwa ubugari bwifuzwa kimwe muri ubwo buryo nkuko byasobanuwe mbere.

Ariko, abakoresha bamwe ntibanyuzwe na sisitemu ya Excel yerekana ubunini bwurupapuro ruri mu gika kigaragazwa numubare winyuguti. Kuri aba bakoresha, hari amahirwe yo guhinduranya ikindi gipimo.

1. Jya kuri tab ya "dosiye" hanyuma uhitemo "ibipimo" muri menu yibumoso.



2. Idirishya rya Parameter ritangira. Ibikubiyemo biherereye ibumoso. Jya mu gice "Bihitamo". Kuruhande rwiburyo bwidirishya hari igenamiterere ritandukanye. Kanda hasi kuzunguruka hasi hanyuma ushake "ecran". Muri uku guhagarika, umurima "units kumurongo" uherereye. Kanda kuri yo kandi uhereye kurutonde rwamanutse, hitamo igice gikwiye cyo gupima. Hariho uburyo bukurikira:
   • Santimetero;
   • Milimetero;
   • Santimetero;
   • Ibice bisanzwe.

   Nyuma yo guhitamo, kugirango winjire ku ngufu ku ngufu, kanda kuri buto "OK" hepfo yidirishya.

Noneho urashobora guhindura impinduka mubunini bwingirabuzimafatizo ukoresheje ayo mahitamo agaragaza hejuru, ikora igice cyatoranijwe cyo gupima.

Uburyo bwa 3: Automatic yanze igasige

Ariko, urabona ko byoroshye rwose guhindura intoki zihindura ingano za selile zikagari, ubahindure kubintu runaka. Kubwamahirwe, excel itanga ubushobozi bwo guhita uhindura ingano yimpapuro, ukurikije agaciro kamakuru arimo.

1. Hitamo Akagari cyangwa itsinda ryamakuru itashyizwe murupapuro rurimo. Muri tab "urugo" ibumba kuri buto imenyerewe ". Muri menu idahagarara, hitamo uburyo bwo gukoreshwa ikintu runaka: "Umurongo wikora wumurongo wuburebure" cyangwa "ubugari bwinkingi".



2. Nyuma y'ibipimo byerekanwe byakoreshejwe, ingano ya selile izahinduka ukurikije ibikubiyeho, ku cyerekezo cyatoranijwe.

Isomo: Umurongo wuburebure bwimodoka muri Excel

Nkuko mubibona, hindura ingano ya selile muburyo butandukanye. Barashobora kugabanywamo amatsinda abiri manini: gukurura imipaka hamwe ninjiza yubunini bwumubare mumurima wihariye. Byongeye kandi, urashobora gushiraho uburebure cyangwa ubugari n'inkingi.