Nigute Kwagura Akagari muri Excel

Kenshi na kenshi, ibikubiye muri selire kumeza ntibikwira mumipaka ishyirwaho bitemewe. Muri iki kibazo, ikibazo cyo kwaguka kwabo kiba gifite akamaro kugirango amakuru yose ahuze kandi akireba umukoresha. Reka tumenye uburyo ubu buryo bushobora gukorwa bushobora gukorwa.

Uburyo bwo Kwagura

Hariho amahitamo menshi yaguye selile. Bamwe muribo barimo gusohokana-imipaka, hamwe nabandi urashobora gushiraho ishyirwa mubikorwa ryikora muburyo bwimyitwarire bitewe nuburebure bwibirimo.

Uburyo 1: Imipaka yoroshye yo gukurura

Uburyo bworoshye kandi buto kugirango wongere ubunini bwa selire ni ugukurura imipaka yintoki. Ibi birashobora gukorwa ku gipimo gihagaritse kandi butambitse cyumirongo ninkingi zihuza.

1. Dushiraho indanga kumupaka ukwiye wumurenge ku gipimo cya horizontal gihuza inkingi dushaka kwaguka. Muri icyo gihe, umusaraba ugaragara hamwe na pointers ebyiri zerekeza ku mpande zinyuranye. Kanda buto yimbeba yibumoso nurubibi cyiburyo iburyo, ni ukuvuga kure ya Centre yagutse.



2. Nibiba ngombwa, inzira nkiyi irashobora gukorwa n'imirongo. Kugirango ukore ibi, ugomba gushyira indanga kumupaka wo hasi wurwego ugiye kwaguka. Mu buryo nk'ubwo, clamp ibumoso buto yo hepfo hanyuma ukureho umupaka.

Icyitonderwa! Niba kuri horizontal ya horizontal uhuza indanga kumupaka wibumoso winkingi yagutse, no ku gihagararo cyo hejuru yumurongo, no ku bushobozi bwo hejuru bwumurongo, no ku bushobozi bwo hejuru bwumurongo, no ku bushobozi bwo hejuru bwumurongo, no ku ruhago rwo hejuru rwumurongo, kandi ku ruganda rwo hejuru rwumurongo, kandi ku buryo bwo hejuru kumurongo, kandi ubunini bwa selile ntiziyongera. Bagenda gusa kuruhande kubera impinduka mubunini bwibindi bipapuro.

Uburyo 2: Kwagura inkingi nyinshi n'umurongo

Hariho kandi uburyo bwo kwagura inkingi nyinshi cyangwa imirongo icyarimwe.

1. Turagaragaza imirenge myinshi kuri horizontal nigipimo gihuje hamwe.



2. Dushiraho indanga kumupaka ukwiye iburyo bwiburyo kuva muri selile (ku gipimo cya horizontal) cyangwa ku rugero rwo hasi rwa selire yo hasi (ku gipimo gihagaze). Kanda buto yimbeba hanyuma ukurura umwambi wagaragaye cyangwa hepfo.



3. Ibi ntibikabuza intera ikabije, ariko nanone selile yabace bose batoranijwe.

Uburyo 3: Ingano yintoki yinjiza binyuze muri menu

Urashobora kandi gukora intoki yinjiza ingano ya selile, yapimwe mumibare. Mburabuzi, uburebure bufite ubunini bwiminsi 12.75, n'ubugari ni ibice 8.43. Urashobora cyane cyane amanota agera kuri 409, n'ubugari bwa 255.

1. Kugirango uhindure ibipimo byubugari bwa selire, hitamo urwego rwifuzwa kurugero rutambitse. Kanda kuri Iburyo bwimbeba. Mubice bikubiyemo ibigaragara, hitamo ikintu "ikingingo".



2. Idirishya rito rifungura, ukeneye kwishyiriraho ubugari bwifuzwa mubice. Injira ubunini bwifuzwa kuva clavier hanyuma ukande buto ya "ok".

Uburyo busa bugizwe n'imirongo.

1. Hitamo urwego cyangwa urutonde rwumunzani uhagaritse. Kanda kururu rubuga hamwe na buto yimbeba iburyo. Muri menu, hitamo "uburebure bwa" umugozi ... "ikintu.



2. Idirishya rifungura, aho ukeneye gutwara uburebure bwifuzwa bwa selile zimpapuro zatoranijwe mubice. Turabikora hanyuma ukande kuri buto "OK".

Manipulation yavuzwe haruguru igufasha kongera ubugari n'uburebure bwa selile mu bipimo byo gupima.

Uburyo 4: Injira ingano ya selile ukoresheje buto kuri lente

