Kushandisa Sort Order mu Excel Spreadsheets

Kuronga inzira yekugadzirisa zvinhu mune imwe nzira yekutevedzera kana kurongeka maererano nemitemo yakananga.

Mune mapurogiramu epadheseti akadai seExcel neGoogle Spreadsheets, pane mazita akasiyana-siyana mairairo anowanikwa zvichienderana nerudzi rwe deta riri kurongwa.

Kukwidza vs Kuyerera Kuronga Mutemo

Kune zvinyorwa kana nhamba dzepamusoro , maitiro maviri ehutano hwekutsvaga ari kukwira nekudzika .

Zvichienderana nemhando ye data iri mumusarudzo yakasarudzwa, aya mairairo achagadzira deta nzira dzinotevera:

Nokukwira mitambo:

• Tanga A kusvika Z - yekunyora deta
• Ronga Muduku Kupfuura Kukuru - kune nhamba yedata
• Rongedza Yekare Kubva kuNewest - nokuda kwezuva kana nguva yenguva

Nokuderedza marudzi:

• Tanga A kusvika Z - yekunyora deta
• Rongedza Rukuru Kupfuura Dukuduku - kune nhamba yedata
• Rongedza Newest kusvika kune yakwegura - nokuda kwezuva kana nguva yenguva

Ridhi Rows and Columns and Sorting

Mitsetse yakavanzwa uye mapoka ehurukuro haatauri panguva yekusarudza, saka inofanirwa kushandiswa asati aitika.

Somuenzaniso, kana mutsetse 7 wakavanzwa, uye chikamu chehuwandu hwemashoko akagadziriswa, hunoramba huri mutsetse 7 pane kutamirwa kunzvimbo yakarurama sechikonzero chechimiro.

Izvo zvinoenda kune zvikamu zve data. Kuronga nemitsetse kunosanganisira kugadzirisa mazamu ematafura, asi kana Kovha yeBh yakavanzwa isati yasvika, icharamba iri seChitamende B uye isingadzoserwi nemamwe mapuranga muurongwa hwakatarwa.

Kuronga neMuvara uye Mhando dzeMirairo

Mukuwedzera pakugadzirisa nehutsika, zvakadai semashoko kana nhamba, Excel ine tsika dzetsika dzakasarudzika dzinobvumira kuronga nemuvara we:

• text or font color;
• ruvara rwekero ;
• conditional formatting icons .

Sezvo pasina kukwira kana kuburuka kurongeka kwemavara, mushandisi anotsanangura mararamiro akarongeka muChirongwa dialog box .

Ronga Kuronga Kusiyana

Mhedziso: Dhigiri maitiro mairairo

Mipurogiramu yakawanda yemapapurosheet inoshandisa aya anotevera kushandiswa kwemhando dzemhando dzemhando dzakasiyana dze data.

Masejena asina kujeka : Muzvikamu zviviri zvichikwira nekudzika mitemo yakasiyana, pasina masero anogara achiiswa pakupedzisira.

Numeri : Nhamba dzisina kunaka dzinoonekwa sezvinhu zviduku zvikuru, saka nhamba huru yakaipa nguva dzose inotanga kuuya mukukwira kworudzi urwu uye pakupedzisira mukuderera, zvakadai se:
Kukwidza Mutemo: -3, -2, -1,0,1,2,3
Kuramba Kurayira: 3,2,1,0, -1, -2, -3

Dates : Zuva rekare rinonzi rinokosha kana ridiki kudarika zuva razvino kana rekare.
Kukwidza Mutemo (yakwegura kusvika kune yakapfuura): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Kuramba Kuraira (yakanyanya kuitika kune yakwegura): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000

Alphanumeric Data : Kubatanidzwa kwemashoko nenhamba, data alphanumeric inotorwa semashoko ekunyora uye mhando imwe neimwe inorongwa kubva kuruboshwe kuenda kurudyi kune unhu nehuwandu hwevanhu.

Pamusoro pealphanumeric data, nhamba dzinofungidzirwa kuva dzisinganyanyi kukosha kupfuura tsamba dzekunyora.

Nokuda kwemashoko anotevera, 123A, A12, 12AW, uye AW12 iyo inokwira kurongeka ndeyokuti:

123A 12AW A12 AW12

Kunyorera kurongeka kwakadai ndeku:

AW12 A12 12AW 123A

Muchikamu chacho Mungaita sei zvakarurama alphanumeric data mu Excel , iri pawebsite yeMicrosoft.com, urongwa huri kurongeka hupi hupi hupi hupi hupi hupi hunowanikwa mualphanumeric data:

0 1 2 3 4 5 6 7 8 9 (nzvimbo)! "# $% & () *,. /:;? @ [\] ^ _` {|} ~ + <=> ABCDEFGHIJKLMNOPQRSTU VWXYZ

Logical or Boolean Data : TRUE kana kuti FALSE maitiro chete, uye FALSE inonzi inokosha kuduku kupfuura TRUE.

Nokuda kwemashoko anotevera, TRUE, FALSE, TRUE, uye FALSE yakakwira yakarongeka ndeyokuti:

FAL FALSE TRUE TRUE

Kunyorera kurongeka kwakadai ndeku:

CHOKWADI

CHOKWADI CHOKWADI