Nigute wandika kurupapuro rumwe mubyinjira

Gucapa kurupapuro rumwe muri Microsoft Excel

Iyo icapiro hamwe nandi makuru, inyandiko ya Excel ikunze mugihe amakuru arenze imipaka yurupapuro. Ntabwo cyane cyane niba ameza adahuye na horizontally. Mubyukuri, muriki gihe, amazina yimigozi azaba ku gice kimwe cyinyandiko yacapwe, hamwe ninkingi zitandukanye kurundi. Ndetse gutenguha cyane, niba bike bitagira umwanya uhagije wo gushyira kumeza rwose kurupapuro. Ariko gusohoka kuri uyu mwanya urahari. Reka tumenye uburyo bwo gucapa amakuru kurupapuro rumwe muburyo butandukanye.

Shira ku rupapuro rumwe

Mbere yo gufungura kugirango ukemure ikibazo cyuburyo washyira amakuru kurupapuro rumwe, ugomba guhitamo niba ubikora na gato. Bikwiye gusobanuka ko muburyo bwinshi buzaganirwaho hepfo, tekereza kugabanuka ku gipimo kugirango ubahuze ku kintu kimwe cyacapwe. Niba imipaka ifite ibibabi ugereranije ni ntoya mubunini, birabyemewe rwose. Ariko niba umubare munini wamakuru udahuye, noneho ugerageza gushyira amakuru yose kurupapuro rumwe birashobora kuganisha ku kuba bazagabanuka cyane kuburyo bazagenda badashobora guhinduka. Muri uru rubanza, muriki gihe, umusaruro mwiza uzacapura page kumpapuro nini, impapuro zashishikarizwa cyangwa gushaka ubundi buryo.

Umukoresha rero agomba kumenya niba akwiye kugerageza kwakira amakuru cyangwa atari. Tuzakomeza gusobanura inzira zihariye.

Uburyo 1: Guhindura icyerekezo

Ubu buryo ni bumwe mu buryo bwasobanuwe hano, aho udashaka kwitabaza kugabanuka ku gipimo. Ariko birakwiriye gusa niba inyandiko ifite umubare muto wimirongo, cyangwa kubakoresha ntabwo ari ngombwa kuburyo bihuye nurupapuro rumwe, kandi bizaba bihagije kuburyo amakuru azaba aherereye ku rupapuro.

Mbere ya byose, ugomba kugenzura niba ameza ashyirwa kumupaka wimpapuro zacapwe. Gukora ibi, hindukira muburyo bwa "Page Page". Kugirango ukore cickey kumashusho hamwe nizina rimwe, riherereye kumurongo.

Urashobora kandi kujya muri tab "kureba" hanyuma ukande kuri buto kurupapuro rwa page ", uherereye kuri kaseti mugihe cya" Igitabo Reba Modes ".

Hindura kurupapuro rwurupapuro ukoresheje buto kuri kaseti muri Microsoft Excel

Muri ubwo buryo ubwo aribwo bwose, gahunda yinjira muburyo bwa page. Muri iki gihe, imbibi za buri kintu cyacapwe kiragaragara. Nkuko tubibona, kuri twe, imbonerahamwe ihindura itambitse kumabati abiri atandukanye, adashobora kwemerwa.

Imbonerahamwe Yacitse muri Microsoft Excel

Kugirango ukosore ibintu, jya kurubuga "page Mariko". Tugasi muri "icyerekezo", kirimo kuri kaseti murugero rwa "page Page"

Fungura icyerekezo nyaburanga ukoresheje buto kuri kaseti muri Microsoft Excel

Nyuma y'ibikorwa byavuzwe haruguru, imbonerahamwe ikwirakwira rwose ku rupapuro, ariko icyerekezo cye cyahinduwe kuva mu gitabo kiri ku nyamaswa.

Impinduka zumwimerere muri Microsoft Excel

Hariho kandi ubundi buryo bwo guhindura icyerekezo cyibibabi.

Jya kuri tab "dosiye". Ibikurikira, wimuke mugice cya "icapiro". Mu gice cyo hagati yidirishya cyafunguye idirishya ni icyuma cyanditseho. Kanda ku Izina "Icyerekezo cyigitabo". Nyuma yibyo, urutonde rufite ubushobozi bwo guhitamo ubundi buryo. Hitamo izina "icyerekezo cyo gupakira".

Guhindura urupapuro rwerekezaga binyuze muri dosiye muri Microsoft Excel