Byongeye kandi, birashoboka gushyiraho ubunini bwa selile binyuze muri buto ya kaseti.

1. Tugenera selile kurupapuro, ingano yacyo ushaka gushiraho.



2. Jya kuri tab "urugo", niba turi mubindi. Kanda kuri buto ya "format", iherereye kuri kaseti yo muri Toolbar ya "selile". Urutonde rwibikorwa bifungura. Ubundi hitamo muri yo ingingo "uburebure bwumurongo ..." n "ubugari bwa" inkingi ... ". Nyuma yo gukanda buri kintu, Windows nto izafungurwa, iyo nkuru yakurikiye mugihe isobanura uburyo bwabanje. Bazokenera kumenyekanisha ubugari nuburebure bwurutonde rwatoranijwe. Kugirango urwengire kwiyongera, agaciro gashya k'ibipimo bigomba kuba biruta mbere.

Uburyo 5: Ongera ingano yimpapuro cyangwa igitabo

Hariho ibihe mugihe ukeneye kongera selile zose zurupapuro cyangwa n'ibitabo. Bwira uko wabikora.

1. Kugirango ukore iki gikorwa, mbere ya byose, hitamo ibintu wifuza. Kugirango uhitemo ibice byose, urashobora gukanda gusa urufunguzo rwa clavier kuri ctrl + clavier. Hariho amahitamo ya kabiri. Bisobanura gukanda buto muburyo bwurukiramende, buherereye hagati yumubare uhagaritse kandi utambitse.



2. Urupapuro rumaze gutorwa nuburyo bumwe, kanda kuri format "imaze kumenyera" kuri kaseti kandi itanga ibindi bikorwa muburyo bumwe nkuko byasobanuwe muburyo bwambere hamwe ninzibacyuho ". . "na" Uburebure bw'umurongo ... ".

Ibikorwa bisa bitanga umusaruro wingirabuzimafatizo yigitabo cyose. Gusa kugirango ugaragaze impapuro zose dukoresha ikindi kibazo.

1. Mugukanda buto yimbeba iburyo kuri label imwe mumpapuro, iherereye hepfo yidirishya ako kanya hejuru yikigereranyo. Muri menu igaragara, hitamo "Igenamigambi" ikintu.



2. Impapuro zimaze kugaragara, kora igikorwa cya rubbon ukoresheje buto ya "imiterere", byasobanuwe muburyo bwa kane.

Isomo: Nigute Gukora Ingirabuzimafatizo zingana muri Excel

Uburyo 6: Ubugari

Ubu buryo ntibushobora kwitwa kwiyongera kwuzuye mubunini bwakagari, ariko, nyamara, birafasha kandi guhuza inyandiko mumipaka iboneka. Iyo bifashwa, kugabanuka kwikora mu bimenyetso byanditse nuko bihuye na selire. Rero, birashobora kuvugwa ko ingano yacyo ugereranije ninyandiko iriyongera.

1. Tugenera intera twifuza gukoresha imitungo yubugari bwubugari. Kanda kuri Kugaragaza buto yimbeba iburyo. Ibikubiyemo bifungura. Hitamo muri IT "imiterere ngendanwa ...".



2. Idirishya rifungura. Jya kuri tab "guhuza". Muri "kwerekana" igenamiterere, twashizeho amatiku hafi ya "Ubugari". Kanda kuri buto ya "OK" hepfo yidirishya.

Nyuma yibi bikorwa, nubwo gufata amajwi igihe kingana iki, ariko bizakwira muri kasho. Nibyo, ugomba gutekereza ko niba hari inyuguti nyinshi cyane mu rupapuro, kandi umukoresha ntazaguka hamwe nuburyo bumwe bwabanjirije, noneho iyinjira irashobora guhinduka nto cyane, kugeza kubidashoboka. Kubwibyo, barashobora kunyurwa na verisiyo yatanzwe kugirango habeho amakuru mumipaka, ntabwo mubibazo byose byemewe. Mubyongeyeho, byakagombye kuvugwa ko ubu buryo bukora hamwe ninyandiko gusa, ariko ntabwo ifite indangagaciro.

Nkuko tubibona, hariho inzira zitari nke zo kongera ingirabuzimafatizo zombi n'amatsinda yose, kugeza ku byiyongera mubintu byose cyangwa ibitabo. Buri mukoresha arashobora guhitamo uburyo bworoshye bwo gukora ubu buryo muburyo bwihariye. Byongeye kandi, hari uburyo bwiyongera bwo kwakira ibikubiye mu kagari gakoreshwa n'ubugari bw'ubugari. Nibyo, uburyo bwa nyuma bufite umubare munini.