Kimwe mubintu bishimishije kandi byingirakamaro muri Excele nubushobozi bwo guhuza selile ebyiri cyangwa nyinshi muri imwe. Iyi mikorere irakenewe cyane mugihe cyo gukora imitwe ningendo. Nubwo, rimwe na rimwe bikoreshwa no mumeza. Mugihe kimwe, ugomba gutekereza ko mugihe cyo guhuza ibintu, imirimo imwe nimwe ihagarika gukora neza, kurugero, gutondeka. Kandi hariho izindi mpamvu nyinshi, bitewe nuwayikoresha azakemura agace kagabanya selile kugirango yubake imiterere yimeza muburyo butandukanye. Dushiraho uburyo bushobora gukorwa.
Guhagarika selile
Inzira yo guhagarika ingirabuzimafatizo nicyo cyagonze mubumwe bwabo. Kubwibyo, mumagambo yoroshye, kugirango ubigire, ugomba guhagarika ibikorwa byakozwe mugihe wunze ubumwe. Ikintu nyamukuru nukumva ko selile igizwe nibintu byinshi byahujwe birashobora guhagarikwa.Uburyo 1: Gutegura Idirishya
Abakoresha benshi bakoreshwa mugutanga inzira yo guhuzagura mumadirishya hamwe ninzibacyuho kugeza aho hakoreshejwe ibikubiyemo. Kubwibyo, no guhagarika nabo bazabikora.
- Hitamo selile ihuriweho. Kanda iburyo-kanda kugirango wita ibikubiyemo. Urutonde rufungura, hitamo ikintu "ukomoka kuri selire ...". Aho kugirango ibyo bikorwa, nyuma yo guhitamo ikintu, urashobora gusa gusohoza ikomano rya buto kuri clavier Ctrl + 1.
- Nyuma yibyo, idirishya ryamakuru ryatangijwe. Kwimuka muri tab "guhuza". Muri "kwerekana" igenamiterere, kura agasanduku ka "urwenya". Gukoresha ibikorwa, kanda kuri buto "OK" hepfo yidirishya.
Nyuma yibi bikorwa byoroshye, akagari kuri icyoherejwe byakorewemo bizagabanywamo ibice byayo. Mugihe kimwe, niba amakuru yabitswe muri yo, noneho bose bazaba bari mumwanya wo hejuru.
Isomo: Imbonerahamwe ya Excel
Uburyo 2: buto kuri rebbon
Ariko byihuse kandi byoroshye, mubyukuri muri kanda imwe, urashobora gutandukanya ibintu ukoresheje buto kuri lebbon.
- Nko muburyo bwambere, mbere ya byose, ugomba kwerekana selile ihuriweho. Noneho muri "Guhuza" Itsinda ryibikoresho kuri kaseti, twakanze kuri "Gushyira hamwe na buto".
- Muri uru rubanza, nubwo izina, nyuma yo gukanda buto, ibikorwa byinyuma bizabaho: ibintu bizahagarikwa.
Mubyukuri, amahitamo yose yo guhagarika selile nimpera. Nkuko mubibona, hariho bibiri gusa muri byo: Guhindura idirishya na buto kuri kaseti. Ariko izi nzira zirahagije kugirango ubwitange bwihuse kandi bworoshye bwinjize.