Maitiro ekusimbisa miganhu yetafura muExcel

Kusarudzwa kwemiganhu muMicrosoft Excel ndeimwe yenzira dzekusanangurwa kwayo, zvisinei, mune ino chirongwa kune dzimwe nzira dzinobvumidza iwe kuti ugadzire "tafura" kana inoshanda. Kana usati waita izvi uye unofarira musoro wenyaya, uve nechokwadi chekuverenga iyo Referenti pazasi kana kuenda kune dzinotevera nzira dzekudzidza maitiro ekusarudza tafura yemiganhu.

Verenga zvimwe: kugadzira tafura muMicrosoft Excel

Nzira 1: Uchishandisa Standard Vabati

Excel ine yakajairika mavara ayo anowanzokodzera kune vanogara vashandisi kuratidza miganhu yetafura. Ivo vanoratidza kugoverwa kwakasiyana kwemitsetse uye shanduko, saka ivo vanozobatsira mune zvakananga nyaya. Kuti uwedzere miganhu yakadaro, iwe uchafanirwa kuita maviri ekudzvanya.

1. Neiyo bhatani rekuruboshwe bhatani, simbisa zvinhu zvese zvakabatanidzwa patafura kuti shanduko dzishande kwavari vese.



2. Wedzera iyo "muganho" menyu, iyo iri pamba tab, uye sarudza imwe yeiyo sarudzo dzakagadzirira-dzakagadzirirwa. Mune menyu imwe chete, iwe unogona kubva pakarepo kuona shanduko dzakaitwa patafura kuburikidza neiyo thumbnail kuruboshwe.



3. Mushure mekushandisa miganhu, dzokera patafura uye kukoshesa kutaridzika kwayo. Kana zvakakodzera iwe, unogona kusiira zvese sezvazviri, zvimwe uende kune mamwe marongero.



4. Semuenzaniso, hapana chichakanganisa kuvhurwa kwemenu imwe chete uye shandura ruvara rwemutsara uchishandisa yakajairika mavara, manhamba mavara kana tsika yemumvuri.



5. Izvi zvakafanana zvinoshanda kune mhando yemitsetse, zvisinei, iyo seti inogumira kune ingangoita mashoma akasiyana ezvisarudzo uye zvakatemwa sarudzo.



6. Kana iyo ruvara uye mhando yemitsetse ichisarudzwa mushure mekusikwa kwemiganhu, mumwe nemumwe wavo anozodiwa zvakasiyana, kudzvanya bhatani rekuruboshwe rekushandiswa rinoshanda.



7. Munguva iyi, mitsara inokanganisa inogona kuratidzika nekuda kwemamendi asina kunaka.



8. Wobva waabvisa kuburikidza neiyo imwechete yekudonha-pasi menyu uchishandisa chishandiso ku "Bvisa muganho".

Kana iwe usingakwanisi kusarudzika sarudzo dzekare kana kudikanwa kwekusarudzika kwekusarudzika kwemiganhu ye tafura yakamuka, shandisa iyo inotevera yekuona sarudzo sarudzo.

Nzira 2: Manual Border Kudhirowa

Manual dhizaini yemuganhu petafura muExcel ichagadzira imwe dhizaini yemutsara wega wega sezvazvinodiwa kune mushandisi pachawo. Kuti uite izvi, shandisa iyo imwechete yekudonha-pasi menyu, asi ita zvimwe zviito.

1. Vhura runyorwa "miganhu" maunosarudza iyo "dhirowa" mudziyo.



2. Kana iyo mutsara rudzi uye ruvara rwayo rwunosiyana neyekutendeuka, ipapo uchivachinja kuti vagadzire dhizaini chaiyo kana vachidira.



3. Kutanga kubhuroka miganhu, kudzvanya paminda inodiwa kana kushandisa ivo, pakarepo kugadzira kuona kwemunda wega wega.

Nzira 3: Kushandisa iyo "imwe Border" mudziyo

Chishandiso chinonzi "dzimwe miganhu" zvichakubvumidza kuti ugadzire mitsara isiri chikamu cheTemplates, semuenzaniso, kana iwe uchida kuyambuka sero kana kuwedzera dhizaini.

1. Mune ino kesi, vhura zvese "muganho" kuderera-pasi menyu, asi sarudza iyo yekupedzisira "mimwe miganhu" zvishandiso.



2. Kutanga kugadzira mitsara muwindo rakanyatsogoverwa izvi. Iyo inomiririrwa sechitokisi chakakurisa neye template zvinyorwa, uye kudzvanya muunganidzwa kunogona kuwana nekukurumidza kana kubvisa mutsara.



3. Mune ino tab, iwe unogona kubva pakarepo shandura mhando yemuganhu uye ruvara rwayo, kuverenga mhedzisiro yacho muTreeview hwindo.



4. Enda kune "zadza" tab, kana iwe uchida kuchinja ruvara rwemberi rwechitusha chega chega chikamu chetafura.



5. Mune inotevera skrini, iwe unoona iyo sarudzo yekuti isiri-yakajairika kuwedzera miganhu, semuenzaniso, kugadzira mhedzisiro yesero rakayambuka nemutsara wakabhadharwa kana kuenderera mberi mutsara.

Nzira yechina: Kushandiswa kweiyo "Cell Styles" basa

Nenzira yekupedzisira, isu tinofunga kudzidza nezve "masero emasero" anoshanda, izvo zvinogona zvakare kushandisazve kugadzira mwero weganho, kusanganisira mamwe masero aisanganisira tafura yekunyanyisa. Zvirongwa zvako pachako zveichi chishandiso hachisi chinhu chakanyanya, chakagadzirira-chakagadzirira kazhinji chinowanzobatanidzwa.

1. Kutanga, kugovera tafura yese yayo masero aunoda kuchinja nerubatsiro rwe "masero masero". Dzvanya mutsara nezita rebasa riri mu "masitaji" block iri pane iyo imba yekutamba.



2. Hwindo rakaparadzana rinovhura nemienzaniso yemasero yehuwandu hwe data, mazita kana mafomu enhamba. Tora iyo basa rekushanda uye mbiri dzvanya pairi kuti ushande.



3. Paunenge uchingori kuvhara hwindo, unogona kutarisa mhedzisiro. Semuenzaniso, iyo Screenshot pazasi inoratidza dhizaini isina kujairika nemiganhu yakapetwa, iyo yakaoma kuzvigadzira iwe pachako, asi uchishandisa matemplate iri pamaviri ekudzvanya.



4. Kana iwe uchigona kuenda kune "Gadzira SCLE STECE" Tool Paishandisire nechishandiso ichi, sarudza zvine hungwaru, sarudza izvo zvichasanganisira chimiro, uye wozopa zita uye nzvimbo pane iyo huru yekusarudza.