Ungawanikeza kanjani igama leseli ukuze udlule

Ukuze enze eminye imisebenzi ku-Excel, kuyadingeka ukuthi abone ngokwahlukile amaseli noma amabanga athile. Lokhu kungenziwa ngokunikeza igama. Ngakho-ke, uma kuqondiswa, uhlelo luzoqonda ukuthi le yindawo ethile ephepheni. Ake sibheke ukuthi iyiphi le nqubo engayenziwa ngayo le nqubo ku-Excel.

Isabelo segama

Ungabela i-array noma igama leseli elihlukile ngezindlela eziningana, zombili zisebenzisa amathuluzi we-tepi kanye nokusebenzisa imenyu yokuqukethwe. Kumele ihambisane nezidingo eziningi:

Qala ngohlamvu, nge-underscore noma kusuka ku-slash, hhayi ngenombolo noma olunye uphawu;
Ungabe uqukethe izikhala (esikhundleni salokho ungasebenzisa i-underscore engezansi);
Hhayi ngasikhathi sinye ikheli leseli noma ibanga (I.E., amagama ohlobo "A1: B2" alufakiwe);
ube nobude obuze kufinyelele kuzinhlamvu ezingama-255 ezibandakanya;
Ingqayizivele kulo mbhalo (izinhlamvu ezifanayo ezibhalwe kumarejista aphezulu nangaphansi zibhekwa njengezifana).

Indlela 1: I-NAME STRING

Kulula futhi kusheshe ukunikeza igama leseli noma indawo ngokuyifaka kwi-string yegama. Le nkambu itholakala ngakwesokunxele sentambo yefomula.

Khetha iseli noma ububanzi lapho inqubo kufanele yenziwe khona.

Nge-String yegama, faka igama elifiselekayo lesifunda, unikezwe imithetho yokubhala izihloko. Chofoza inkinobho ethi Enter.

Ngemuva kwalokho, igama lobubanzi noma iseli lizokwabelwa. Lapho ukhethiwe, kuzokhonjiswa nge-string yegama. Kumele kwaziwe ukuthi lapho unikezela izihloko kunoma yiziphi ezinye izindlela ezizochazwa ngezansi, igama lebanga elizinikezele lizokhonjiswa kulolu ngomu.

Indlela 2: Imenyu yokuqukethwe

Indlela ejwayelekile yokunikeza amaseli wegama ukusebenzisa imenyu yokuqukethwe.

Sabela indawo esifisa ukwenza umsebenzi. Chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe evelayo, khetha igama elithi "Nikeza Igama ..." Into.

Ukuguqulwa kwegama legama ku-Microsoft Excel

Kuvulwa iwindi elincane. In the "Igama" insimu udinga ukushayela igama olifunayo kwikhibhodi.
Le ndawo ikhombisa indawo lapho uhla olukhethiwe lwamaseli luzokhonjwa kusixhumanisi segama elinikezwe. Kungasebenza njengencwadi yonke, amashidi alo ahlukile. Ezimweni eziningi, kunconywa ukushiya lesi seluleko esizenzakalelayo. Ngakho-ke, yonke incwadi izokwenza njengendawo yokuxhumanisa.
Ensimini "yenothi", ungacacisa noma yimuphi umbhalo ophawula uhla olukhethiwe, kepha lokhu akuyona ipharamitha eliyisibopho.
Insimu ye- "Range" Ibonisa izixhumanisi zesifunda, esimnika igama. Iza lapha ngekheli lebanga eliqokonyiswe ekuqaleni.
Ngemuva kwazo zonke izilungiselelo zichaziwe, chofoza inkinobho ethi "Kulungile".

Ukunikeza igama legama ku-Microsoft Excel

Igama le-array elikhethiwe liyabelwa.

Indlela 3: Ukunikeza igama kusetshenziswa inkinobho yetheyiphu

Futhi, igama lebanga lingabelwa kusetshenziswa inkinobho ekhethekile yeteyiphu.

Khetha iseli noma uhla oludingayo ukunikeza igama. Iya kuthebhu "yefomula". Chofoza inkinobho ethi "Nikeza Igama". Itholakala etheyipini yamathuluzi "athile" wamathuluzi ".

Ukunikeza igama ngeteyipu e-Microsoft Excel

Emva kwalokho, igama legama legama selivele lisijwayele. Zonke ezinye izenzo ziphindaphindwa kahle lezo ezazisetshenziswa ekwenzeni lo msebenzi ngendlela yokuqala.

Indlela 4: Igama Lokuhambisa Igama

Igama leseli lingadalwa futhi ngeMenenja yegama.

Ukuba ku-formula tab, chofoza inkinobho ethi "Imenenja yegama", etholakala kwitheyipu "yamagama athile" wamathuluzi.

"Imenenja yegama ..." iwindi livulwa. Ukwengeza igama elisha lesifunda, chofoza inkinobho ethi "Dala ...".

Iya ekwakheni igama kusuka kumphathi wegama nge-Microsoft Excel

Sekuvele kahle iwindi elijwayelekile lokwengeza igama. Leli gama lingezwa ngendlela efanayo nakuma-variants achazwe ngaphambilini. Ukucacisa izixhumanisi zento, faka ikhesa enkambu ye- "Range", bese ngqo ngqo eshidini labela indawo ofuna ukuyibiza. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".

Ukwakha Igama Ngegama Lokuhambisa Igama E-Microsoft Excel

Le nqubo isiqediwe.

Kepha lesi akusona ukuphela kwesimo seMenenja yegama. Leli thuluzi alikwazi ukudala amagama kuphela, kodwa futhi nokuphatha noma ukuzisusa.

Ukuhlela ngemuva kokuvula iwindi leMenenja yegama, khetha ukungena okudingayo (uma izindawo eziqanjwe ngalo mbhalo zikunye) bese uchofoza inkinobho ethi "Hlela ...".

Ukuhlela Ukuqoshwa Kumagama Manager in Microsoft Excel

Emva kwalokho, iwindi elifanayo livuleka lapho ungashintsha khona igama lendawo noma ikheli lobubanzi.

Ukususa irekhodi, khetha into bese uqhafaza inkinobho ethi "Delete".

Susa Ukurekhoda kumphathi wegama ku-Microsoft Excel

Emva kwalokho, iwindi elincane livuleka, elicela ukuqinisekisa ukususwa. Chofoza inkinobho ethi "KULUNGILE".

Ukususa Ukuqinisekisa ku-Microsoft Excel

Ngaphezu kwalokho, kunesihlungi kumphathi wegama. Yenzelwe ukukhetha amarekhodi nokuhlunga. Lokhu kulula kakhulu lapho izindawo eziqanjiwe ziningi kakhulu.

Hlunga kumphathi wamagama ku-Microsoft Excel

Njengoba ubona, i-Excel inikeza izinketho ezabelwe amagama amaningi ngasikhathi sinye. Ngaphezu kokwenza inqubo ngomugqa okhethekile, bonke bahlinzeka ngokusebenza negama legama. Ngaphezu kwalokho, usebenzisa umphathi wegama legama igama, ungahlela futhi ususe.