Ungawengeza kanjani umugqa omusha ku-Excel. Ngaphakathi nasekupheleni kwetafula, “kuthebula elihlakaniphile”

Ngesikhathi sokukhohlisa okuhlukahlukene ngolwazi lwethebula, kuvame ukudingeka ukwengeza imigqa emisha. Inqubo yokwengeza ilula kakhulu futhi iyashesha, kodwa abasebenzisi abaningi banobunzima phakathi nalesi sinyathelo. Kulesi sihloko, sizocubungula zonke izindlela ezikuvumela ukuthi ungeze umugqa omusha epuletini, futhi uthole zonke izici zalo msebenzi.

Ungawufaka kanjani umugqa omusha

Inqubo yokwengeza imigqa emisha epuletini lokuqala iyafana kuzo zonke izinguqulo zomhleli wespredishithi. Yebo, kukhona umehluko omncane, kodwa awubalulekile. Imiyalelo enemininingwane ibukeka kanje:

1. Ekuqaleni, sithola noma sakha ithebhulethi. Sikhetha iseli yomugqa ngenhla esihlela ukubeka umugqa omusha. Chofoza inkinobho yegundane engakwesokudla kuseli ekhethiwe. Kuvele imenyu yokuqukethwe encane, lapho kufanele uthole khona into ethi "Faka ..." bese uchofoza kuyo ngenkinobho yegundane kwesokunxele. Enye indlela ukusebenzisa inhlanganisela yokhiye "Ctrl" kanye "+".

2. Uhlelo luveze iwindi elibizwa ngokuthi “Faka”. Ngaleli windi, ungasebenzisa ukwengeza umugqa, ikholomu noma iseli. Sibeka imfashini eduze nombhalo othi "Umugqa". Chofoza into ethi "KULUNGILE" ukuze ulondoloze izinguquko zakho.

3. Ilungile! Umugqa omusha wengezwe etafuleni. Sicela uqaphele ukuthi lapho ungeza umugqa omusha, kuthatha zonke izilungiselelo zokufometha kulayini ongenhla.

Kubalulekile! Kukhona indlela eyengeziwe ekuvumela ukuthi ungeze umugqa omusha. Sicindezela i-RMB enombolweni ye-serial yomugqa, bese kumenyu yokuqukethwe evulayo, chofoza umbhalo othi "Faka".

Ungawufaka kanjani umugqa omusha ekugcineni kwetafula

Kuvamise ukwenzeka ukuthi umsebenzisi udinga ukusebenzisa ukungeza umugqa ekugcineni kwedatha yethebula. Imiyalelo enemininingwane ibukeka kanje:

1. Ekuqaleni, sikhetha wonke umugqa owedlulele wepuleti ngokucindezela inkinobho yegundane kwesokunxele enombolweni ye-serial. Hambisa isikhombi ngezansi kwesokudla somugqa. Ikhesa kufanele ibonakale yophawu oluncane olumnyama oluhlanganisayo.

2. Sibamba lolu phawu lokuhlanganisa ngenkinobho yegundane lesokunxele bese siludonsela phansi, ngenani lemigqa esihlela ukuyifaka. Ekugcineni, khulula i-LMB.

3. Siyaqaphela ukuthi yonke imigqa eyengeziwe igcwaliswe ngokuzimele ngolwazi oluvela kuseli elikhethiwe. Ukufometha koqobo nakho kusele. Ukuze usule amaseli agcwalisiwe, kufanele wenze inqubo yokukhetha imigqa emisha, bese uchofoza ku-"Susa" kukhibhodi. Enye inketho ukuchofoza kwesokudla ezinkambini ezikhethiwe, bese ukhetha into ethi Sula Okuqukethwe kumenyu yokuqukethwe ekhethekile evulekayo.

4. Ilungile! Siqinisekise ukuthi imigqa emisha engeziwe iyasulwa olwazini olungadingekile. Manje singakwazi ukwengeza idatha edingekayo lapho ngokwethu.

