Hariho ibibazo mugihe ukorera muri gahunda ya Excel, nyuma yumubare wa nimero muri selire, irerekanwa nkitariki. By'umwihariko ibi birababaje niba ukeneye kwinjiza amakuru yundi bwoko, kandi uyikoresha atazi kubikora. Reka tubimenye impamvu muri Excele aho kuba imibare itagaragara, kimwe no gusobanura uburyo bwo gukemura iki kibazo.
Gukemura ikibazo cyo kwerekana umubare nkitariki
Impamvu yonyine ituma amakuru yo mu Kagari ashobora kwerekanwa nkitariki nuko ifite imiterere ikwiye. Rero, gushiraho amakuru yerekana, nkuko bikeneye, umukoresha agomba kuyihindura. Urashobora kubikora icyarimwe muburyo bwinshi.Uburyo 1: Ibikubiyemo
Abakoresha benshi bakoresha ibikubiyemo kugirango bakemure iki gikorwa.
- Kanda iburyo kumurongo ukeneye guhindura imiterere. Muri ibikubiyemo, bizagaragara nyuma yibi bikorwa, hitamo ikintu "imiterere ya selile ...".
- Idirishya rifungura. Jya kuri tab "umubare" niba ufunguye mukindi tab. Tugomba guhindura "imiterere yimibare" hamwe na "itariki" kubakoresha uyikoresha ukeneye. Akenshi ni ibisobanuro bya "bisanzwe", "kuba", "amafaranga", "inyandiko", ariko hashobora kubaho abandi. Byose biterwa nikibazo cyihariye nintego yamakuru yinjiza. Nyuma yo gufungura ibipimo, kanda kuri buto "OK".
Nyuma yibyo, amakuru ari muri selile zatoranijwe ntizerekanwa nkitariki, kandi izerekanwa muburyo ukeneye. Ni ukuvuga, intego izagerwaho.
Uburyo 2: Guhindura imiterere kuri lente
Uburyo bwa kabiri ndetse noroshye mbere, nubwo kubwimpamvu zidakunzwe mubakoresha.
- Hitamo selile cyangwa urwego rwitariki.
- Kuba muri tab "urugo" muri "Umubare" wibikoresho, fungura imiterere yihariye. Yerekana imiterere izwi cyane. Hitamo imwe ibereye cyane amakuru yihariye.
- Niba amahitamo yifuzwa atabonetse murutonde rwatanzwe, hanyuma ukande ku kintu "izindi format yumubare ..." murutonde rumwe.
- Fungura neza uburyo bumwe bwo gushiraho idirishya, nkuko muburyo bwabanje. Ifite urutonde rwagutse rwimpinduka zamakuru zishoboka muri selire. Kubwibyo, ibindi bikorwa bizanasa neza nkikibazo aricyo gisubizo cya mbere. Hitamo ikintu wifuza hanyuma ukande kuri buto "OK".
Nyuma yibyo, imiterere muri selile zatoranijwe izahindurwa uwo ukeneye. Noneho umubare muri bo ntizerekanwa nkitariki, ariko uzafata urupapuro rwagenwe.
Nkuko mubibona, ikibazo cyo kwerekana itariki muri selile aho kuba umubare ntabwo ari ikibazo kitoroshye. Nibyiza rwose kuyikemura, gukanda bike hamwe nimbeba. Niba umukoresha azi algorithm yibikorwa, ubu buryo buhinduka abanza. Urashobora kubikora muburyo bubiri, ariko byombi bigabanuka kugirango uhindure imiterere ya selire kuva kumunsi.