Maitiro ekugadzira bhatani muExcel

Excel is a akaomarara tafura processor, iyo vashandisi vakaisa akasiyana siyana mabasa. Rimwe basa rakadai rekugadzira bhatani pane pepa, kudzvanya uko kwaizomhanya imwe nzira. Dambudziko iri rakanyatsogadziriswa uchishandisa iyo Excel Tilkit. Ngativei nzira dzipi dzaunogona kugadzira chinhu chakafanana muchirongwa ichi.

Maitiro ekugadzira

Semutemo, bhatani iri rakagadzirirwa kuita senge revo, chishandiso chekutanga maitiro, macro, nezvimwe. Kunyangwe mune dzimwe nguva, chinhu ichi chinogona kungova chejometri mumburu, uye kuwedzera kune zvinangwa zvinoonekwa, hapana kushandiswa hakuna kutorwa. Iyi sarudzo, zvisinei, isingawanzo.

Nzira 1: Auto Puzzle

Chekutanga pane zvese, funga kuti ungagadzira bhatani kubva kumhando dzakanyadziswa.

1. Isu tinoita kuenda ku "kuisa" tab. Dzvanya pane "manhamba" icon, iyo iri patepi mu "mufananidzo" chishandiso block. Rondedzero yemhando dzese dzehuwandu hunoratidzwa. Sarudza mufananidzo waunofunga kuti wakakodzera basa rebhatani. Semuenzaniso, nhamba yakadaro inogona kunge iri rectangle ine yakashongedzwa makona.



2. Mushure mekumanikidza, tinoifambisa kunzvimbo yepepa (sero), kwatinoshuvira kuve bhatani, uye fambisa miganhu yakadzika muchinhu chekutora saizi yatinoda.



3. Iye zvino iwe unofanirwa kuwedzera chiito chaicho. Ngazvive shanduko kune imwe sheet kana iwe ukadzvanya pane bhatani. Kuita izvi, tinya pairi kurudyi mbeva bhatani. Mukati menyu, iyo inosimbiswa mushure meizvi, sarudza chinzvimbo "hyperlink".



4. Muhwindo rekuvhura reiyo hyperlink, enda ku "nzvimbo mugwaro" tab. Sarudza pepa ratinozviona sezvakakosha, uye tinya pane "OK" bhatani.

Zvino, paunotya pane chimwe chinhu chakagadzirwa nesu, chinhu chichaendeswa kune yakasarudzwa pepa regwaro.

Chidzidzo: Maitiro ekugadzira kana kubvisa hyperlinks muExcel

Nzira 2: chikamu chechiso

Sebhatani, iwe unogona zvakare kushandisa yechitatu-bato maitiro.

1. Isu tinowana mufananidzo wechitatu-webato, semuenzaniso, paInternet, uye uirodha pakombuta yako.
2. Vhura gwaro reExcel umo ratinoshuvira kuronga chinhu. Enda kune "Insert" tab uye tinya pane iyo "nhamba" icon, iyo iri patepi mu "mufananidzo" block block.



3. Iyo yemifananidzo yekusarudza yemifananidzo inovhura. Enda kuishandisa mune iyo dhairekitori yeiyo hard disk, uko iyo pikicha inowanikwa, iyo yakagadzirirwa kuita basa rebhatani. Govera zita rayo uye tinya pane "paste" bhatani pazasi pewindo.



4. Mushure meizvozvo, mufananidzo unowedzerwa kune ndege yepepa rekushanda. Sezvazviri zvakapfuura, zvinogona kumanikidzwa, zvichikwevera miganhu. Fambisa dhirowa kunzvimbo iyo yatinoshuvira kuiswa chinhu.



5. Mushure meizvozvo, iyo hyperlink inogona kusungirirwa kune iyo Coppe, nenzira imwecheteyo sezvakaratidzwa munzira yapfuura, uye iwe unogona kuwedzera macro. Muchiitiko chekupedzisira, nekudzvanya bhatani rekurudyi mbeva pane iyo dhizaini. Mukati menyu inotaurwa inoonekwa, sarudza "kupa macro ..." chinhu.



