Ungayinika njani igama leseli ukuze iphumelele

Ukwenza imisebenzi ye-Excel, kuyafuneka ukuba uchonge ngokwahlukeneyo iiseli ezithile okanye imiqolo. Oku kunokwenziwa ngokunika igama. Ke, ukuba kuyalelwe, le nkqubo iya kuqonda ukuba le yindawo ethile ephepheni. Masifumanise ukuba zeziphi iindlela ezinokwenziwa le nkqubo ye-Excel.

Isabelo segama

Unganikezela uluhlu okanye igama leseli eyahlukileyo ngeendlela ezininzi, zombini ezisebenzisa izixhobo zeteyiphu kunye nokusebenzisa imenyu yemeko. Kufuneka ihambelane nenani leemfuno:

• qala ngoonobumba, nge-ofisi engaphantsi okanye ukusuka kwi-slash, hayi ngenani okanye olunye uphawu;
• Ungabinazo izithuba (endaweni yoko ungasebenzisa i-onnercore esezantsi);
• Hayi kwangaxeshanye idilesi yeseli okanye uluhlu (i.e., amagama ohlobo "A1: B2" akabandakanywa);
• ube nobude obungaphezulu kwe-255 yeempawu ezibandakanyayo;
• Ikhethekileyo kolu xwebhu (iileta ezifanayo ezibhaliweyo kwiirejista ezingaphezulu nezantsi zithathwa njengezifana).

Indlela yoku-1: IGAMA

Kulula kwaye ukhawuleze ukunika igama leseli okanye indawo ngokuyifaka kwintambo yegama. Le ntsimi ibekwe ngasekhohlo kwe-formula yomtya.

1. Khetha iseli okanye udidi apho inkqubo mayiphume kuyo.



2. Kwintambo yegama, faka igama elifunwayo lengingqi, elinikezwe imigaqo yeZibizo Zoluleko. Cofa kwiqhosha lokungena.

Emva koko, igama loluhlu okanye isisele liya kwabelwa. Xa ukhethwe, iya kubonakala kwintambo yegama. Kufuneka iqatshelwe ukuba xa inika izihloko kuzo naziphi na iindlela eziza kuchazwa ngezantsi, uluhlu lwamagama olunikezelweyo luya kuboniswa kulo mgca.

Indlela 2: Imenyu yeMxholo

Indlela eqhelekileyo yokwabela iiseli zegama kukusebenzisa imenyu yemeko.

1. Sabela indawo apho sinqwenela ukwenza utyando. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yemeko evelayo, khetha igama elithi "Yabela igama ..." into.



2. Ifestile encinci ivula. Kwi "Igama" Intsimi kuya kufuneka uqhube igama elifunayo kwikhibhodi.

   Indawo ibonisa indawo apho uluhlu olukhethiweyo lweeseli luya kuchongwa kwikhonkco kwigama elinikezelweyo. Ingasebenza njengencwadi iyonke kunye namaphepha ayo ahlukeneyo. Kwiimeko ezininzi, kuyacetyiswa ukuba ishiye le ndawo igqibileyo. Ke, iNcwadi iyonke iya kwenza njengendawo yekhonkco.

   Kwintsimi "yenqaku", unokuchaza nayiphi na inqaku elibonisa uluhlu olukhethiweyo, kodwa le ayisiyonto inyanzelekileyo.

   Intsimi ethi "Uluhlu" ibonisa ukulungelelaniswa kommandla, esinika igama. Ngokuzenzekelayo iza apha kwidilesi yoluhlu owahlukileyo.

   Emva kokuba zonke iisetingi zichaziwe, cofa iqhosha u "Kulungile".

Igama loluhlu olukhethiweyo labelwe.

Indlela yesi-3: Ukunikezela ngegama usebenzisa iqhosha le-teepe

Kwakhona, igama loluhlu lunokwabelwa kusetyenziswa iqhosha elikhethekileyo leteyiphu.

1. Khetha iseli okanye uluhlu ekufuneka ulinike igama. Yiya kwi "formoulas" ithebhu. Cofa kwigama "labela igama". Ibekwe kwiteyiphu kwi "Namagama athile".



2. Emva koko, igama lesigama igama sele lisizi kuthi. Zonke iintshukumo ezingaphezulu ziphindaphinda kanye ezo zisetyenzisiweyo ekwenzeni lo msebenzi ngendlela yokuqala.

Indlela yesi-4: Nathi Spardatcher

Igama leseli linokudalwa kunye nomphathi wegama.

1. Ukuba kwi-formula tab, cofa kwiqhosha "yegama", elikwe kwitheyiphu kwi-Toolbar ye-".



2. "Umphathi wegama ..." iwindow ivula. Ukongeza igama elitsha lengingqi, cofa kwi "Dala ..." iqhosha.



3. Sele iwindow eqhelekileyo yokongeza igama. Igama longezwa ngendlela efanayo njengangaphambili. Ukuchaza into elungelelanisayo, faka isikhombisi kwintsimi "yoluhlu", kwaye emva koko ngqo kwiphepha olifunayo. Emva koko, cofa kwiqhosha "Kulungile".

Le nkqubo igqityiwe.

Kodwa ayisiyiyo kuphela inxalenye yomphathi wegama. Esi sixhobo asinakukwenza amagama, kodwa nokulawula okanye ukucima.

Ukuhlela emva kokuvula i-Window Window, khetha Ungenelelo olufunwayo (ukuba iindawo ezinamagama kuxwebhu) kwaye ucofe iqhosha elithi "Hlela ..." iqhosha ....

Emva koko, igama elifanayo legama lewindow livula apho unokutshintsha igama lendawo okanye idilesi yoluhlu.

Ukucima irekhodi, khetha into kwaye ucofe iqhosha elithi "Cima".

Emva koko, iwindow encinci ivula, ecela ukuqinisekisa ukususwa. Cofa kwiqhosha "Kulungile".

Ukongeza, kukho icebo lokucoca umphathi wegama. Yenzelwe ukukhetha iirekhodi kunye nokuhlelwa. Oku kuyinto efanelekileyo ngakumbi xa iindawo ezibiweyo zininzi kakhulu.

Njengoko ubona, i-Excel ibonelela ngeenombolo ezininzi zabanikezeli ngaxeshanye. Ukongeza ekwenzeni inkqubo ngomgca owodwa, bonke babonelela ngokusebenza ngegama legama legama. Ukongeza, ukusebenzisa igama legama igama, ungalilungisa kwaye ucime.