Maitiro ekuita chirevo chinoshanda muutapwa

Nzira 1: Kopa zvinongedzo kuburikidza nebrowser

Iwe haufanirwe kugadzirisa iyo link kana iwe uchitanga kuziva maitiro ekuwedzera iyo yekukunda nenzira kwayo. Kana iwe uine kugona kutevedzera iyo kero kuburikidza netambo muBrowser, zviri nani kuti uzviite, wozoenda kuInkinga yekuisa patafura.

Kuti uite izvi, unogona kushandisa chero webhu browser nekumisa kutevedzera kuburikidza nemamiriro epakati kana iyo inopisa kiyi yeCTRL + C.

Mune tafura yekunyanyisa, sarudza sero rakakodzera uye tinya Ctrl + v kuti isa rondedzero yakateedzerwa. Chinja kune chero imwe sero kuti uone kuti tambo inoratidzwa sei mubhuruu, zvinoreva kuti chinongedzo chiri kushanda.

Nzira yechipiri: Uchishandisa chishandiso chekubatanidza

Uchishandisa nzira yapfuura kunyangwe kutsiva iyo yatove yakawedzerwa mitsara - haisi nguva dzose sarudzo yakanakisa, kunyanya kana zvasvika pakugadzira zvinoshanda zvinoshanda zvinoshanda nekukurumidza. Mune ino kesi, iyo "Reference" chishandiso iripo muchirongwa ichi chiri kufungwa nezvinoonekwa seyakareruka nzira.

1. Tsvaga tambo panotambiridzwa tambo chinongedzo, uye tinya pairi kurudyi-tinya.



2. Mune mamiriro emamenyu anoonekwa, tinya pamutsetse wekupedzisira "link".



3. Mumamiriro ezvinhu azvino, iwe uchazoda kusarudza sarudzo "faira, webhu peji" mune "tie c:" block.



4. Kopa zvinyorwa zvazvino kana zvatove zvakakodzera kushandura chinongedzo, uye woisa iyo mumunda wekero uye shandisa shanduko.



5. Dzokera patafura uye uve nechokwadi chekuti zviito zvinoitwa. Ita zvakafanana neakasara masero, ayo anofanira kuitwa anoshanda.



6. Nenzira imwecheteyo uye nemasero, uko pakutanga pachinzvimbo chechinyorwa chinongedzo pane chinyorwa chenguva dzose. Isa zita resaiti mu "Kero" Line kuti uende uye shandisa zvigadziriso zvitsva.

Nzira 3: Kugadzira macro kuti ikurumidze kumisikidza zvinongedzo

Mushandisi macro anogadzirisa zvese zvinongedzo mune imwe koramu inobatsira kune vashandisi vakasangana nebasa rekugadzirisa boka renzvimbo iyo iwe yausingakwanise kuenda naro kubva patafura. Mune ino kesi, zvishandiso zvemugadziri zvichadikanwa, saka zvakavamisa pamberi seinotevera:

1. Mushure mekuvhura tafura, enda kune yekutanga faira "faira".



2. Kuruboshwe kuruboshwe, sarudza iyo "parameter" chikamu.



3. Vhura iyo "yekugadzirisa tepi" menyu.



4. Maka iyo "yekuvandudza" tab ine mucherechedzo kuti uwedzere ku tepi.

Vhara mawindo ezvirongwa uye uenderere kune kusikwa kweMacro, yatichataura nezvaro mumirairo pazasi.

1. Zvekugadzira macros muExcel, manyoro akapatsanurwa anoenderana nekutanga kwekuti kunoenda kune iyo yekuvandudza tab.



2. Kubva ipapo, mhanya "kugona kwekuona".



3. DZVANYA-DZVANYA PAMUSORO PAKUTI STAJNIG Row, iyo inovhura macro zvakasikwa hwindo.



4. Isa zvinotevera zvirimo uye chitsiva iyo "C2" uye "c" mumutsara wakasarudzwa pane iyo skrini pane mavara uye kutanga kweiyo column, uko ma links akarongwa kuti aite kuti activation.

   Sub hypersylka ()

   DIM CLES SEZVANYORWA, RA SEZVIMWE: Shanduro.ScreenUpdating = Nhema

   Set Ra = Range ([C2], Range ("C" & Row.count) .Eend (XLUP))

   Yechitokisi chega chega mu ra.secll

   Kana len (sero) saka sel.Hyperlink.Add Cell, Sero

   Inotevera cell.

   Kupera sub.

   Sub hyperssylkase ()

   DIM CLES ISANGANO: DZESVONDO.SCPENPUTTatating = Nhema

   Yechitokisi chega chega mukusarudzwa

   Kana len (sero) saka sel.Hyperlink.Add Cell, Sero

   Inotevera cell.

   Kupera sub.



5. Iyo inoramba ichingotya "Chengetedza" kana shandisa iyo CTRL + kiyi inopisa, wobva wavhara macro chisikwa chishandiso.



6. Iye zvino zvigadziriso zvichiri kushandiswa, saka vhura iyo "macros" hwindo.



7. Mariri, activate macro akagadzirwa nesu pasi pezita "hypersylka".



8. Dzokera patafura uye uve nechokwadi chekuti ikozvino zvese zvinongedzo zvinoratidzwa nemazvo.