Rimwe na rimwe iyo ucapishe igitabo cyitwa Excel, icapiro ricapa impapuro zuzuyemo amakuru, ahubwo ni ubusa. Ibi birashobora kubaho kubwimpamvu zitandukanye. Kurugero, niba uri mukarere k'uru rupapuro, utabishaka shyira inyuguti iyo ari yo yose, ndetse n'umwanya, bizafatwa kubicapa. Mubisanzwe, bigira ingaruka mbi ku kwambara igicapo, kandi nanone biganisha ku gutakaza umwanya. Byongeye kandi, hari ibibazo mugihe udashaka gucapa paji runaka yuzuyemo amakuru kandi ushaka kugaburira kugirango ucane, ariko ukureho. Reka turebe amahitamo yo gusiba urupapuro muri Excel.
Urupapuro rwo gusiba uburyo
Buri rupapuro rw'igitabo Cyiza kigabanijwemo impapuro zacapwe. Imipaka yabo icyarimwe ikora nkumupaka w impapuro zizerekanwa kuri printer. Urashobora kureba neza uko inyandiko igabanijwemo impapuro, urashobora kujya mumiterere yububiko cyangwa kurupapuro rwa Excel. Kora byoroshye.
Kuruhande rwiburyo bwimiterere yimiterere, iherereye hepfo yidirishya rya excel, ni amashusho yo guhindura inyandiko yo kureba. Mburabuzi, uburyo busanzwe bushoboka. Igishushanyo kijyanye nayo, ibumoso bwibishushanyo bitatu. Kugirango uhindure kurupapuro rwa page, kanda ku gishushanyo cya mbere iburyo bwibishushanyo byagenwe.
Nyuma yibyo, uburyo bwimpapuro uburyo bwafunguye. Nkuko mubibona, impapuro zose ziratandukanijwe numwanya wubusa. Kujya kurupapuro rwurupapuro, kanda kuri buto iburyo kumurongo wibishushanyo byavuzwe haruguru.
Nkuko mubibona, muburyo bwa page, ntabwo ari impapuro ubwabo zigaragara, imbibi zayo zerekanwa numurongo utudomo, ariko nazo.
Kandi, guhinduranya hagati yo kureba muri Excel birashobora gukorwa no kujya muri tab "kureba". Ngaho, kuri kaseti mugitabo "Igitabo Reba Modes" guhagarika, uburyo bwo guhinduranya buhuye nibishushanyo mbonera byumwanya.
Niba iyo ukoresheje page uburyo ibaruye intera aho ntakintu cyerekanwe, noneho urupapuro rwubusa ruzasohoka ku icapiro. Byarangiye, birashoboka mugushiraho icapiro Urupapuro rwimpapuro zidafite ibintu byubusa, ariko nibyiza gukuraho ibi bintu bitari ngombwa. Ntugomba rero gukora ibikorwa bimwe byiyongera mugihe ucapa. Byongeye kandi, umukoresha arashobora kwibagirwa gusa kubyara igenamiterere rikenewe, rizaganisha ku matsinda yimpapuro.
Mubyongeyeho, hari ibintu byubu ubusa mubyangombwa, urashobora kubimenya ukoresheje ahabigenewe. Kugirango tugereyo kwimukira kuri tab "dosiye". Ibikurikira, jya kuri "icapiro". Muburyo bukabije bwidirishya rifungura, agace kerekana inyandiko kazaba ziherereye. Niba uzunguruka mu karuzi mbere yo hasi hanyuma ugatahura mu idirishya ryerekanwe, ko nta makuru ari ku mpapuro zose, bivuze ko bazacapurwa muburyo bwo kubamo amabati.
Noneho reka twumve neza uburyo ushobora gusiba impapuro zubusa uhereye ku nyandiko, mugihe habaye kumenya, mugihe ukora ibikorwa byavuzwe haruguru.
Uburyo 1: Intego yo gucapa
Kugirango utayitwikire kumabati yubusa cyangwa adakenewe, urashobora gutanga agace k'icapa. Reba uko bikorwa.
- Hitamo urutonde rwamakuru kurupapuro kugirango ucarwe.
- Jya kuri tab "page Mariko", kanda ahanditse "Gucapa mukarere", uherereye mu "page igenamiterere". Ibikubiyemo bito bifungura, bigizwe ningingo ebyiri gusa. Kanda ku kintu "gushiraho".
- Turazigama dosiye hamwe nuburyo busanzwe ukanze igishushanyo muburyo bwa disiki ya mudasobwa mugice cyo hejuru cyibumoso bwidirishya.
Noneho burigihe mugihe ugerageza gucapa iyi dosiye, gusa agace k'inyandiko woherejwe kuri printer izatangwa. Rero, impapuro zubusa zizo zaciwe "kandi icapiro ryabo ntizizakorwa. Ariko ubu buryo bufite inenge. Niba uhisemo kongeramo amakuru kumeza, ugomba guhindura agace k'icapa kugirango usibe gusubira kumeza, kubera ko gahunda izoherezwa gusa kuri printer gusa wasobanuye muri igenamiterere.
Ariko ikindi kibazo gishoboka mugihe wowe cyangwa undi mukoresha wasabye agace k'icapa, nyuma ameza yahinduwe n'imirongo yakuweho. Muri iki gihe, impapuro zubusa zishyirwaho nkigice cyandika kizakomeza koherezwa kuri printer, nubwo nta kimenyetso kiri murwego rwabo, harimo umwanya. Kugirango ukureho iki kibazo, bizaba bihagije kugirango ukureho gusa.
Kugirango ukureho agace k'icapa kabura no gutanga intera ntabwo ikenewe. Gusa jya kuri tab "Marikoge", kanda ahanditse "Gucapa mukarere ka" Urupapuro Igenamiterere "hanyuma uhitemo" Kuraho "muri menu igaragara.
Nyuma yibyo, niba nta mwanya cyangwa izindi nyuguti ziri mu kasho hanze yimeza, imigozi irimo ubusa ntabwo izafatwa nkicyiciro.
Isomo: Nigute washyiraho agace kanditse muri Excel
Uburyo 2: Urupapuro rwuzuye
Niba ikibazo kitari kuba agace k'icapio hamwe nurwego rwubusa, nimpamvu ivuga ko impapuro zubusa zikubiye mu nyandiko, zigizwe no kubaho umwanya cyangwa izindi nyuguti ziyongera ku rupapuro, hanyuma muriki gihe, ku gahato intego yo gucapa ahantu ni igice kimwe.
Nkuko byavuzwe haruguru, niba imbonerahamwe ihora ihinduka, umukoresha agomba gushyiraho ibipimo bishya byo gucapa buri gihe mugihe cyo gucapa. Muri iki kibazo, intambwe ifatika izabasiba yuzuye mu gitabo cyurwego rurimo ahantu hadakenewe cyangwa izindi ndangagaciro.
- Jya kurupapuro rwo kureba igitabo kimwe muri ubwo buryo bubiri twasobanuye mbere.
- Nyuma yuburyo bwerekanwe burimo gukora, bugabana impapuro zose tutagikeneye. Turabikora tuyizengurutse hamwe na indanga hamwe na buto yimbeba yibumoso.
- Nyuma yibintu byerekanwe, kanda kuri buto yo gusiba kuri clavier. Nkuko mubibona, impapuro zose zidakenewe zavanyweho. Noneho urashobora kujya muburyo busanzwe bwo kureba.
Impamvu nyamukuru yo kuboneka impapuro zubusa mugihe cyo gucapa ni ugushiraho umwanya murimwe muri selile yubusa. Byongeye kandi, impamvu irashobora kuba ahantu hasobanutse neza. Muri iki gihe, ukeneye kubihagarika. Kandi, kugirango ukemure ikibazo cyo gucapa ubusa cyangwa bidakenewe, urashobora gushiraho agace kanditse, ariko nibyiza kubikora, ukureho amatsinda yubusa.