Maitiro Ekuti Kukwira Kukwira Nhamba muExcel

Nzira 1: Kurumidza Sort Buttons

MuBudiriro, pane maviri mabhatani anokubvumidza iwe kuti udzore alfabeti, kukwira kana kuburuka, kana tiri kutaura nezvehuwandu. Ivo vanoshandisa nzira iri nyore kana paine tafura yakagadzirirwa-yakagadzirirwa iyo iyo yekugadzirisa inoitwa. Chimbofunga kuti kana uchiwedzera tsika nyowani, kurongeka kunogogodzwa pasi, uye kudzivirira mamiriro akadaro, zvinodikanwa kuti utange zvakare kana kushandisa nzira 3 yechinyorwa 3 chechinyorwa chechipiri.

1. Kutanga, bata pasi kuruboshwe bhatani bhatani uye sarudza ese matsikirwo aunoda kuziva mukukwira kuraira.



2. Pane iyo tab hamba, chengetedza chikamu chekugadzirisa uye sarudza iyo "rudzi uye chombo.



3. Mukati maro, iwe uchaona mhando mbiri dzakasiyana dzekurongedza - saizvozvo, mune imwe nyaya iri kutarisisa ichatora kusarudza "kurongedza kukwira".



4. Kana tafura yaive nedzimwe data kunze kweiyo yakataurwa renji, chiziviso chichaonekwa nechirongwa chekuwedzera iyo yakasarudzwa renji kuitira kuti mitsara yepedyo ichinongedzerwa huwandu mumasero emasero akasarudzwa.



5. Kana iwe ukasarudza huwandu hwekuwedzera, uchaona kuti data rese riri patafura rakachinja hukama hwekugadzirisa tsika. Iwe unogona kukanzura shanduko nekudzvanya iyo inopisa kiyi ctrl + z.



6. Iyo yechipiri mhando yekugadzirisa, iyo inonetsa chete miganhu yekusarudzwa yakatarwa, inoshanda chete kumitsara yakasarudzwa uye haina kukanganisa muvakidzani.

Nzira 2: Inogadziriswa Kugadzirisa

Kugadziriswa kwehunyanzvi kwakakodzera kana uchishanda pamwe nemhando dzinoverengeka patafura, pazvinenge zvichikosha chete kuti udzorere mutsara wokukwira, asi zvakare kushandisa mavara ealfabhethi kana mamwe marudzi aripo muExcel. Iyo huru maitiro ekugadziriswa kana uchishandisa chishandiso ichi chinotaridzika zvisingaite.

1. Muchikamu chimwe chete "kurongedza", tinya iyo "tsika yekubhadhara" bhatani.



2. Pakutanga, isu takatotaura nezve kutaridzika kwekuzivisa kana data rikaonekwa kunze kweiyo yakazvitsaurira. Tarisa uone ruzivo rwakatambirwa uye sarudza kuti ndeipi sarudzo yekupemberera mucherechedzo.



3. Mukutanga maviri ekudonha-pasi menyu, sarudza iyo sormx column uye iyo yakatarwa tsika.



4. Kune "kuraira" paramende, isa kukosha "kukwira".



5. Kana iwe uchida kugadzirisa mamwe makoramu, munhu anowedzera mwero mutsva uye tevera zviito zvakafanana.



6. Dzokera patafura uye uve nechokwadi chekuti basa racho rakabudirira.

Nzira 3: Fomula yeDynamic Kuronga

Mukupedzisa, isu tichaongorora imwe nzira yakaoma, asi inochinja-chinja, asi inochinjika iyo inosikwa yeForble Fomula, iyo ichafananidza tsika dziri patafura uye kubuda pamasero matsva enhamba ichikwira. Kubatsira kwenzira iyi kusati kwasarudzika kuti iyo fomula inowedzera otomatiki kana ichiwedzera tsika nyowani patafura, zvinoreva kuti kuronga kwavo kwakasimba kunoitika.

1. Ita kuti foni yekutanga ive fomula uye isa = idiki. Iri ndiro basa guru rinoverenga otomatiki tsika dzinodiwa.



2. Mumabhureki, isa chirevo (A: A; Riw (A1)), apo mavara eColum anotsiviwa neakarongedzwa, uye shandisa nhamba yekutanga seA1.



3. Ichiri iyi formula kusvika kumagumo etafura kuti nhamba inoenderana inoratidzwa muchitokisi chimwe nechimwe.



4. Kana iwe ukasarudza chero sero kubva kune yakagadzirwa assorted runyorwa, uchaona kuti zvirimo zve formula zvisizvo zvinosiyana zvichienderana nemunda. Ichi ndicho chinhu chikuru chekutambanudza kwakadaro.