Nigute ushobora kuvana umubare wimpapuro muri excel

Urupapuro rwurupapuro nigikoresho gifatika cyane, byoroshye cyane gutunganya inyandiko mugihe cyo gucapa. Mubyukuri, impapuro zumubare ziroroshye cyane kubora murutonde. Nibyo, kandi mugihe bavanze mu gihe kizaza, urashobora guhora wihuta ukoresheje ukurikije imibare yabo. Ariko rimwe na rimwe birasabwa gukuraho iyi nimero nyuma yo gushyirwaho mu nyandiko. Reka duhangane nuburyo byakorwa.

Hariho kandi guhinduranya uburyo bwo guhinduranya ukoresheje ibikoresho bya kate.

1. Twimukira kuri tab "kureba".



2. Kuri kaseti muri "igitabo Reba Mode", kanda kuri buto "Usanzwe" cyangwa "Page".

Nyuma yibyo, uburyo page buzahagarikwa, kandi umubare winyuma uzashira.

Isomo: Nigute ushobora kuvanaho urupapuro rwanditse 1 muri Excel

Uburyo 2: Gusukura Footer

Hariho kandi imiterere mibi mugihe iyo ukorana nimbonerahamwe mubuhungiro, umubare ntabwo ugaragara, ariko biragaragara iyo ucapishe inyandiko. Kandi, irashobora kugaragara mu idirishya ryerekanwe ryinyandiko. Kugirango ujyeyo, ugomba kwimukira kuri tab "dosiye", hanyuma muri menu yibumoso, hitamo umwanya wa "Icapa". Kuruhande rwiburyo bwidirishya ryafunguye agace ko kureba inyandiko. Hariho ibyo bishobora kugaragara niba page yo gucapa izaba ibaruwe cyangwa atari. Ibyumba birashobora kuba hejuru yurupapuro, hepfo cyangwa mumyanya yombi icyarimwe.

Ubu bwoko bwimibare ikorwa ukoresheje ibirenge. Ibi nimirima nkiyi zihishe, amakuru ahagaragara kugirango appire. Bakoreshwa gusa kugirango babare, Shyiramo inyandiko zitandukanye, nibindi Mugihe kimwe, kubara urupapuro, ntukeneye gukora umubare kuri buri rupapuro. Bihagije kurupapuro rumwe, kuba muburyo bwa fioter, andika kuri kimwe mubyiciro bitatu byo hejuru cyangwa bitatu byo hasi. Imvugo:

& [Urupapuro]

Nyuma yibyo, binyuze mumibare yimpapuro zose zizakorwa. Rero, kugirango ukureho iyi mibare, ugomba gusa gukuraho umutware mumitwe kubikubiyemo, hanyuma ubike inyandiko.

1. Mbere ya byose, kugirango usohoze inshingano zacu ukeneye kujya muburyo bwa cooter. Ibi birashobora gukorwa hamwe nubufasha bwamahitamo menshi. Twimukiye kuri "Shyiramo" hanyuma ukande kuri buto ya "footer", iherereye kuri kaseti mumiterere yinyandiko.

   

   Mubyongeyeho, urashobora kubona ibirenge, mugihe wimuka muburyo bwa page yisumbuye, binyuze mumashusho asanzwe amenyereye mumiterere yumurongo. Kugirango ukore ibi, kanda ahanditse hagati yo guhinduranya uburyo bwo kureba, bwitwa "Page Page".

   

   Ubundi buryo butanga intego kuri "kureba". Hagomba gushyirwa kuri buto "Page Page" kuri kaseti muri "Igitabo Reba Modes" Umwanyabikoresho.



2. Ibyo ari byo byose amahitamo atatoranijwe, uzabona ibikubiye mu kirenge. Kuri twe, umubare wurupapuro uherereye hejuru hanyuma ibumoso usigaye footer footer.



3. Gusa shyira indanga kumurima uhuye hanyuma ukande kuri buto yo gusiba kuri clavier.



4. Nkuko mubibona, nyuma yibyo, umubare wazimiye ntabwo uri hejuru yibumoso gusa kurupapuro rwakuweho, ahubwo no mubindi bintu byose byinyandiko ahantu hamwe. Muri ubwo buryo, gusiba ibiri mu kirenge. Dushiraho indanga nibumba kuri buto yo gusiba.



5. Noneho ko amakuru yose muri make yasibwe, turashobora guhindura imikorere isanzwe. Kugirango ukore ibi, haba muri "Reba" ukanze buto "isanzwe", cyangwa mumiterere yumurongo, kanda kuri buto hamwe nizina rimwe.



6. Ntiwibagirwe kwandika inyandiko. Kugira ngo ukore ibi, birahagije gufungwa ku gishushanyo gifite isabune isa kandi iherereye mu mfuruka yo hejuru yidirishya.



7. Kugirango umenye neza ko ibyumba byarazimiye rwose kandi ntibizagaragara kuri kashe, twimukira kuri tab "dosiye".



8. Mu idirishya rifungura, kwimukira mu gice cya "icapiro" binyuze muri menu ihagaritse ibumoso. Nkuko mubibona, mukarere kimaze kumenyera kureba umubare wimpapuro ziri mu nyandiko idahari. Ibi bivuze ko niba dutangiye gucapa igitabo, noneho tuzabona impapuro tutabarwa, bigomba gukorwa.

Byongeye, urashobora muri rusange uzimye ibirenge.

1. Jya kuri tab "dosiye". Kwimukira mu gice cya "icapiro". Mu gice cyo hagati yidirishya, Igenamiterere ryashyizweho. Mugihe cyo hepfo yiki gice, tukabasinda ku rupapuro rwanditse ".



2. Idirishya rya page ritangira. Mu murima "ikirenge cyo hejuru" na "Umutwe" uhereye kurutonde rwamanutse, hitamo Ihitamo "(Oya)". Nyuma yibyo, twongeyeho buto ya "ok" hepfo yidirishya.



3. Nkuko ushobora kureba ahantu hakurikiraho, umubare w'impapuro uzashira.

Isomo: Nigute wakuraho ibirenge muri Excele

Nkuko mubibona, guhitamo uburyo bwo guhagarika page nimero biterwa ahanini nuburyo iyi nimero ishyizwemo. Niba birerekanwa gusa kuri ecran ya monitor, birahagije guhindura uburyo bwo kureba. Niba imibare igaragara, noneho muriki kibazo ukeneye gukuraho ibiri mu kirenge.