Nkuko tubibona, mukarere cyo kwitegura, nyuma yibikorwa byavuzwe haruguru, urupapuro rwahinduye icyerekezo ku nyamaswa kandi noneho amakuru yose akubiye mukarere k'ibice kimwe.

Mubyongeyeho, urashobora guhindura icyerekezo ukoresheje idirishya rya parameter.

Kuba muri tab "dosiye", mu gice cya "icapiro" ukanze ku rupapuro "urupapuro rwerekanwe", kirimo munsi y'igenamiterere. Mu idirishya ryidirishya, urashobora kandi kunyura mubundi buryo, ariko tuzavugana birambuye kubyerekeye ibisobanuro byuburyo bwa 4 muburyo burambuye.

Hindura kurupapuro rwa page muri Microsoft Excel

Idirishya rya Parameter ritangira. Jya kuri tab ye yitwa "page". Muri "icyerekezo" guhagarika igenamiterere, dutondekanya umwanya wa "igitabo" kugeza "imiterere". Noneho kanda kuri buto "OK" hepfo yidirishya.

Guhindura icyerekezo ukoresheje Idirishya Idirishya muri Microsoft Excel

Icyerekezo cyinyandiko kizahinduka, bityo rero, agace k'ibintu byacapwe byaguwe.

Isomo: Nigute ushobora gukora urupapuro rwumutungo

Uburyo 2: Guhindura imbibi za selile

Rimwe na rimwe, bibaho ko umwanya wakoreshejwe udakora neza. Ni ukuvuga, mu nkingi zimwe hari ahantu habuze. Ibi byongera ubunini bwurupapuro mubugari, bityo bigaragare birenze imipaka yurupapuro rumwe rwacapwe. Muri iki kibazo, birumvikana kugabanya ubunini bwa selile.

Andika urutonde ruhana imbibi muri Microsoft Excel

Dushiraho indanga kumupaka uhuza kumupaka winkingi iburyo bwurwo rubinyi utekereza ko bishoboka kugabanya. Muri iki gihe, indanga igomba guhinduka umusaraba hamwe nimyambi yerekezaga kumpande ebyiri. Funga buto yimbeba yibumoso hanyuma wimure umupaka ujya ibumoso. Uyu mutwe urakomeza kugeza umupaka ugera ku makuru y'akagari k'inkingi, yuzuyemo ibirenze abandi.

Shira imipaka yinkingi muri Microsoft Excel

Igikorwa nkiki cyakozwe hamwe nibindi bisigaye. Nyuma yibyo, birashimishije cyane amahirwe makuru yose yimeza azahuza nibintu kimwe byacapwe, kubera ko ameza ubwayo arumye cyane.

Imbonerahamwe ya Compact muri Microsoft Excel

Nibiba ngombwa, igikorwa nkiki gishobora gukorwa kumirongo.

Ibibi byubu buryo nuko bitari ngombwa, ariko mugihe gusa aho hakoreshejwe urupapuro rwabigenewe rwakoreshejwe neza. Niba amakuru aherereye nkaho ahungaho, ariko ntagifite ku kintu cyanditse, noneho mubihe nkibi ukeneye gukoresha ubundi buryo tuzavuga.

Uburyo 3: Igenamiterere

Birashoboka gukora amakuru yose mugihe icapiro kubintu bimwe, urashobora kandi muburyo bwo gucapa mugupima. Ariko muriki gihe, birakenewe gusuzuma ko data izagabanuka.

Jya kuri tab "dosiye". Ibikurikira, wimuke mugice cya "icapiro".

Noneho ongera witondere igenamiterere ryanditse mugice cyo hagati cyidirishya. Hepfo hari igenamiterere ridakabije. Mburabuzi, hagomba kubaho ibipimo "byubu. Kanda kumurima wagenwe. Urutonde. Hitamo muriyo umwanya "andika urupapuro kurupapuro rumwe".

Kwandika urupapuro kurupapuro rumwe muri Microsoft Excel

Nyuma yibyo, kugabanya igipimo, amakuru yose mumyandiko iriho azashyirwa ku kintu kimwe cyacapwe, gishobora kugaragara mu idirishya ryerekanwe.

Urupapuro rwanditse page imwe muri Microsoft Excel

Kandi, niba nta gikenewe cyo kugabanya imirongo yose kurupapuro rumwe, urashobora guhitamo "Inkingi zerekeza kurupapuro" Mubipimo byo guteka. Muri uru rubanza, amakuru ameza azacibwa mu buryo butambitse ikintu kimwe cyacapwe, ariko mu cyerekezo gihagaritse ntihazabaho kubuza.

