Nigute washyiramo plus udafite formulaire mubuhungiro

Uburyo 1: Guhindura imiterere ya selile kugirango "inyandiko"

Inzira yoroshye yo gukemura ikibazo no kwinjiza "+" muri selile mbere yuko umubare ugomba guhindura imiterere ya selire kuri "inyandiko". Sisitemu ya Excel rero ntishobora gufatwa nkibikenewe kugirango ikureho ikimenyetso cyongeyeho, mugihe rero cyo gukiza impinduka muri selire, bizagumaho. Imiterere yambere yo guhindura amahitamo nukwita ibikubiyemo.

1. Kanda ahabigenewe hamwe na buto yimbeba iburyo.



2. Mubikubiyemo bigaragaye, hitamo "imiterere yimodoka".



3. Kanda kuri "inyandiko" hanyuma uzigame impinduka ukanda buto "OK".



4. Sohora iyi menu hanyuma wongere ikimenyetso kuri selile agaciro ka selire.



5. Kanda ENT kugirango ushyire mubikorwa impinduka kandi urebe neza ko ubu "+" utarabuze ahantu hose.

Hariho uburyo bwa kabiri bwo guhindura imiterere ya selile, nayo igaragara, kuko mubihe bimwe na bimwe bizasa nkaho byoroshye.

1. Ubwa mbere, hitamo ikibanza kugirango uhindure ukanze kuri lkm, hanyuma kurupapuro rwabavuri, wagure igice cyamanutse muri "Umubare".



2. Muri yo, hitamo uburyo "inyandiko".



3. Garuka muri selire, ongeraho wongeyeho hanyuma ukande kuri Enter.

Uburyo bwa 2: Gahunda ya USAGE Cyntax

Yinjijwe muri Excel Syntax mugihe uhindura selile igufasha gushyira amayeri mato niba ukeneye kwerekana imiterere cyangwa ibintu bimwe na bimwe. Mu rubanza rusekeje, uzakenera gushyira ikimenyetso kimwe kugira ngo "+" bitazimira.

1. Hitamo selire kandi ukore formulaire yinjiza.



2. Ku ntangiriro, shyira ikimenyetso kimwe cyanditseho ibimenyetso - "'" (inyuguti e muburyo bw'Uburusiya).



3. Noneho ko indanga ari iy'ibitabo, andika ikimenyetso cyongeyeho.



4. Nyuma yo gukanda kuri Enter Urufunguzo, uzabona ko imiterere yimodoka ihita ihinduka kumyandiko kandi wongeyeho ntabwo yazimiye.

Reba ko ibikorwa bisuzumwa kandi bihindura imiterere ya selire, ubu rero ntibizashoboka kuyongera kuri formula cyangwa kubara vuba umubare nkuko biranga ibisubizo byose bifitanye isano no kwinjiza "+" udafite formulaire.

Uburyo 3: Shyiramo ikimenyetso cyihariye

Excel ishyigikira kwinjiza inyuguti zidasanzwe, ndetse na menu zitandukanye zahawe. Ngaho hagomba kwitondera inyuguti ebyiri "+", ninde ushobora kuboneka murwego rwo hejuru cyangwa ruto. Niba washakaga kubamo ihitamo, ukurikize amabwiriza akurikira.

1. Kuri buto yimbeba yibumoso, hitamo selile kugirango ushiremo ikimenyetso hanyuma ujye kuri tab "shyiramo".



2. Kwagura "Ibimenyetso".



3. Muri yo, hitamo uburyo bwa kabiri "ikimenyetso".



4. Muri menu yamanutse "Gushiraho", hindura "hejuru no hepfo.



5. Shakisha ikimenyetso cyongeyeho hejuru cyangwa hepfo, hanyuma ukande inshuro ebyiri kuri yo kongeramo.



6. Garuka ku Kagari kandi urebe neza ko hari ikimenyetso kidasanzwe, hanyuma ukomeze engera uhindure ibirimo.