6. Iyo Macro Kudzora Window inovhura. Inoda kuratidza kuti macro iyo iwe yaunoda kushandisa kana bhatani rikamanikidzwa. Iyi macro inofanira kunge yatove yakanyorwa mubhuku. Izvo zvinodikanwa kuratidza zita raro uye tinya pane "OK" bhatani.

Iye zvino kudzvanya chinhu kuchamiswa macro akasarudzwa.

Chidzidzo: Maitiro ekugadzira macro muExcel

Nzira 3: ActiveX Element

Iyo inonyanya kushanda bhatani ichagadzirwa muchiitiko chekuti ichi chinoshanda chechiitiko cheiyo yekutanga-base. Ngatione kuti izvi zvinoitwa sei mukuita.

1. Kuti ugone kushanda neanoshanda zvinhu, kutanga pane zvese, iwe unofanirwa kumisa iyo yekuvandudza tab. Icho chokwadi ndechekuti nekukanganisa zvakaremara. Naizvozvo, kana iwe usati wasatendeuka, wobva waenda ku "Faira" tab, wobva watamira kune "parameter" chikamu.



2. Mune iyo yakagadziriswa parameter hwindo, isu tinoenda ku "ribbon setup" chikamu. Rutivi rworudyi rwehwindo, tinoisa tick padhuze ne "Weruvuri" chinhu kana chisipo. Tevere, tinya pane "OK" bhatani pazasi pewindo. Iye zvino iyo yekuvandudza tab ichaverengerwa mune yako excel vhezheni.



3. Mushure meizvozvo, isu tinoenda kune iyo yekuvandudza tab. Dzvanya pane "Insert" bhatani, iri patepi mune "inodzora" Toolbar. Muchiitiko chinoshanda chezvinhu, tinya pane yekutanga chinhu pachayo, iyo ine bhatani kutarisa.



4. Mushure meizvozvo, tinya pane chero nzvimbo pane pepa ratinozviona sezvakakosha. Pakarepo mushure meizvi, chinhu chichaonekwa ipapo. Sezvazviri nzira dzakapfuura, ruramisa nzvimbo yayo uye saizi.



5. Dzvanya pane iyo yakakonzeresa zvinhu kaviri tinya kuruboshwe mbeva bhatani.



6. Macro mupepeti anovhura. Iwe unogona kunyora chero macro iwe unoda kuurayiwa kana iwe ukadzvanya pane ichi chinhu. Semuenzaniso, iwe unogona kunyora chinyorwa chezvinyorwa zvemavara macro mumhando yehuwandu, senge mumufananidzo uri pazasi. Mushure mekunge macro yakanyorwa, tinya pane bhatani rekuvhara mukona kwayo kurudyi kona.

Zvino macro achasungirirwa nechinhu.

Nzira 4: Fomu Kutonga Zvinhu

Nzira inotevera yakafanana neyekuurayiniki tekinoroji pane yadarika vhezheni. Icho bhatani kuti uwedzere bhatani kuburikidza fomu yekudzora fomu. Kuti ushandise nzira iyi, iyo nzira yekuvandudza inodiwawo.

1. Enda kune "kuvandudza" tab uye tinya pane imwe nzvimbo yekuziva "isa", yakaiswa patepi mune "anotonga" boka. Rondedzero yacho inovhura. Inoda kusarudza chinhu chekutanga icho chiri mu "fomu manejimendi zvinhu" boka. Ichi chinhu chinooneka chinotaridzika zvakafanana neicho chinhu chakafanana cheiyo Activex, takataura nezvake pamusoro apa.



2. Chinhu chinoonekwa papepa. Gadzirisa saizi yayo nenzvimbo, sezvo ivo vakaramba vachiita kare.



3. Mushure meizvozvo, tinopa macro kuchinhu chakasikwa, sezvakaratidzwa nenzira yechipiri kana kupa hyperlink sezvakatsanangurwa munzira 1.

Sezvauri kuona, muExle, Gadzira bhatani rekuita harina kuoma sezvingaite senge mushandisi asina ruzivo. Uye zvakare, maitiro aya anogona kuitwa uchishandisa nzira ina dzakasiyana pakufunga kwayo.