Maitiro ekubvisa kuronga muExcel mushure mekuchengetedza

MuMicrosoft Office Excel, unogona kuronga zviri mumatafura neimwe hunhu uchishandisa maturusi akavakirwa muchirongwa. Chinyorwa ichi chinotsanangura maficha ekukanzura kuronga usati uye mushure mekuchengetedza gwaro.

Maitiro ekugadzirisa tafura muExcel

Kuunza tafura yetafura kune fomu inodiwa kumushandisi, uye kwete kurongazve data mumakoramu nemawoko, iwe unofanirwa kuita zvinotevera manipulations:

1. Sarudza tafura yose kana chikamu chayo: mbiru, mutsara, humwe huwandu hwemasero. Kuti usarudze zvinhu zveplate, bata pasi kiyi yekuruboshwe yemanipulator uye woidhonza munzira yakatarwa.

2. Dzvanya paizwi rekuti "Kumba" mubharu repamusoro reMicrosoft Office Excel uye nyatso dzidza chimiro chesarudzo chepaneru chinovhura.
3. Pakupera kwechinyorwa, tsvaga "Ronga uye Sefa" tebhu uye tinya pairi neLMB. Iyo tebhu ichavhura sediki menyu.

4. Sarudza imwe yesarudzo dzakaratidzwa dzekugadzirisa data mutafura. Pano unogona kuronga muhurongwa hwearufabheti kana munhevedzano.

5. Tarisa mhinduro. Mushure mekutsanangura imwe yezvisarudzo, tafura kana chikamu chayo chakasarudzwa chichachinja, iyo data ichagadziriswa zvichienderana nehumwe hunhu hunotsanangurwa nemushandisi.

Teerera! Iwe unogona zvakare kusarudza Custom Sort. Muchiitiko ichi, mushandisi achakwanisa kuronga maparamendi etafura array mukukwira kurongeka, nezuva, nefonti, nemakoramu akati wandei, mitsetse, kana kuita zvine simba kurongedza.

Nzira yekukanzura kuronga paunenge uchishanda negwaro

Kana mushandisi, achishanda mugwaro reExcel, akaronga netsaona data retafura, zvino kuti agadzirise chiito chake, anozofanira kutora matanho anotevera:

1. Vhara hwindo rekuronga.
2. Rega kusarudza maseru ese ematafura. Nechinangwa ichi, iwe unofanirwa kudzvanya bhatani rekuruboshwe mbeva panzvimbo yemahara yepepa rekushanda kunze kwendiro.
3. Dzvanya pachiratidzo che "Kanzura", chinotaridzika semuseve kuruboshwe uye chiri padyo nebhatani re "Faira" mukona yekumusoro kuruboshwe kwechidzitiro.

4. Ita shuwa kuti zviito zviri mugwaro zvinodzokera kumashure nhanho imwe. Avo. huwandu hwemaseru hunofanira kusagadziriswa. Iyo yekubvisa basa inobvumidza iwe kudzima chiitiko chakaitwa chekupedzisira.
5. Iwe unogona zvakare kumisa mashandiro ekupedzisira muMicrosoft Office Excel uchishandisa musanganiswa wemabhatani pakhibhodi yekombuta. Nechinangwa ichi, mushandisi anofanirwa kuchinjika kune dhizaini yeChirungu uye panguva imwe chete kubata pasi "Ctrl + Z" makiyi.

Mamwe Mashoko! Basa rekugadzirisa uchishandisa "Ctrl + Z" musanganiswa unoshanda mune ese eMicrosoft Office edhita, zvisinei neshanduro yavo.

Maitiro ekukanzura kuronga mushure mekuchengetedza excel gwaro

Kana basa reExcel rikachengetwa uye mushandisi akavhara gwaro, data rese re clipboard rinobviswa otomatiki. Izvi zvinoreva kuti bhatani re "Kanzura" harisi kuzoshanda nguva inotevera paunomhanyisa faira, uye haugone kubvisa kurongedza kwetafura nenzira iyi. Mumamiriro ezvinhu aya, nyanzvi dzine ruzivo dzinokurudzira kutora akati wandei nhanho dziri nyore maererano neiyo algorithm:

1. Mhanya faira reExcel, ita shuwa kuti basa rekare rakachengetwa uye rinoratidzwa papepa rebasa.
2. Dzvanya bhatani rekurudyi rembeva pazita rekoramu yekutanga mundiro.
3. Muwindo rezvinyorwa, tinya mutsara we "Insert". Mushure mekuita kwakadai, koramu yekubatsira ichagadzirwa mutafura.
4. Mumutsara wega wega wekoramu yekubatsira, unofanirwa kutsanangura nhamba yesiriri yemakoramu anotevera. Somuenzaniso, kubva pa1 kusvika ku5, zvichienderana nehuwandu hwemasero.

5. Iye zvino isu tinoda kugadzirisa iyo data mutafura yetafura mune chero nzira iri nyore. Nzira yekuita izvi yakatsanangurwa pamusoro apa.
6. Chengetedza gwaro uye uvhare.

7. Mhanya iyo Microsoft Office Excel faira zvakare uye gadzirisa iyo yebetsero koramu mukukwira kurongeka nekuisarudza zvachose uye kusarudza yakakodzera sarudzo kubva pane iyo Ronga uye Sefa tebhu.
8. Nekuda kweizvozvo, tafura yese inofanira kurongerwa sekoramu yekubatsira, kureva kutora fomu rekutanga.
9. Iye zvino unogona kudzima koramu yekutanga kudzivirira kuvhiringidzika uye chengetedza gwaro.

Zvinokosha! Iwe unogona kuverengera koramu yekubatsira otomatiki nekunyora kukosha chete musero yayo yekutanga uye nekuiwedzera kusvika kumagumo etafura array.

Iwe unogona zvakare kugadzirisa iyo data muExcel tafura nemaoko nekuita mamwe maverengero, uchichinja kukosha mumakoramu nemitsara pakati pawo. Nekudaro, iyi nzira inotora nguva yakawanda kune mushandisi. Zviri nyore kushandisa chishandiso chakavakirwa musoftware yakagadzirirwa kupedzisa basa. Mukuwedzera, iyo inodiwa paramita inogona kurongedzwa nemuvara uye sero size.

mhedziso

Saka, kuronga muMicrosoft Office Excel kunoitwa munguva pfupi pfupi inogoneka nenzira dziri nyore. Kukanzura chiitiko ichi mushure mekuchengetedza gwaro, iwe unozofanirwa kugadzira imwe yekuwedzera mbiru mutafura yetafura, nhamba yacho, uye wozoirongedza mukukwira kurongeka. Iyo yakadzama algorithm yakapihwa pamusoro.