Kushanda nematafura, vashandisi vanobhadhara pekutanga kupinda data, dzimwe nguva vachikanganwa kutaridzika kwegwaro. Uku kusasara kwakajeka, nekuti tafura yakashongedzwa yakanaka kwete chete yekunzwisisika kwekunzwisisa, asi zvakare kunzwisisa uye kubata imwe nuances mugwaro iri. Tevere, isu tichaongorora zvimwe zvishandiso zvemaono kuti tidurire maseru, uye kuti ungashandise sei.
Kuzadza masero muExcel: nzira dzekutanga
Kuzadza masero ane ruvara, zvichienderana nezviri zvemukati, zvinofambisa maitiro ekushanda uye kuziva ruzivo rwunodiwa. Iyi nzira inonyanya kukosha kana ichishanda nematafura mikuru ine data dzakawanda dzakawanda dzichida kuronga. Kubva pane izvi zvinotevera kuti ruvara rwemuvara runobatsira kuumba gwaro rakapera pazvinhu zvakakosha.
Kugadzira zvinyorwa zvehukuru zvidiki, unogona kushandisa nzira yebhuku remanyorero emakona. Kana iwe uchida kuumbiridza tafura inogara iyo yakazara pepa kana kana zvimwe, zviri nyore kushandisa zvishandiso zvakakosha. Kunyangwe kana paine vashandisi vakashinga vanoda kuita basa rese, mukana ndewekuti chikanganiso chinotenderwa mugwaro. Kunyanya kufambisa mabasa akadaro muExcel, masero anodururwa nemavara. Maitiro Ekuita izvi, funga nezvazvo.
Nzira Nhamba 1: Zvakajairika kuzadza neruvaraKuita iri basa, isu tichada chishandiso chekuchinja chimiro chemasero. Kuti uite izvi, tevera mirayiridzo yakapihwa:
- Kutanga, sarudza iyo cell iyo iyo ruvara ichave ichizadza uye ichiverengera nekudzvanya lkm. Zvichida ichava masero akati wandei kamwechete.
- Mu "Imba" Toolbar, tsvaga font block. Zvimwe zviito zvinogona kuitwa neimwe yedzimwe nzira dzakarongwa:
- Kuzadza ruvara rwechitokisi, shandisa iyo "kuzadza ruvara" chishandiso "chakaratidzwa muchimiro chebhakiti inoita kuti uzadze. Nekudzvanya pane iyo icon ine triangle, vhura dialog bhokisi kwaunosarudza iyo yaunoda ruvara.
- Kana iwe wakundikana kusarudza ruvara rweiyo yaunoda mvuri yemvuri, wobva washandisa "mamwe mavara" chimiro. Muwindo rinovhura, sarudza imwe yenzira dzekusarudzwa kwemavara: Zvinoenderana neiyo yakaratidzwa cellular chirongwa kana mune spectrum. Iyo yechipiri sarudzo inoita kuti igone kusarudza toni chaiyo.
- Iyo "zadza ruvara" bhatani rinochengetedza sarudzo yekupedzisira. Naizvozvo, kana iwe ukaronga kushandisa zadza nerudzi rumwe munzvimbo dzinoverengeka, mushure mekuita sero raunoda, unogona kudzvanya pane bhatani pasina kuvhura windows.
Kuita kuti kuitwa kwetafura yekunyanyisa haina kutaridzika senge inokonzeresa uye monophonic, zvinokwanisika kuunza kuzadza kuzadza nekuwedzera maitiro mukati mazvo. Funga nezve maitiro ekuita basa racho:
- Sarudza imwe chete kana more masero aunoda kuisa iyo color maitiro.
- MuTab yeimba yeTab, tsvaga "
- Muwindo rinovhura, enda kune "zadza" tab, kupi muboka "reruvara rwemashure" tinosarudza iyo inodiwa toni yekuzadza.
- Tevere, ita imwe yeinotevera:
- Kuti uzadze maviri mavara uchishandisa iyo nzira, enda ku "pateni" munda uye sarudza mavara anodiwa. Mushure meizvozvo, enda ku "pateni" munda uye sarudza maitiro ekugadzira.
- Kuti ushandise zvinokosha, iwe unofanirwa kutevera chinongedzo "uzadzise nzira" uye sarudza iyo inodiwa paramita. Kana iyo yakasarudzwa parameter yakarongedzwa, tinya iyo "OK" bhatani.
Iyi nzira inogona kushandiswa kana sero racho risati rasarudzwa reruvara risati rwaitwa uye hapana zvimwe zviito zvakaitwa. Maitiro ekuita zviito zvekuita: Sarudza masero anodiwa kuti agadziriswe, uye tinya iyo "CTRL + Y" makiyi.
Kana iyo zadza yakagadzirwa, uye shure kwaizvozvo, chiitiko chimwe chete chakaitwa, saka nzira iyi haizoshande, sezvo musanganiswa wekiyi wakaratidzwa wakavakirwa pakuzadzikiswa kwechiitiko chazvino, kuve rudzi rwechikwereti.
Nzira Nhamba 4 Kugadzira MacroIyi nzira inoda chirongwa chakakosha cheMacrorecorer umo, kuve nehumwe hunyanzvi, unogona kugadzira macroshi kuita zviito zvakasiyana siyana. Mumufananidzo iwe unogona kuona muenzaniso kodhi yeiyo yakagadzirwa macro.
Kubviswa kwesero kuzadza
Kana iwe uchida kubvisa iyo yaimboita cell kuzadza, wobva washandisa mirairo pazasi:
- Sarudza masero anofashika nemavara kana ruvara maitiro anoda kugadziriswa.
- Pamhepo tabu tabu, enda kune "font" block. Dzvanya pane iyo Arrow icon uye vhura iyo dialog box. Enda kune kukosha "hapana kuzadza" uye uzvidzivise nekudzvanya lkm.
Mhedziso
Pane nzira dzinoverengeka dzekuzadza color color. Mumwe nemumwe wavo ane zvakanakira uye zvakashata. Mune mamwe mamiriro ezvinhu, zvinogamuchirika kushandisa nzira yekutanga, yekukurumidza yekuzadza, mune vamwe zvinodikanwa kuti utarisire zvakanyanya kugadzirwa, ipapo kuwedzera kwematanho kunobatsira.
Mharidzo iyo inopisa-kiyi inozadza muExcel yakave yakatanga kutanga kune ruzivo rweruzivo.