Kubalulekile! Le ndlela ifaneleka kuphela kulezo zikhathi lapho umugqa ophansi ungasetshenziswanga ekubukeni "Ingqikithi", futhi futhi ayihlanganisi imigqa engenhla.

Indlela yokudala itafula elihlakaniphile

Amathebula “Ahlakaniphile” asetshenziswa ukuze umsebenzisi akwazi ukusebenza kahle ngenani elikhulu lolwazi. Ipuleti yalolu hlobo ikhuliswa kalula, okusho ukuthi imigqa emisha ingafakwa nganoma yisiphi isikhathi esikahle. Imiyalelo enemininingwane ibukeka kanje:

1. Senza ukukhetha kwendawo yokusebenza esihlela ukuyiguqula ibe ipuleti “elihlakaniphile”. Sithuthela esigabeni "Ekhaya", bese sithola into ebizwa ngokuthi "Fometha njengethebula." Sembula uhlu olude lwamapuleti ahlongozwayo. Khetha isitayela osithanda kakhulu bese uchofoza kuso ngenkinobho yegundane engakwesokunxele.

2. Iwindi leThebula Lefomethi liyavela esikrinini. Lapha, ikheli lethebhulethi eyabelwe ekuqaleni lifakiwe. Uma izixhumanisi zingakufanelanga, ungazihlela kuleli bhokisi lengxoxo. Chofoza "KULUNGILE" ukuze uqinisekise zonke izilungiselelo ezenziwe. Kuyaphawuleka ukuthi eduze nombhalo othi "Ithebula elinezihloko" kufanele lihlolwe.

3. Ilungile! Senze ukwakhiwa kwepuleti “elihlakaniphile” futhi manje singakwazi ukwenza okunye ukukhohlisa ngalo.

Ungawufaka kanjani umugqa omusha kuthebula elihlakaniphile

Ukuze usebenzise inqubo yokwengeza umugqa omusha kupuleti "ehlakaniphile", ungasebenzisa izindlela ezingenhla. Imiyalelo enemininingwane ibukeka kanje:

1. Chofoza kwesokudla kunoma iyiphi iseli. Kumenyu ekhethekile evulayo, thola into ethi "Faka" bese uyivula. Ohlwini oluvelayo, chofoza "Ithebula Imigqa Ngenhla".

2. Enye indlela yokwengeza umugqa omusha ukusebenzisa inhlanganisela yokhiye abashisayo abakhethekile u-“Ctrl” no-“+”. Ukusetshenziswa kwama-hotkeys kunciphisa kakhulu isikhathi esichithwa kwinqubo yokwengeza imigqa emisha epuletini.

Ungawufaka kanjani umugqa omusha ekugcineni kwetafula elihlakaniphile

Kunezindlela ezintathu ezikuvumela ukuthi ungeze umugqa omusha ekupheleni kwepuleti "ehlakaniphile". Imiyalo enemininingwane yokwengeza ulayini omusha ekugcineni kwepuleti elithi “smart” ibukeka kanje:

1. Hudula ingxenye engezansi kwesokudla sepuleti ngenkinobho yegundane kwesokunxele. Ngemuva kwalesi senzo, ipuleti lizokwanda ngokwalo. Izongeza imigqa eminingi njengoba idinga umsebenzisi.

2. Lapha, amaseli angeziwe ngeke agcwaliswe ngokuzenzakalelayo ngolwazi lokuqala. Amafomula kuphela azohlala ezindaweni zawo. Ngakho-ke, asikho isidingo sokusula okuqukethwe kwamaseli, ngoba asevele angenalutho.

3. Enye inketho ukubhala idatha entsha emugqeni ongaphansi kwepuleti lokuqala elithi "smart". Uma usebenzisa le nqubo, khona-ke umugqa omusha uzophenduka ngokuzenzakalelayo into yepuleti "elihlakaniphile".

