Maitiro ekuisa bhokisi rekutarisa muExcel spreadsheet

MuMicrosoft Office Excel, unogona kuisa bhokisi rekutarisa mune chero sero yetafura. Ichi chiratidzo chakananga muchimiro checheki chiratidzo, chakagadzirirwa kushongedza chero chikamu chezvinyorwa, kuratidza zvakakosha zvinhu, uye kutanga zvinyorwa. Ichi chinyorwa chichakurukura nzira dzekuseta chiratidzo muExcel uchishandisa maturusi akavakirwa muchirongwa.

Nzira yekutarisa bhokisi

Kutarisa bhokisi muExcel zviri nyore zvakakwana. Neiyi icon, kuoneka uye aesthetics yegwaro inowedzera. Zvimwe pamusoro pazvo zvichakurukurwa gare gare.

Method 1: Shandisa Standard Microsoft Excel Symbols

Excel, seShoko, ine raibhurari yayo yezviratidzo zvakasiyana-siyana zvinogona kuiswa chero papepa rekushanda. Kuti uwane chekimark icon uye woiisa muchitokisi, unofanirwa kutevedzera aya matanho:

• Sarudza sero paunoda kuisa bhokisi rekutarisa.
• Enda kuchikamu che "Insert" kumusoro kwemenyu huru.
• Dzvanya pabhatani re "Symbols" pakupera kwerondedzero yezvishandiso.
• Muhwindo rinovhurwa, tinya pane "Symbol" sarudzo zvakare. Menyu yemifananidzo yakavakirwa-mukati ichavhura.

• Mundima ye "Set", tsanangura sarudzo "Matsamba ekuchinja nzvimbo", tsvaga cheki mucherechedzo weparamendi yakaunzwa, sarudza neLMB uye tinya pashoko rekuti "Isa" pazasi pehwindo.

• Ita shuwa kuti cheki bhokisi rakaiswa musero chairo.

Teerera! Kune akati wandei marudzi emabhokisi echeki mukatalogi yezviratidzo. Iyo icon inosarudzwa pakufunga kwemushandisi.

Nzira 2. Kutsiva mavara

Matanho ari pamusoro ndeokusarudza. Chiratidzo chebhokisi chebhokisi chinogona kuiswa nemaoko kubva kukhibhodi yekombuta nekuchinja marongero ayo kuenda kuChirungu modhi uye nekudzvanya bhatani re "V".

Nzira 3. Kutarisa bhokisi kuti uite bhokisi rekuongorora

Nekutarisa kana kusatarisisa bhokisi rekutarisa muExcel, unogona kumhanyisa zvinyorwa zvakasiyana. Kutanga iwe unofanirwa kuisa cheki bhokisi pane yebasa nekuita iyo yekuvandudza modhi. Kuisa chinhu ichi, unofanirwa kuita zvinotevera manipulations:

• Dzvanya paizwi rekuti "Faira" mukona yepamusoro kuruboshwe rwechidzitiro.
• Enda kune "Settings" chikamu.

• Muhwindo rinotevera, sarudza chikamu che "Ribbon Customization" kuruboshwe rwechidzitiro.
• Muchikamu che "Main tabs" mune runyorwa, tsvaga mutsara wekuti "Developer" uye tarisa bhokisi riri padivi peiyi sarudzo, wobva wadzvanya pakanzi "OK" kuvhara hwindo.

• Iye zvino, mune rondedzero yezvishandiso pamusoro peiyo huru menyu yechirongwa, iyo "Developer" tab ichaonekwa. Unofanira kupinda mariri.
• Muchivharo chekushanda chechombo, tinya bhatani rekuti “Isa” uye mune “Controls” column yefomu, tinya pane bhokisi rekutarisa.

• Mushure mekupedza nhanho dzakapfuura, pachinzvimbo cheyakajairwa mbeva cursor, chiratidzo muchimiro chemuchinjikwa chicharatidzwa. Panguva ino, mushandisi anofanirwa kudzvanya LMB panzvimbo ichaiswa fomu.
• Ita shuwa kuti isina sikweya inooneka muchitokisi mushure mekudzvanya.
• Dzvanya LMB pachikwere ichi, uye mureza uchaiswa mairi.

• Pedyo nebhokisi rekutarisa muchitokisi pachava nekunyorwa kwakajairika. Iwe unozofanirwa kuisarudza uye wodzvanya "Delete" kiyi kubva pane keyboard kuti uibvise.

Zvinokosha! Chinyorwa chakajairwa chiri padivi pechiratidzo chakaiswa chinogona kutsiviwa nechero chimwe pakufunga kwemushandisi.

Nzira 4. Magadzirirwo ebhokisi rekutarisa rekushandisa zvinyorwa

Bhokisi rekutarisa rakaiswa musero rinogona kushandiswa kuita chiito. Avo. pane pepa rebasa, mutafura, shanduko dzichaitwa mushure mekutarisa kana kusabvisa bhokisi. Kuti izvi zvikwanisike, unofanira:

• Tevedza matanho ari muchikamu chapfuura kuti umaka chiratidzo muchitokisi.
• Dzvanya LMB pane chinhu chakaiswa uye enda ku "Format Object" menyu.

• Mu "Control" tab mu "Value" column, isa chinja chekushandura chakatarisana nemutsara unoratidza mamiriro azvino ebhokisi rekutarisa. Avo. ingave mu "Installed" munda kana mu "Removed" mutsara.
• Dzvanya bhatani reLinganiso kuSero pazasi pehwindo.

• Tsanangura sero umo mushandisi anoronga kumhanyisa zvinyorwa nekuchinja bhokisi rekutarisa uye nekudzvanya iyo icon zvakare.

• Pane iyo Format Object menyu, tinya OK kuti uise shanduko dzako.

• Iye zvino, mushure mekutarisa bhokisi, shoko rokuti "CHOKWADI" richanyorwa muchitokisi chakasarudzwa, uye mushure mokubvisa kukosha "FALSE".

• Chero chiito chinogona kusungirirwa kune iyi sero, semuenzaniso, kushandura ruvara.

Mamwe Mashoko! Kusunga kwemavara kunoitwa mu "Format Cells" menyu mu "Zadza" tab.

Nzira 5. Kuisa bhokisi rekuongorora uchishandisa ActiveX zvishandiso

Iyi nzira inogona kuitwa mushure mekuita dhizaini modhi. Kazhinji, basa rekuita algorithm rinogona kuderedzwa sezvinotevera:

• Activate developer mode sezvatsanangurwa pamusoro. Mirayiridzo ine udzame yakapiwa paifungwa nezvenzira yechitatu yokuisa nayo mureza. Hazvina maturo kudzokorora.
• Tinya-kurudyi pane sero ine sikweya isina chinhu uye yakajairwa chinyorwa chinozoonekwa mushure mekupinda mu "Developer" modhi.
• Sarudza "Properties" kubva pane zviri mukati menyu.

• Iwindo idzva richazaruka, mune runyorwa rwema parameter ayo aunoda kuwana mutsara we "Value" uye nemaoko isa izwi rekuti "Chokwadi" pachinzvimbo che "Nhema".

• Vhara hwindo uye tarisa mhedzisiro. Chiratidzo chinofanira kuoneka mubhokisi.

mhedziso

Saka, muExcel, bhokisi rekutarisa rinogona kusetwa nenzira dzakasiyana. Sarudzo yekuisa nzira inoenderana nezvinangwa zvinotevedzwa nemushandisi. Kuti ungonyora ichi kana icho chinhu chiri muhwendefa, zvakakwana kushandisa nzira yekutsiva chiratidzo.