Gukora ibikorwa bimwe muri Excel, birasabwa kumenya ukundi selile cyangwa ururimi runaka. Ibi birashobora gukorwa mugutanga izina. Rero, niba iyobowe, gahunda izumva ko iyi ari agace runaka kurupapuro. Reka tumenye uburyo ubu buryo bushobora gukorwa muri Excel.
Inshingano
Urashobora gutanga umurongo cyangwa izina rya selile muburyo butandukanye, byombi ukoresheje ibikoresho bya kaseti no gukoresha menu. Igomba kubahiriza umubare wibisabwa:- Tangira ukoresheje ibaruwa, utondekanya cyangwa uva ku gitanda, ntabwo ari hamwe n'umubare cyangwa ikindi kimenyetso;
- Ntugashyiremo umwanya (ahubwo urashobora gukoresha munsi yo hepfo);
- Ntabwo icyarimwe adresse ya selile cyangwa intera (I.e., amazina yubwoko "A1: B2" akuyemo);
- Gira uburebure bwabantu bagera kuri 255 burimo;
- Umwihariko muriyi nyandiko (inyuguti zimwe zanditswe mu gitabo cyo hejuru no hepfo gifatwa nk'ibimwe).
Uburyo bwa 1: Umugozi
Biroroshye kandi byihuse gutanga izina rya selile cyangwa agace uyinjiramo mumazina. Uyu murima uherereye ibumoso wimirongo ya formula.
- Hitamo selile cyangwa urwego rugomba gukorwa.
- Mu izina umugozi, andika izina ryifuzwa ry'akarere, ukurikije amategeko yo kwandika imitwe. Kanda kuri buto ya Enter.
Nyuma yibyo, izina ryurwego cyangwa selile rizahabwa. Iyo watoranijwe, bizerekanwa mwizina umurongo. Twabibutsa ko mugihe cyo gutanga imitwe yubundi buryo buzasobanurwa hepfo, izina ryurwego rwabigenewe naryo rizerekanwa muri uyu murongo.
Uburyo 2: Ibikubiyemo
Inzira isanzwe yo guha izina selile ni ugukoresha ibikubiyemo.
- Tugenera akarere twifuza gukora igikorwa. Kanda kuri Iburyo bwimbeba. Muri ibikubiyemo bigaragara, hitamo "gutanga izina ..." ikintu.
- Idirishya rito rifungura. Muri "izina" umurima ukeneye gutwara izina ryifuzwa muri clavier.
Agace kerekana agace katoranijwe ka selile kazamenyekana kumurongo nizina ryahawe. Irashobora gukora nk'igitabo nka yose hamwe nimpapuro zitandukanye. Mubihe byinshi, birasabwa gusiga iyi mirimo isanzwe. Rero, igitabo cyose kizakora nk'ahantu hahuza.
Muri "ICYITONDERWA", urashobora kwerekana inyandiko iyo ari yo yose iranga urutonde rwatoranijwe, ariko ibi ntabwo ari ibipimo biteganijwe.
Umwanya "Urugero" rwerekana imirongo y'akarere, dutanga izina. Mu buryo bwikora uza hano kuri aderesi yurwego rwagaragaye mbere.
Nyuma yimiterere yose igaragara, kanda kuri buto "OK".
Izina ryatoranijwe ryatoranijwe ryahawe.
Uburyo 3: Gutanga izina ukoresheje buto ya kaseti
Kandi, izina ryurwego rirashobora gutangwa ukoresheje buto yihariye ya kati.
- Hitamo selile cyangwa urwego ukeneye gutanga izina. Jya kuri tab "formulaire". Kanda kuri "gutanga izina". Iherereye kuri kaseti mu "mazina amwe" umwanyabikoresho.
- Nyuma yibyo, izina ryizina umukoro rimaze kumenyera. Ibindi bikorwa byose bisubiramo neza ibyo byakoreshwaga mu kurangiza iki gikorwa muburyo bwa mbere.
Uburyo 4: Izina Kohereza
Izina ryakagari rirashobora kuremwa kandi rikoresheje izina umuyobozi.
- Kuba muri formula tab, kanda kuri "izina umuyobozi" buto, riherereye kuri kaseti muri "amazina amwe".
- "Umuyobozi ushinzwe ..." Idirishya rirafungura. Kugirango wongere izina rishya ryakarere, kanda kuri "Kurema ..."
- Birasanzwe ari idirishya rimenyerewe ryo kongeramo izina. Izina ryongewemo muburyo bumwe nko mubisobanuro byasobanuwe mbere. Kugaragaza ikintu gihuza, shyira indanga mu murima "intera", hanyuma ukuzindukira kurupapuro rutanga agace ushaka kuvuga. Nyuma yibyo, kanda kuri buto "OK".
Ubu buryo burarangiye.
Ariko iyi ntabwo aricyo kintu cyonyine cyumuyobozi. Iki gikoresho ntigishobora gusa gusa, ariko no gucunga cyangwa kubisiba.
Guhindura nyuma yo gufungura izina umuyobozi ushinzwe idirishya, hitamo ibyifuzo byifuzwa (niba uhantu hishuriwe mu nyandiko runaka) hanyuma ukande kuri buto "Guhindura ...".
Nyuma yibyo, idirishya rimwe rifungura ushobora guhindura izina ryakarere cyangwa aderesi yurwego.
Gusiba inyandiko, hitamo ikintu hanyuma ukande kuri buto "Gusiba".
Nyuma yibyo, idirishya rito rifungura, risaba kwemeza gukuraho. Kanda kuri buto ya "OK".
Byongeye kandi, hari akayunguruzo mumuyobozi uyobora izina. Yashizweho kugirango ahitemo inyandiko no gutondeka. Ibi nibiroroshye cyane mugihe uduce twitiriwe ari byinshi.
Nkuko mubibona, Excel itanga izina ryizina rimwe na rimwe. Usibye gukora inzira ukoresheje umurongo wihariye, bose batanga gukorana nizina ryizina ryizina. Byongeye kandi, ukoresheje izina ryizina umuyobozi, urashobora guhindura no gusiba.