Ukuqamba iseli nobubanzi ku-Excel

Ngezinye izikhathi, ukuze yenze izenzo ezithile noma ukuze kube lula, i-Excel idinga ukunikeza amagama athile kumaseli ngamanye noma ububanzi bamaseli ukuze iqhubeke iwakhomba. Ake sibone ukuthi singawufeza kanjani lo msebenzi.

Izidingo zokuqamba iseli

Kuhlelo, inqubo yokunikeza amagama kumaseli yenziwa kusetshenziswa izindlela ezimbalwa. Kodwa ngesikhathi esifanayo kunezidingo ezithile zamagama ngokwawo:

1. Awukwazi ukusebenzisa izikhala, okhefana, amakholoni, amasemikholoni njengesihlukanisi samagama (ukushintshanisa nge-underscore noma ichashazi kungaba indlela yokuphuma kulesi simo).
2.  Ubude bezinhlamvu obukhulu bungama-255.
3. Igama kufanele liqale ngezinhlamvu, i-underscore, noma i-backslash (azikho izinombolo noma ezinye izinhlamvu).
4. Awukwazi ukucacisa ikheli leseli noma ububanzi.
5. Isihloko kufanele sihluke ngaphakathi kwencwadi efanayo. Kulokhu, kufanele kukhunjulwe ukuthi uhlelo luzobona izinhlamvu kumarejista ahlukene zifana ngokuphelele.

Qaphela: Uma iseli (ububanzi bamaseli) linegama, lizosetshenziswa njengereferensi, isibonelo, kumafomula.

Ake sithi iseli B2 okuthiwa “Ukuthengisa_1”.

Uma ebamba iqhaza kufomula, esikhundleni sokuthi B2 siyabhala “Ukuthengisa_1”.

Ngokucindezela inkinobho Faka Siyaqiniseka ukuthi ifomula iyasebenza ngempela.

Manje ake siqhubekele phambili, ngqo, ezindleleni ngokwazo, ongasetha ngazo amagama.

Indlela 1: umucu wegama

Mhlawumbe indlela elula yokuqamba iseli noma ububanzi ukufaka inani elidingekayo kubha yegama, etholakala kwesokunxele sebha yefomula.

1. Kunoma iyiphi indlela elula, isibonelo, ngokucindezela inkinobho yegundane kwesokunxele, khetha iseli oyifunayo noma indawo.
2. Sichofoza ngaphakathi komugqa wegama bese ufaka igama olifunayo ngokwezidingo ezichazwe ngenhla, ngemuva kwalokho sicindezela ukhiye Faka kukhibhodi.
3. Njengomphumela, sizokwabela igama ebangeni elikhethiwe. Futhi lapho sikhetha le ndawo ngokuzayo, sizobona leli gama emugqeni wamagama.
4. Uma igama lilide kakhulu futhi lingangeni emkhakheni ojwayelekile womugqa, umngcele walo ongakwesokudla ungahanjiswa ngokucindezelwa kwenkinobho yegundane kwesokunxele.

Qaphela: lapho unikeza igama nganoma iyiphi yezindlela ezingezansi, lizophinde liboniswe kubha yegama.

Indlela 2: Ukusebenzisa Imenyu Yokuqukethwe

Ukusebenzisa imenyu yokuqukethwe ku-Excel kukuvumela ukuthi wenze imiyalo nemisebenzi edumile. Ungakwazi futhi ukwabela igama iseli ngokusebenzisa leli thuluzi.

1. Njengokujwayelekile, okokuqala udinga ukumaka iseli noma ububanzi bamaseli ofuna ukwenza ngawo ukukhohlisa.
2. Bese uchofoza kwesokudla endaweni ekhethiwe futhi ohlwini oluvulayo, khetha umyalo “Yabela Igama”.
3. Iwindi lizovela esikrinini lapho:
   • bhala igama esikhaleni ngokuphambene nento yegama elifanayo;
   • inani lepharamitha “Inkundla” ngokuvamile ishiywa ngokuzenzakalelayo. Lokhu kubonisa imingcele lapho igama lethu elinikeziwe lizobonakala khona - ngaphakathi kweshidi lamanje noma yonke incwadi.
   • Endaweni ephambene nephuzu "Qaphela" engeza amazwana uma kunesidingo. Ipharamitha uyazikhethela.
   • inkambu ephansi kakhulu ibonisa izixhumanisi zebanga elikhethiwe lamaseli. Amakheli, uma efunwa, angahlelwa - ngesandla noma ngegundane ngqo etafuleni, ngemva kokubeka ikhesa ensimini yokufaka ulwazi nokususa idatha yangaphambilini.
   • uma usulungile, cindezela inkinobho OK.
4. Konke sekulungile. Sinikeze ububanzi obukhethiwe igama.

Indlela yesi-3: Sebenzisa Amathuluzi ku-Ribbon

Vele, ungaphinda unikeze igama kumaseli (izindawo zamaseli) usebenzisa izinkinobho ezikhethekile kuribhoni yohlelo.

1. Simaka izakhi ezidingekayo. Ngemva kwalokho, shintshela kuthebhu "Amafomula". Eqenjini “Amagama athile” chofoza inkinobho "Setha Igama".
2. Ngenxa yalokho, iwindi lizovuleka, umsebenzi esiwuhlaziye kakade esigabeni sesibili.

Indlela yesi-4: Ukusebenza Kumphathi Wegama

Le ndlela ihilela ukusetshenziswa kwethuluzi elinjalo njenge Umphathi wegama.

1. Ngemva kokukhetha ububanzi obufunekayo bamaseli (noma iseli elilodwa elithile), iya kuthebhu "Amafomula", lapho kubhlokhi “Amagama athile” chofoza inkinobho "Umphathi Wegama".
2. Iwindi lizovela esikrinini. I-Dispatcher. Lapha sibona wonke amagama adalwe ngaphambilini. Ukwengeza entsha, cindezela inkinobho "Dala".
3. Iwindi elifanayo lokudala igama lizovuleka, esesivele sixoxe ngalo ngenhla. Gcwalisa imininingwane bese uchofoza OK. Uma ekushintsheni kuya Umphathi wegama Uma uhla lwamaseli lukhethwe ngaphambilini (njengakithi), izixhumanisi zalo zizovela ngokuzenzakalelayo kunkambu ehambisanayo. Uma kungenjalo, zigcwalisele wena idatha. Indlela yokwenza lokhu ichazwe endleleni yesibili.
4. Sizoba sefasiteleni elikhulu futhi Umphathi wegama. Ungaphinda ususe noma uhlele amagama adalwe ngaphambilini lapha.Ukuze wenze lokhu, vele ukhethe umugqa owufunayo bese uchofoza kumyalo ofuna ukuwukhipha.
   • ngokucindezela inkinobho "Shintsha", iwindi lokushintsha igama liyavuleka, lapho singenza khona izinguquko ezidingekayo.
   • ngokucindezela inkinobho "Susa" Uhlelo luzocela ukuqinisekiswa ukuze luqedele ukusebenza. Qinisekisa isenzo ngokuchofoza inkinobho OK.
5. Lapho usebenza Umphathi wegama iqediwe, ivale.

Isiphetho

Ukuqamba iseli elilodwa noma uhla lwamaseli ku-Excel akuwona umsebenzi ovame kakhulu futhi akuvamile ukusetshenziswa. Nokho, kwezinye izimo, umsebenzisi ubhekana nomsebenzi onjalo. Ungakwenza lokhu ohlelweni ngezindlela ezahlukahlukene, futhi ungakhetha oyithanda kakhulu futhi ebonakala ifaneleka kakhulu.