Nigute Gushyira Zeru imbere yumubare muri Excel

Uburyo 1: Guhindura imiterere ya selile kugirango "inyandiko"

Igikorwa cyoroshye gishobora gufatwa nibiba ngombwa kongeramo imibare ya zeru ni uguhindura imiterere ya selile zikenewe kumyandiko, kugirango ntikibone ibibazo byo gukuraho byikora. Kuri iyi miterere muri Excel hari menu yagenwe.

1. Guhita uhitemo selile zose zisabwa zifite numero ufunga buto yimbeba.



2. Kuri tab yo murugo, fungura igice "selile".



3. Hamagara "imiterere" yamanutse.



4. Muri yo, kanda ku cyiciro cyanyuma cyimiterere yimodoka.



5. Idirishya rishyiraho idirishya rizagaragara, aho mugice cyibumoso kanda inshuro ebyiri "inyandiko" kugirango ushyireho ubwoko. Niba idirishya ridafunze mu buryo bwikora, kora wenyine.



6. Garuka ku ndangagaciro muri selile hanyuma wongere zeru aho bibaye ngombwa. Reba ko hamwe na gahunda nkiyi, amafaranga ntazasuzumwa nonaha, kubera ko imiterere yimodoka atari umubare.

Uburyo 2: Gukora imiterere yawe

Uburyo bwiza bukwiye bwo kwishyiriraho Zerosi yikora imbere yimibare mugihe bidashaka gukora cyangwa inzira izafata umwanya munini. Gukora imiterere yawe uko bishoboka birashoboka niba ubanza uzi uburyo imibare igomba kuba iherereye, kurugero, hamwe na code yubwishingizi cyangwa ibiranga. Kurugero, fata ubwoko bwa 000 000 000.

1. Hitamo ibice byose byihariye hamwe numubare, fungura menu imwe yamanutse kugirango ushireho selile hanyuma ujye kuri "formasiyo".



2. Iki gihe, hitamo "(imiterere yose)."



3. Ntukoreshe ameza hamwe nubwoko, kandi wuzuze intoki kugirango icyitegererezo gibone neza.



4. Garuka kumeza kandi urebe neza ko igenamiterere ryose rikoreshwa neza.

Uburyo 3: Guhindura byihuse imiterere yingingo

Mugihe uhindura selile runaka, urashobora gukoresha excel syntax kugirango ukoreshe inyandiko. Ibi ni ingirakamaro mubihe byubu kugirango uhindure vuba agaciro kagaciro hanyuma wongere zeru.

1. Muri iki kibazo, hitamo selile hanyuma ukore umurima wacyo kugirango uhindure.



2. Shira ikimenyetso "'" Ku ntangiriro udafite umwanya.



3. Nyuma yiki kimenyetso, ongeraho umubare ukenewe wa zeru ukoresheje umwanya, nibiba ngombwa. Kanda ENTER kugirango wemeze impinduka.



4. Menya neza ko ubungubu ibirimo byerekanwe neza.

Uburyo 4: Gutegura imibare muri selile nshya

Itandukaniro ryanyuma ryo kongeramo zeru imbere yimibare muri Excel bisobanura imiterere yibirimo muri blok nshya ukoresheje imikorere yinyandiko. Reba ko muriki kibazo selile nshya zakozwe namakuru, azerekanwa hepfo.

1. Gutangira, dusobanura umubare wimibare. Urashobora gukoresha umwanya cyangwa hyphen, biterwa n'ubwoko busabwa bwo gufata amajwi.



2. Mu kagari kambaye ubusa, tangira kwandika formula "= inyandiko".



3. Nyuma yo kongeramo umugozi ufunguye kandi ufunze, ugaragaza selile kugirango ikore.



4. Ongeraho koma yerekana gutandukanya agaciro kuva kumiterere.



5. Fungura amagambo abiri hanyuma wandike, muburyo bwanditse inyandiko igomba kwerekanwa (tumaze kuvuga hejuru).



6. Kanda urufunguzo rwinjira hanyuma urebe ibisubizo. Nkuko bigaragara, agaciro karemewe numubare winyuguti, kandi imibare yabuze isimburwa na zeru iri imbere, bisabwa mugihe ugereranya urutonde rwibimenyeshwa, nimero yubwishingizi nandi makuru.

Nkinyongera, turagusaba kubimenyereye izindi ngingo ebyiri zishyigikira kurubuga rwacu, zizaba ingirakamaro mugihe uhindura ibikubiye muri selile no gukoresha formulaire.

Reba kandi:

Kuraho indangagaciro ze zero muri Microsoft Excel

Kuraho icyuho hagati yimibare muri Microsoft Excel