4. Indlela yesithathu iwukuthuthela onqenqemeni olungezansi kwesokudla seseli yepuleti elithi "smart" bese uchofoza inkinobho ethi "Tab" etholakala kukhibhodi.

5. Ngemva kokusetshenziswa kwalesi senzo, ulayini ofakiwe uzokwengezwa ngokuzenzakalelayo kuthebula elithi “smart” kugcinwe ukufometha kwasekuqaleni.

Ukwengeza Imigqa Eminingi Engenalutho kusipredishithi se-Excel

Ukuze usebenzise inqubo yokwengeza imigqa emibili noma ngaphezulu engenalutho kudatha yethebula, udinga ukwenza izinyathelo ezimbalwa ezilula. Umyalelo onemininingwane yokwengeza imigqa engenalutho ubukeka kanje:

1. Sisebenzisa inkinobho yegundane kwesokunxele, sikhetha umugqa lapho sihlela ukwengeza amasha, bese, ngaphandle kokukhulula i-LMB, khetha inombolo yemigqa esifuna ukuyengeza kudokhumenti yespredishithi.
2. Ukukhethwa kwayo yonke imigqa edingekayo kwenziwa ngempumelelo. Manje udinga ukuchofoza kwesokudla noma yikuphi endaweni yokusebenza ekhethiwe.
3. Kuvulwe imenyu encane yokuqukethwe okukhethekile, lapho udinga ukuthola khona into enegama elithi "Faka" bese uchofoza kuyo ngenkinobho yegundane kwesokunxele. Enye inketho iwukusebenzisa amathuluzi atholakala kuribhoni ekhethekile etholakala phezulu kwesixhumi esibonakalayo somhleli wespredishithi.
4. Ilungile! Senze inqubo yokwengeza imigqa eminingana engenalutho epuletini lokuqala.

Indlela yokufaka/ukwengeza inombolo enikeziwe yemigqa engenalutho/emisha ezindaweni ezithile?

Lesi sici singenziwa kusetshenziswa amathuluzi e-VBA. Ungafunda kabanzi ngale nqubo ngokubuka ividiyo elandelayo:

Kuvidiyo engenhla, uzofunda yonke imininingwane yokusebenzisa izengezo, ukusebenzisa amamakhro nezinye izici eziwusizo ezikhona kusihleli sespredishithi se-Excel.

Ifaka inombolo ehlukene yemigqa engenalutho

Isibonelo, sinethebula elilandelayo elinolwazi oludingekayo:

Umyalelo onemininingwane wokufaka inombolo ehlukile yemigqa yohlobo olungenalutho ubukeka kanje:

1. Sithuthela ebhokisini lengxoxo elibizwa ngokuthi "Faka Imigqa Engenalutho Ngokuzenzakalelayo".
2. Enkambini ethi “Inombolo Yekholomu enenombolo yemigqa,” cacisa inani esilidingayo.
3. Kuyaphawuleka ukuthi uma simaka ibhokisi eliseduze kokuthi “Inombolo ehlukile yemigqa engenalutho okufanele ifakwe”, khona-ke umugqa onenombolo yemigqa okufanele uyifake uzoshintsha ube inombolo ye-ordinal yekholomu lapho idatha yohlobo lwezinombolo itholakala khona. kucacisiwe.

4. Ekugcineni, umsebenzi uzonquma ngokuzimela inombolo yomugqa efana nemibandela eshiwo abasebenzisi. Izofaka imigqa eminingi engenalutho njengoba icaciswe emugqeni onikeziwe wekholomu eshiwo.

Isusa imigqa engenalutho

Kunezindlela ezimbalwa zokususa imigqa engenalutho. Ake sibheke lolu daba ngokuningiliziwe, sicabangela izibonelo ezithile. Ake sithi sinethebula elilandelayo elibonisa amamaki abafundi ezifundweni ezihlukahlukene:

Inketho yokuqala yokususa imigqa engenalutho ibonakala kanje:

1. Ukusetshenziswa kolwazi lokuhlunga kuyachazwa. Sikhetha ngokuphelele ipuleti lonke. Sithuthela engxenyeni ethi "Idatha" futhi ku-block yomyalo ethi "Hlunga futhi Hlunga", chofoza okuthi "Hlunga". Enye inketho uchofoza kwesokudla endaweni ekhethiwe bese uchofoza into "kusuka kokuncane kuye kokuningi".
2. Njengomphumela wezenzo ezithathiwe, imigqa engenalutho esiyidingayo iye yafika phansi kakhulu epuleti lokuqala. Manje sesingakwazi ukususa kalula le migqa engenalutho sisebenzisa ukhiye othi "Susa", sesiyikhethile ngaphambilini endaweni yokusebenza sisebenzisa i-LMB.

Inketho yesibili yokususa imigqa engenalutho ibonakala kanje:

1. Ukusetshenziswa kwesihlungi kuyashiwo. Senza ukukhethwa kwe "cap" yepuleti.
2. Sithuthela engxenyeni ethi "Idatha", bese sichofoza kwesokunxele ku-elementi ethi "Hlunga", etholakala kubhulokhi yamathuluzi "Hlunga futhi Hlunga".
3. Manje, kwesokudla segama lekholomu ngayinye, kuboniswa umcibisholo omncane, obheke phansi. Chofoza kuyo ukuze uvule iwindi lokuhlunga.
4. Susa ukumaka ibhokisi eliseduze kokuthi “(Akunalutho)”.

5. Ilungile! Le ndlela yenza kwaba nokwenzeka ukususa wonke amaseli angenalutho emgqeni.

Inketho yesithathu yokususa imigqa engenalutho ibonakala kanje:

1. Kusho ukusetshenziswa kokukhethwa kweqembu lamaseli. Ekuqaleni, sikhetha lonke ithebula.
2. Hambisa kunketho ethi "Ukuhlela" bese uchofoza into ethi "Thola bese ukhetha". Ohlwini oluvulayo, chofoza okuthi "Khetha iqembu lamaseli".

3. Efasiteleni elivela ngaphansi kwegama elithi “Khetha iqembu lamaseli” faka imfashini eduze nombhalo othi “amaseli angenalutho” ngenkinobho yegundane engakwesokunxele.

4. Umhleli wespredishithi usebenzise ukumaka izinkambu ezingenalutho. Kumenyu enkulu yohlelo, chofoza ipharamitha ethi “Amaseli” ngenkinobho yegundane engakwesokunxele, bese ukhetha into ethi “Susa”.

5. Ilungile! Le ndlela yenza kwaba nokwenzeka ukususa wonke amaseli angenalutho emgqeni.

Ngemva kokususwa kwemigqa, amanye amaseli azokhuphukela phezulu. Lokhu kungadala ukudideka, ikakhulukazi uma usebenzisana nenani elikhulu lolwazi. Ngakho-ke, le ndlela ayifaneleki kumatafula anenani elikhulu lemigqa namakholomu.

Isincomo! Ukusebenzisa inhlanganisela yokhiye "CTRL" + "-", okuvumela ukuthi ususe umugqa okhethiwe, kuzosheshisa kakhulu inqubo yokusebenza ngolwazi kumhleli wespredishithi se-Excel. Ungakhetha umugqa owufunayo usebenzisa inhlanganisela yokhiye oshisayo "SHIFT + SPACE".

Isiphetho

Kusukela esihlokweni, sifunde ukuthi kusihleli setafula kunezindlela eziningi ezikuvumela ukuthi ungeze umugqa omusha kudatha yetafula. Inketho engcono kakhulu ukusebenzisa ipuleti "ehlakaniphile", njengoba ikhulula abasebenzisi ebunzimeni ekusebenzeni ngokuqhubekayo ngolwazi. Kodwa-ke, umsebenzisi ngamunye uzokwazi ukuzikhethela indlela elula kakhulu ekuvumela ukuthi wengeze umugqa omusha kudokhumenti yespredishithi.