Ening inkingi kurupapuro rumwe muri Microsoft Excel

Uburyo 4: Urupapuro Idirishya

Shyira amakuru kubintu bimwe byacapwe birashobora kandi gukoresha idirishya ryitwa "urupapuro rufite".

Hariho uburyo bwinshi bwo gutangira idirishya rya page. Iya mbere muribo ni uguhindura "page Mariko". Ibikurikira, ugomba gukanda ku gishushanyo muburyo bwumwambi ushishikajwe, ushyirwa mu mfuruka yo hepfo yiburyo bwa "page igenamiterere".

Ingaruka nkiyi hamwe ninzibacyuho ku idirishya ukeneye mugihe ukanze kuri pictografimu imwe ubwayo mugice cyiburyo cyiburyo bwa "fitre" yigikoresho kuri kaseti.

Hariho kandi uburyo bwo kwinjira muriyi idirishya binyuze muri Igenamiterere. Jya kuri tab "dosiye". Ibikurikira, kanda ku izina "Icapa" muri menu ibumoso yidirishya ryafunguye. Mu Igenamiterere, riherereye hagati mu idirishya, kanda ahanditse Page "Page", uherereye hepfo.

Hariho ubundi buryo bwo gutangiza idirishya rya parameter. Kwimukira mu gice cya "icapiro" cya dosiye. Ibikurikira, kanda kumurima utanga umusaruro. Mburabuzi, "ubu" (ubungubu "byasobanuwe. Kurutonde rufungura, hitamo ikintu "igenamiterere ryibipimo ngenderwaho ...".

Hindura kurupapuro rwa Page Ibipimo unyuze muri Igenamiterere rya Microsoft Excel

Niki mubikorwa byasobanuwe haruguru, ntabwo wari guhitamo, "page igenamiterere" idirishya rizafungura imbere yawe. Twimukiye kuri tab "page" niba idirishya ryafunguye muyindi tab. Muri "igipimo" cyo guhagarika igenamiterere, twashizeho guhindura "umwanya tutari kure kuri" umwanya. Mu murima "page Ubugari "na" p. Muremure "bigomba gushyirwaho" 1 " Niba ataribyo, ugomba gushyiraho amakuru yumubare mubikorwa bihuye. Nyuma yibyo, kugirango igenamigambi ryafashwe na gahunda yo gukora, kanda kuri buto ya "OK", iherereye hepfo yidirishya.

Urupapuro Idirishya Idirishya muri Microsoft Excel

Nyuma yo gukora iki gikorwa, ibikubiye mubitabo byose bizaba byiteguye gucapa kurupapuro rumwe. Noneho jya kuri "icapiro" rya tab "dosiye" hanyuma ukande kuri buto nini yitwa "Icapa". Nyuma yibyo, ibikoresho byacapishijwe kuri printer kumpapuro imwe.

Inyandiko yo gucapa muri Microsoft Excel

Nko muburyo bwambere, mu idirishya rya parameter, urashobora gukora igenamiterere amakuru azashyirwa kurupapuro gusa mu cyerekezo cya horizontal, no mu rugero ruhagaze ntiruzaba. Kuri izo ntego, birasabwa gutondekanya kuri switch kumwanya "inyandiko ntarenze" murupapuro "murupapuro" Mu bugari "shyira agaciro" 1 ", n'umurima" page Uburebure "Kureka ubusa.

Inkingi zikwiranye nurupapuro rumwe ukoresheje page parameter idirishya muri Microsoft Excel

Isomo: Nigute wandika urupapuro mu buhungiro

Nkuko mubibona, hari umubare munini cyane wo kwakira amakuru yose yo gucapa kurupapuro rumwe. Byongeye kandi, amahitamo yasobanuwe ni bitandukanye cyane. Ingaruka yo gukoresha buri buryo igomba gutegekwa nibihe bifatika. Kurugero, niba usize umwanya wubusa mu nkingi, noneho guhitamo neza bizamura gusa imipaka yabo. Kandi, niba ikibazo kidakwiye gushyira ameza kubintu kimwe byacapwe muburebure, ariko gusa mubugari, noneho birashobora kumvikana gutekereza kubihindura icyerekezo. Niba aya mahitamo adakwiriye, urashobora gukoresha uburyo bujyanye no kugabanuka mu gupima, ariko muriki gihe ingano yamakuru nayo izagabanuka.