Kuronga muExcel - ruzivo rwekutanga

Kuronga data muExcel chinhu chinobatsira kwazvo chinokutendera kuti uvandudze maonero eruzivo, kunyanya nemavhoriyamu makuru. Muchidzidzo chino, tichadzidza mashandisirwo ekuronga, kudzidza mirairo yekutanga, uye zvakare kujairana nemhando dzekurongedza muExcel.

Paunenge uchiwedzera data kuExcel, zvakakosha kuronga zvakanaka ruzivo pane pepa rebasa. Chimwe chishandiso chinokubvumira kuita izvi kuronga. Nerubatsiro rwekuronga, unogona kugadzira runyoro rweruzivo rwekusangana nezita rekupedzisira, kuronga zviri mukati metafura muhurongwa hwearufabheti kana mukudzika.

Ronga Mhando muExcel

Paunenge uchirongedza data muExcel, chinhu chekutanga chaunofanirwa kusarudza ndechekuti woisa mhando kune yese pepa rebasa (tafura) kana chete kune yakatarwa masero.

• Kuronga pepa (tafura) inoronga data rese mukoramu imwe. Kana kurongedza kunoshandiswa papepa, ruzivo rwakabatana mumutsara wega wega unorongwa pamwechete. Mumuenzaniso unotevera, chikamu Zita rekutaurirana (column A) yakarongwa nemaarufabheti.
• Rongedzo renji rinoronga data mumhando dzakasiyana dzemasero. Uku kurongedza kunogona kubatsira kana uchishanda neExcel mapepa ane akati wandei matafura eruzivo ari padyo nepedyo. Rudzi runoshandiswa kune renji harikanganisi imwe data iri papepa rebasa.

Maitiro ekugadzirisa pepa (tafura, rondedzero) muExcel

Mumuenzaniso unotevera, tichagadzirisa fomu reT-shirt rekuraira ne Zita rangu rekupedzisira (Koramu C) wozvironga munhevedzano yearufabheti.

1. Sarudza sero mukoramu yaunoda kuronga nayo. Mumuenzaniso wedu, tichasarudza sero C2.
2. Baya Data paRibhoni, wobva wadzvanya command Kuronga kubva A kusvika Zkuronga munhevedzano yokukwira, kana kuti kuraira Ronga kubva kuZ kuenda kuAkuronga mukudzika. Mumuenzaniso wedu, tichasarudza murairo Kuronga kubva A kusvika Z.
3. Tafura icharongwa nekoramu yakasarudzwa, kureva nezita rekupedzisira.

Paunenge uchironga tafura kana runyoro muExcel, inofanirwa kupatsanurwa kubva kune yekunze data pane pepa rebasa neinenge mutsara mumwechete kana koramu. Zvikasadaro, data rekunze richabatanidzwa mukugadzirisa.

Maitiro ekugadzirisa huwandu muExcel

Mumuenzaniso unotevera, isu tichasarudza tafura diki yakaparadzana mune Excel worksheet kuronga nhamba yeT-shirts akaodha pane mamwe mazuva.

1. Sarudza huwandu hwemasero aunoda kuronga. Mumuenzaniso wedu, isu tichasarudza mhando A13: B17.
2. Baya Data paRibhoni, wobva wadzvanya command Kuronga.
3. A dialog box richavhura Kuronga. Sarudza iyo column yaunoda kugadzirisa nayo. Mumuenzaniso uyu, isu tinoda kuronga data nehuwandu hwemirairo, saka isu tichasarudza iyo column hurongwa.
4. Seta kurongeka (kukwira kana kudzika). Mumuenzaniso wedu, tichasarudza vachikwira.
5. Kana ese ma parameter akarurama, tinya OK.
6. Huwandu hucharongwa nechikamu hurongwa kubva kumudiki kusvika kumukuru. Ziva kuti zvimwe zvese zviri mukati mebepa hazvina kurongwa.

Kana kurongedza muExcel kusingaitwe nemazvo, saka chekutanga chekutarisa kana hunhu hwakaiswa nemazvo. Kunyangwe typo diki inogona kutungamirira kumatambudziko pakuronga matafura makuru. Mumuenzaniso unotevera, takakanganwa kuisa hyphen muchitokisi A18, zvichikonzera rudzi rusina kururama.