Ungayakha kanjani inkinobho ku-Excel

I-Excel iyiprosesa eliyinkimbinkimbi yetafula, ngaphambi kwalokho abasebenzisi babeka imisebenzi eminingi ehlukahlukene. Omunye umsebenzi onjalo ukwakha inkinobho eshidini, ucindezela okuzoba nenqubo ethile. Le nkinga ixazululwa kusetshenziswa i-Excel Toolkit. Masibhekane naziphi izindlela ongazakha into efanayo kulolu hlelo.

Inqubo yokudala

Njengomthetho, le nkinobho yenzelwe ukusebenza njengesethenjwa, ithuluzi lokuqalisa inqubo, iMacro, njll. Yize kwezinye izimo, le nto ingaba nje isibalo sejometri, futhi ngaphezu kwezinhloso zokubuka, akukho ukusetshenziswa okungathathiwe. Le nketho, noma kunjalo, ayivamile.

Indlela 1: iphazili ye-auto

Okokuqala, cabanga ukuthi ungayakha kanjani inkinobho kusuka kubunjwa obushumekiwe obushumekiwe.

1. Senza ukufudukela kuthebhu ethi "Faka". Chofoza isithonjana se- "Fili", esitholakala etheyipini ebhuthini "yomfanekiso". Kuboniswa uhlu lwazo zonke izinhlobo zezibalo. Khetha isibalo ocabanga ukuthi silungele iqhaza lenkinobho. Isibonelo, lesi sibalo esinjalo singaba yinxande ngamakhona abushelelezi.



2. Ngemuva kokucindezela, siyithumele endaweni yeshidi (iseli), lapho sifisa ukuba yinkinobho, bese uhambisa imingcele ejulile entweni ukuze sithathe usayizi esiwudingayo.



3. Manje kufanele wengeze isenzo esithile. Makube ukuguqukela kwelinye ishidi lapho uchofoza inkinobho. Ukuze wenze lokhu, chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe, esebenza ngemuva kwalokhu, khetha isikhundla "Hyperlink".



4. Efasiteleni lokuqala le-hyperlink, iya "endaweni edokhumenti" ithebhu. Khetha ishidi esilibheka njengelidingekile, bese uqhafaza inkinobho ethi "Kulungile".

Manje, uma uchofoza entweni eyenziwe yithi, into izohanjiswa ekhasini elikhethiwe ledokhumenti.

Isifundo: Ungayenza kanjani noma ususe ama-hyperlinks ku-Excel

Indlela 2: Side Image

Njengenkinobho, ungasebenzisa futhi iphethini yomuntu wesithathu.

1. Sithola isithombe esivela eceleni, ngokwesibonelo, kwi-Intanethi, bese siyilanda kwikhompyutha yakho.
2. Vula idokhumenti ye-Excel lapho sifisa ukuhlela khona into. Iya kuthebhu ethi "Insert" bese uqhafaza isithonjana se- "SAMU", esitholakala etheyipini ebhuthini "yomfanekiso".



3. Kuvulwa iwindi lokukhetha isithombe. Iya ukuyisebenzisa kulolo mkhombandlela we-hard disk, lapho isithombe sikhona, esenzelwe ukwenza indima yenkinobho. Yaza igama laso bese uchofoza inkinobho ethi "Namathisela" ezansi kwewindi.



4. Ngemuva kwalokho, isithombe sengezwe endizeni yeshidi elisebenzayo. Njengasesimweni esedlule, kungacindezelwa, kuhudule imingcele. Hambisa umdwebo endaweni lapho sifisa ukubekwa khona.



5. Emva kwalokho, i-hyperlink ingaboshelwa kwi-coppe, ngendlela efanayo nayo yaboniswa ngendlela edlule, futhi ungangeza i-macro. Endabeni yokugcina, ngokuchofoza inkinobho yegundane efanelekile emdwebeni. Kumenyu yomongo evelayo, khetha i- "Abport Macro ..." Into.



