Nzira yekuwanza sei column nemutsara muExcel spreadsheet

Paunenge uchishanda neExcel maspredishiti, dzimwe nguva zvinova madikanwa kugovera ruzivo kubva kune imwe koramu pamusoro pemitsetse yakati wandei. Kuti urege kuita izvi nemaoko, unogona kushandisa zvakavakwa-mukati maturusi echirongwa pachayo. Izvo zvinoshandawo kune kubereka kwemabasa, mafomula. Pavanenge vachingowedzerwa nehuwandu hunodiwa hwemitsara, unogona kukurumidza kuwana mhinduro chaiyo yekuverenga.

Kugoverwa kwedata kubva kune imwe column kuita mitsetse yakasiyana

MuExcel, pane murairo wakasiyana waunogona kugovera ruzivo rwakaunganidzwa mune imwe koramu mumitsara yakaparadzana.

Kuti ugovere data, unofanirwa kutevedzera matanho mashoma akareruka:

1. Enda kune "EXCEL" tab, iyo iri papeji huru yezvishandiso.
2. Tsvaga chivharo chine "Table" zvishandiso, tinya pairi nebhatani rekuruboshwe.
3. Kubva pane iyo inovhura menyu, sarudza iyo "Duplicate column nemitsara" sarudzo.
4. Mushure meizvozvo, hwindo rine zvigadziriso zvechiito chakasarudzwa rinofanira kuvhurwa. Mundima yekutanga yemahara, iwe unofanirwa kusarudza kubva pane yakarongwa runyorwa iyo column yaunoda kuwedzera.
5. Kana iyo column yakasarudzwa, unofanirwa kusarudza pamhando yekuparadzanisa. Inogona kunge iri dot, comma, semicolon, nzvimbo, kupetwa kwemavara kune mumwe mutsetse. Sarudzo, iwe unogona kusarudza yako wega hunhu kupatsanura.

Mushure mokupedza matanho ose anotsanangurwa pamusoro apa, pepa rekushanda idzva richagadzirwa pairi tafura itsva ichavakwa kubva mumitsara yakawanda iyo data kubva mumutsara wakasarudzwa ichagoverwa.

Zvinokosha! Dzimwe nguva pane mamiriro ezvinhu apo chiito chekuwanza makoramu kubva papepa rekushanda rinoda kucherechedzwa. Muchiitiko ichi, unogona kumisa chiito kuburikidza nekiyi musanganiswa "CTRL + Z" kana kudzvanya pane yekubvisa icon pamusoro peiyo huru bhari.

Kuberekwazve kwemafomula

Kazhinji kana uchishanda muExcel pane mamiriro ezvinhu kana zvichidikanwa kuti uwedzere fomula imwe kamwechete mumakoramu akati wandei kuitira kuti uwane mhedzisiro inodiwa mumaseru ari pedyo. Iwe unogona kuzviita iwe pachako. Zvisinei, nzira iyi inotora nguva yakawanda. Pane nzira mbiri dzekuita otomatiki maitiro. Negonzo:

1. Sarudza iyo yepamusoro sero kubva patafura iyo fomula iripo (uchishandisa LMB).
2. Fambisa cursor kukona yekurudyi kwesero kuratidza muchinjikwa mutema.
3. Dzvanya LMB pane icon inoonekwa, dhonza mbeva pasi kune inodiwa nhamba yemasero.

Mushure maizvozvi, mumaseru akasarudzwa, zvigumisiro zvichaonekwa maererano nemaitiro akagadzirirwa sero yekutanga.

Zvinokosha! Kudhindwa kweformula kana rimwe basa mukoramu yese negonzo zvinogoneka chete kana maseru ese ari pasi akazadzwa. Kana imwe yemasero isina ruzivo mukati, kuverenga kunopera pairi.

Kana koramu ine mazana kusvika kuzviuru zvemasero, uye mamwe acho asina chinhu, unogona kuita otomatiki maitiro ekuverenga. Kuti uite izvi, unofanirwa kuita zviito zvakawanda:

1. Maka pasero rekutanga rekoramu nekudzvanya LMB.
2. Shamba vhiri kusvika kumagumo ekoramu iri papeji.
3. Tsvaga sero rekupedzisira, bata pasi "Shift" kiyi, tinya pane iyi sero.

Rudzi runodiwa rucharatidzwa.

Ronga data nemakoramu nemitsara

Kazhinji kune mamiriro ezvinhu apo, mushure mekuzadza otomatiki pepa rebasa nedata, ivo vanogovaniswa zvisina tsarukano. Kuita kuti zvive nyore kuti mushandisi ashande mune ramangwana, zvinodikanwa kuronga data nemitsara nemakoramu. Muchiitiko ichi, semugovera, unogona kuseta kukosha nefonti, kudzika kana kukwira, neruvara, alfabheti, kana kusanganisa ma parameter aya nemumwe. Maitiro ekurongedza data uchishandisa yakavakirwa-muExcel maturusi:

1. Tinya kurudyi pese papepa rebasa.
2. Kubva pane menyu yemukati inooneka, sarudza sarudzo - "Ronga".
3. Inopesana neparameter yakasarudzwa, sarudzo dzinoverengeka dzekugadzirisa data dzichaonekwa.

Imwe nzira yekusarudza ruzivo rwekuronga sarudzo ndeye kuburikidza nehombe toolbar. Pairi unofanira kuwana "Data" tab, pasi payo sarudza "Ronga" chinhu. Maitiro ekuronga tafura nechikamu chimwe chete:

1. Chekutanga pane zvese, iwe unofanirwa kusarudza huwandu hwe data kubva kune imwe column.
2. Icon ichaonekwa pabhara rebasa ine sarudzo yesarudzo yekuronga ruzivo. Mushure mekudzvanya pairi, runyoro rwezvinogoneka kuronga sarudzo ruchavhurwa.

Kana makoramu akati wandei kubva papeji akatanga asarudzwa, mushure mekudzvanya pane yemhando icon pabhara rebasa, hwindo rine marongero echiito ichi richavhurwa. Kubva pane zvakarongwa sarudzo, iwe unofanirwa kusarudza iyo sarudzo "otomatiki wedzera iyo yakasarudzwa renji". Kana iwe ukasaita izvi, iyo data iri mukoramu yekutanga ichagadziriswa, asi iyo yakazara chimiro chetafura ichaputswa. Kuronga mitsara:

1. Muwindo rekugadzirisa zvirongwa, enda kune "Parameters" tab.
2. Kubva pahwindo rinovhura, sarudza iyo "Range Columns" sarudzo.
3. Kuti uchengetedze zvigadziriso, tinya bhatani rekuti "OK".

Maparamita anotanga kuiswa muzvirongwa zvekugadzirisa haabvumiri kugoverwa kwe data pane pepa rekushanda. Kuti uite izvi, unofanirwa kushandisa iyo RAND basa.

mhedziso

Iyo nzira yekuwanza makoramu nemitsara yakanyatsojeka, ndosaka asiri wese mushandisi anoziva maitiro ekuishandisa. Zvisinei, mushure mokuverenga mirairo iri pamusoro, izvi zvinogona kuitwa nokukurumidza zvikuru. Mukuwedzera kune izvi, zvinokurudzirwa kudzidzira nekugadzirwa kwemabasa uye mafomula, nekuda kwekuti zvichave zvichiita kuchengetedza nguva yakawanda panguva yekuverenga kwakasiyana-siyana muzvikamu zvakakura zvemasero.