I-Excel yinkqubo yetafile entsonkothileyo, ngaphambi kokuba abasebenzisi babeka imisebenzi eyahlukeneyo. Omnye olo msebenzi ukwenzela iqhosha kwiphepha, ukucinezela eliza kuqhuba inkqubo ethile. Le ngxaki iconjululwe ukusebenzisa isixhobo se-Ecell. Masijongane neziphi iindlela onokuthi ulwenze ngayo into efanayo kule nkqubo.
Inkqubo yokwenzela
Njengommiselo, eli qhosha lenzelwe ukuba lisebenze njengesalathiso, isixhobo sokuqalisa inkqubo, i-macro, njl. Nangona kwezinye iimeko, le nto inokuba yinxalenye nje yejometri, kwaye ukongeza kwiinjongo ezibonakalayo, akukho ukusetyenziswa akuthathwanga. Olu khetho, nangona kunjalo, lunqabile.Indlela yoku-1: ipuzzle ngokuzenzekelayo
Okokuqala, qwalasela indlela yokwenza iqhosha kwiimilo ezifakelweyo ze-Express.
- Senza ukufudukela kwithebhu "yokufaka". Cofa "amanani" i-icon, ekhoyo kwiteyiphu kwibhloko "yomzekeliso". Uluhlu lwazo zonke iintlobo zamanani luyatyhilwa. Khetha umzobo ocinga ukuba ulungele indima yeqhosha. Umzekelo, inani elinjalo linokuba lixande elinamachaphaza acocekileyo.
- Emva kokucinezela, siyayisusa kwindawo yeshiti (iseli), apho sinqwenela ukuba yiqhosha, kwaye sishukume imida ingene kwinto esiyifunayo.
- Ngoku kufuneka wongeze inyathelo elithile. Yiyeke inguqu ukuya kwelinye iphepha xa ucofa kwiqhosha. Ukwenza oku, cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yokujonga umxholo, evuliwe emva koku, khetha indawo "hyperlink".
- Kwifestile yokuvula ye-hyperlink, yiya kwindawo "kwi-ncwadi" ithebhu. Khetha iphepha esiyijonga njengeyimfuneko, kwaye ucofe iqhosha u "Kulungile".
Ngoku, xa ucofa kwinto edaliweyo, into iya kuhanjiswa kwiphepha elikhethiweyo loxwebhu.
Isifundo: Ungayenza njani okanye ususe ii-hyperlinks kwi-Excel
Indlela 2: umfanekiso ongezantsi
Njengeqhosha, unokusebenzisa ipatheni yeqela lesithathu.
- Sifumana umfanekiso womntu wesithathu, umzekelo, kwi-Intanethi, kwaye uyikhuphe kwikhompyuter yakho.
- Vula uxwebhu lwe-Excel apho sinqwenela ukulungiselela ukwenza into. Yiya kwi "Faka" ithebhu kwaye ucofe "umfanekiso" umfanekiso ", obekwe kwitheyiphu yesixhobo" somzekeliso ".
- Ifestile yokukhetha umfanekiso iyavula. Yiya kuyisebenzisa kolo mbambano we-hard disk, apho umfanekiso ubekwe khona, oyilelwe ukwenza indima yeqhosha. Yabela igama layo kwaye ucofe iqhosha "paste" ezantsi kwefestile.
- Emva koko, umfanekiso wongezwa kwindiza yephepha lokusebenza. Njengakwimeko yangaphambili, inokucinezelwa, ukutsala imida. Hambisa umzobo kwindawo apho sinqwenela ukubekwa into.
- Emva koko, i-hyperlink inokubotshwa kwi-coppe, ngendlela efanayo njengoko iboniswe kwindlela yangaphambili, kwaye ungongeza iMacro. Kwimeko yokugqibela, ngokucofa iqhosha lemouse ekunene kumzobo. Kwimenyu yokujonga, khetha i "Yandisa i-macro ..." into.
- Iwindows yolawulo lwe-macro ivula. Kufuneka ibalaselisa ukuba i-macro ofuna ukufaka isicelo xa icinezelwe iqhosha. Le macro kufuneka irekhodwe encwadini. Kuyimfuneko ukuqaqambisa igama lakhe kwaye ucofe iqhosha u "Kulungile".
Ngoku cinezela into eya kuqaliswa i-macro ekhethiweyo.
Isifundo: Ukwenza njani i-macro kwi-Excel
Indlela 3: I-ActiveX
Iqhosha elisebenzayo liza kudalwa kwimeko yokuba yinto esebenzayo yesiseko sayo sokuqala. Makhe sibone ukuba kwenzeka njani oku.
- Ukuze ukwazi ukusebenza ngezinto ezisebenzayo, okokuqala, kufuneka wenze isebenze ithebhu yomphunga. Inyani yile yokuba ngokusilela kukhubazekile. Ke ngoko, ukuba okwangoku awukayijika, emva koko uye kwi "Ifayile" yethebhu, emva koko uye kwicandelo "leparamitha".
- Kwiparamitha evulekileyo yefestile, sifudukela kwi-"rbbon setup ". Kwicala lasekunene lefestile, sibeka i-tick kufutshane ne "Musile" ukuba ilahlekile. Okulandelayo, cofa kwiqhosha "Kulungile" emazantsi efestile. Ngoku i-Tabper PAB iya kuvulwa kwinguqulelo yakho ye-Excel.
- Emva koko, sifudukela kwithebhu yomphunga. Cofa kwindawo ethi "Faka", ibekwe kwitheyipu kwi "Lawula" i-Toolbar yesixhobo. Kwiqela lezinto ezisebenzayo, cofa kwinqaku lokuqala ngokwalo, elineqhosha leqhosha.
- Emva koko, cofa kuyo nayiphi na indawo kwiphepha esizijonga njengeyimfuneko. Ngokukhawuleza emva koku, kuya kubonakala ngathi kukho. Njengakwindlela yangaphambili, lungisa indawo kunye nobukhulu.
- Cofa kwindawo ekhokelela kabini Cofa iqhosha lemouse lasekhohlo.
- Umhleli weMacro uyavula. Ungarekhoda nayiphi na iMacro ofuna ukuba yenziwe xa ucofa kule nto. Umzekelo, unokurekhoda isicatshulwa sokuguqula isicatshulwa se-macro kwifomathi yenombolo, njengangomfanekiso ungezantsi. Emva kokuba i-macro irekhodiwe, cofa kwiqhosha lokuvala kwikona yalo ephezulu ngasekunene.
Ngoku i-macro iya kubotshwa kwinto.
Indlela 4: IFOMU YOLAWULO
Le ndlela ilandelayo ifana kakhulu netekhnoloji yokuphumeza kwinguqulelo yangaphambili. Liqhosha ukongeza iqhosha ngolawulo lwefom yefom. Ukusebenzisa le ndlela, indlela yovelwano iyafuneka.
- Yiya kwindawo "yomphuhlisi" kwaye ucofe iqhosha eliqhelekileyo "faka", ibekwe kwitheyiphu kwiqela "lolawulo". Uluhlu luyavula. Kuya kufuneka ukhethe into yokuqala efumaneka kwi "PATOOLSERSEROOOOOOLLSOOOOLT izinto zolawulo. Le nto ibonakala ifana ngqo nento efanayo ye-ActiveX, sincokole ngokuthile ngaphezulu.
- Into ivela ephepheni. Lungisa ubungakanani bayo kunye nendawo, njengoko beyenzile ngaphambili.
- Emva koko, sinika i-macro kwinto edaliweyo, njengoko kubonisiwe kwiNdlela 2 okanye yabela i-hyperlink njengoko kuchaziwe kule ndlela 1.
Njengoko ubona, egqogqe, yenza iqhosha lomsebenzi alibikho kangako njengoko kunokubonakala ngathi ngumsebenzisi ongenamava. Ukongeza, le nkqubo inokwenziwa kusetyenziswa iindlela ezine ezahlukeneyo ngokokubona kwayo.