6. Iwindi lokulawula iMacro livula. Kudinga ukugqamisa ukuthi ama-macro ofuna ukufaka isicelo lapho inkinobho icindezelwa. Le macro kufanele irekhodiwe encwadini. Kuyadingeka ukugqamisa igama layo bese uqhafaza inkinobho ethi "KULUNGILE".

Manje ukucindezela into kuzokwethulwa ama-macro akhethiwe.

Isifundo: Ungawakha kanjani i-macro ku-Excel

Indlela 3: Into esebenzayo

Inkinobho esebenzayo kakhulu izokwakhiwa emcimbini wokuthi iyinto esebenzayo yesisekelo sayo sokuqala. Ake sibheke ukuthi kwenziwa kanjani lokhu.

1. Ukuze ukwazi ukusebenza ngezinto ezisebenzayo, okokuqala, udinga ukwenza kusebenze ithebhu yonjiniyela. Iqiniso ngukuthi ngokuzenzakalela kukhutshaziwe. Ngakho-ke, uma ungakakavumi, khona-ke iya kuthebhu ethi "Ifayela", bese udlulela engxenyeni ethi "Parameters".



2. Ewindini lephasamende elicushiwe, sithuthela esigabeni "se-Ribbon Setup". Ngakwesokunene sewindows, sibeka umkhaza eduze kwento "yonjiniyela" uma ilahlekile. Okulandelayo, chofoza inkinobho ethi "Kulungile" ezansi kwewindi. Manje ithebhu yonjiniyela izokwenziwa isebenze kunguqulo yakho ye-Excel.



3. Ngemuva kwalokho, sithuthela kuthebhu kanjiniyela. Chofoza inkinobho ethi "Insert", etholakala ethepheni ku- "Controls" yamathuluzi. Eqenjini lezinto ezisebenzayo, chofoza into yokuqala uqobo, enokubukeka kwenkinobho.



4. Ngemuva kwalokho, chofoza kunoma iyiphi indawo ephepheni esikubheka njengelidingekayo. Masinyane ngemuva kwalokhu, into izovela lapho. Njengasezindleleni ezedlule, lungisa indawo yayo nosayizi.



5. Chofoza kwi-Element Emenyezelwe Qhafaza inkinobho yegundane ephindwe kabili.



6. Isihleli se-macro siyavulwa. Ungarekhoda noma iyiphi i-macro ofuna ukuyenziwa lapho uchofoza kule nto. Isibonelo, ungarekhoda ukuguqulwa kombhalo okwenzelwe imibhalo ngefomethi yezinombolo, njengasesithombeni esingezansi. Ngemuva kokuthi ama-macro aqoshwa, chofoza inkinobho yokuvala ekhoneni layo eliphezulu kwesokudla.

Manje iMacro izoboshelwa entweni.

Indlela 4: Ifomu Lokulawula Amafomu

Indlela elandelayo ifana kakhulu nobuchwepheshe bokubulawa kwenguqulo yangaphambilini. Inkinobho ukwengeza inkinobho ngento yokulawula ifomu. Ukuze usebenzise le ndlela, imodi kanjiniyela nayo iyadingeka.

1. Iya kuthebhu ethi "Unjiniyela" bese uqhafaza inkinobho ethi "Faka", ebekwe etheyipini eqenjini le- "Controls". Uhlu luyavula. Idinga ukukhetha into yokuqala etholakala eqenjini le- "Fomu Management Elements". Le nto ebukeka ngokubonakalayo efana nento efanayo nento efanayo ye-activex, saxoxa ngenhla ngenhla.



2. Into ivela ephepheni. Lungisa usayizi wayo nendawo, njengoba bekwenzile kaningi phambili.



3. Emva kwalokho, sinikezela nge-macro entweni edaliwe, njengoba kukhonjisiwe ngendlela 2 noma yabela i-hyperlink njengoba kuchaziwe ngendlela 1.

Njengoba ukwazi ukubona, ku-evelle, dala inkinobho yokusebenza akunzima njengoba kungabonakala njengomsebenzisi ongenalwazi. Ngaphezu kwalokho, le nqubo ingenziwa kusetshenziswa izindlela ezine ezihlukile ngokubona kwayo.