Iyo ukora muri Excel, rimwe na rimwe ugomba guhisha inkingi. Nyuma yibyo, ibintu byagenwe birahagarara byerekanwe kurupapuro. Ariko icyo gukora mugihe ukeneye kongera kubakingura? Reka tubimenye muriki kibazo.
Kwerekana inkingi zihishe
Mbere yo guhindukirira kwerekana inkingi zihishe, ugomba kumenya aho biherereye. Kora byoroshye. Inkingi zose muri extle zirangwa ninyuguti z'inyuguti z'ikilatini, iherereye. Ahantu iri teka ryacitse, rigaragarira mu ibaruwa ihari, kandi ikintu cyihishe kirimo.
Inzira zihariye zo gukomeza kwerekana selile zihishe ziterwa nuburyo bwakoreshejwe muguhisha.
Uburyo 1: Imipaka yintoki
Niba wahishe selile wimura imbibi, noneho urashobora kugerageza kwerekana umurongo, ubayobora aho ubanza. Kugirango ukore ibi, birakenewe kuba umupaka no gutegereza isura yimiterere yimiterere ibiri. Noneho kanda buto yimbeba hanyuma ukurura umwambi kuruhande.
Nyuma yo gukora ubu buryo, selile izerekanwa muburyo bwoherejwe, nka mbere.
Nibyo, birakenewe kuzirikana ko niba iyo uhishe umupaka, byagabanijwe cyane, noneho bizagorana "kubafata" muri ubu buryo, ariko ntibishoboka. Kubwibyo, abakoresha benshi bahitamo gukemura iki kibazo bakoresha ubundi buryo.
Uburyo 2: Ibikubiyemo
Inzira yo gufungura kwerekana ibintu byihishe binyuze muri menu yihishe ni rusange kandi birakwiriye mubihe byose, nta tandukaniro nicyo amahitamo yarihishe.
- Dukerekana imirenge ituranye ninyuguti hagati yinkingi yihishe iherereye kumurongo wa horizontal.
- Hamwe na buto yimbeba iburyo kubintu byeguriwe Imana. Muri menu, hitamo "kwerekana".
Noneho inkingi zihishe zizatangira kongera kwerekana.
Uburyo 3: buto kuri lente
Gukoresha buto "Imiterere" kuri kaseti, kimwe nuburyo bwambere, bukwiriye ibibazo byose byo gukemura icyo gikorwa.
- Twimukiye kuri tab "urugo", niba uri muyindi tab. Tugenera selile zose zituranye, hagati yayo hari ikintu cyihishe. Kuri kaseti muri "Ibikoresho bya selile" guhagarika kanda kuri "imiterere". Ibikubiyemo bifungura. Muburyo bwa "kugaragara", twimukira kuri "guhisha cyangwa kwerekana". Kurutonde rugaragara, hitamo "kwerekana inkingi".
- Nyuma yibi bikorwa, ibintu bihuye bizagaragara.
Isomo: Uburyo bwo guhisha inkingi muri Excel
Nkuko mubibona, hariho inzira nyinshi zo gukora kwerekana inkingi zihishe. Muri icyo gihe, twakagombye kumenya ko verisiyo yambere ifite imfashanyigisho yumupaka izakwira hose niba selile zari zihishe kimwe, kandi imbibi zabo ntizimuwe cyane. Nubwo, ubu buryo buragaragara cyane kubakoresha utiteguye. Ariko andi mahitamo abiri akoresheje ibikubiyemo hamwe na buto ya kaseti irakwiriye gukemura iki gikorwa mubihe byose, nibyo, nibisanzwe.