6 Nzira dzekugadzirisa Dhamba mu Excel

Iyi nyanzvi yezano rinoshandisa nzira dzakasiyana dzekusarudza data muExcel. Mashoko akajeka anogona kuwanikwa pamapeji anotevera:

1. Kurumidza Kuronga Pamwe Chete Rokushandisa uchishandisa Mhando & Futa kana Hot Keys
2. Rongedza paMahwendefa Akawanda
3. Rongedza Dates kana Times
4. Rongedza Mazuva eVhiki, Mwedzi kana mamwe Makombiro Emhando
5. Rongedza Ropa - Kudzokorora Makorumoni

Kusarudza Dhidhiyo Kuti Ive Yakarongwa

Dare risati ragona kugadziriswa, Excel inoda kuziva ruzivo rwakananga ruchagadziriswa, uye kazhinji Excel yakanaka chaizvo pakusarudza nzvimbo dzedunhu rakabatana - chero nguva iyo yaipinda,

1. hapana mitsara isina kana mahwendefa yakasara mukati memunharaunda yakabatana;
2. uye mitsetse isina kuvhara uye misoro yakasara pakati penharaunda ye data yakabatana.

Excel ichasarudza kunyange, zvakarurama chaizvo, kana nzvimbo ye data ine mazita emumunda uye isabvisa rutsara urwu kubva pane zvinyorwa zvinofanira kusarudzwa.

Zvisinei, kubvumira Excel kukasarudza mararamiro okugadziriswa kunogona kuva mungozi - kunyanya nehuwandu hwemashoko akaoma kutarisa.

Kuti uone kuti iyo yakakodzera data yakasarudzwa, tsanangurira huwandu usati watanga mararamiro.

Kana rutivi rwakadaro rwuri kurongedzwa kakawanda, nzira yakanakisisa ndeyokupa Zita .

01 ye 05

Rongedza Mhete uye Sarudza Kuronga

Kuchengeta kunoda kushandiswa kwekakosha yorudzi uye kurongeka kwemhando.

Rudzi rwemhando ndiyo data iri mu column kana ma column unoda kuronga nayo. Inowanikwa nehurukuro inotungamirira kana zita remunda. Mumufananidzo wepamusoro, iyo inogoneka yakakosha mashizha muDhijiti yevadzidzi, Zita , Zera , Purogiramu , uye Mwedzi zvakatanga

Nenguva isipi, kuvhara pane imwe sero iri mumutsetse une chinyorwa chekugadzirira zvakakwana kutaurira Excel kuti chinangwa chei.

Kune zvinyorwa kana nhamba dzepamusoro , zvingasarudzwa zviviri zvekugadzirisa zvinhu zviri kukwira nekudzika .

Paunenge uchishandisa bhatani Rudzi & Filter paImba yebhu yebhoni, urongwa hwakarongeka urongwa huri pasi rezasi huchashanduka zvichienderana nehuwandu hwemashoko mumutsetse wakasarudzwa.

Kurumidza Kuronga uchishandisa Mhando & Filter

MuExcel, kukurumidza kukurumidza kunogona kuitwa kuburikidza neBurisa & Filter bhatani paImba yebhu yebhoni .

Nhanho dzekuita zvakakurumidza ndezvi:

1. Dzvanya pane sero iri mu column rine chinyorwa
2. Dzvanya paImba yebhu yebhoni kana zvichidiwa
3. Dzvanya paMutambo & Shingaira kuti uzarure mhando yekunyorera yemhando yekusarudza
4. Dzvanya pane imwe yezvisarudzo zviviri kuti usarudze pane kana uchikwira kana uchiburuka
5. Tarisa kuti uone kuti data yakarongwa nenzira yakarurama

Rongedza Dhina Zvichishandisa Bhizinesi Cheki Dzakanaka

Hapana chekodhi yekutsinhanisa nheyo yekubatanidzwa yekutsvaga data muExpcel.

Izvo zviripo ndezvipinza zvinopisa, izvo zvinokubvumira kushandisa zvinyoro panzvimbo pekushandisa mutsara kuti usarudze zvimwe zvingasarudzwa pamusoro apa paImba yebhu yebhoni.

• Kushandisa iyo keyboard kuti uwane nzira dzebhandi nguva dzose dzinotanga neAll key.

Kuchengetedza Mukusvitsa Mutemo uchishandisa Hot Keys

1. Dzvanya pane sero mumutsetse wechirudzi
2. Dhinda zvisikwa zvinotevera pane keyboard:
3. Alt HSS
4. Tafura ye data inofanira kuenzanisirwa A kusvika kuZ / duku kuduku hukuru kuburikidza nesarudzo yakasarudzwa

Mafuta anopisa anoshandura ku:
"Alt" key> "Kumba" tab> "Kugadzirisa" boka> "Rongedza & Funga" menyu> "Ronga Muduku Kupfuura Kukuru" sarudzo.

Kuchengetedza muChirongwa Chekushandisa uchishandisa Hot Keys

Matanho ekutsvaga mukubhururuka kuronga uchishandisa mashizha anotsvaira akafanana neawo akanyorwa kune imwe yakakwira kunze kwekuti inopisa inosanganiswa ndeyokuti:

Alt HSO

Mafuta anopisa anoshandura ku:
"Alt" key> "Kumba" tab> "Kugadzirisa" boka> "Rongedza & Futa" menyu> "Sarudza Mukuru Kupfuura Zvishoma" sarudzo.

02 of 05

Ronga pa Multiple Columns of Data mu Excel

Mukuwedzera pakuita nekukurumidza zvakarongwa zvichienderana nekorodha imwe yedata, Excel tsika yemaitiro yakakunakira inokubvumira kuronga pamakoromendi akawanda nekutsanangura maitiro mazhinji evanhu.

Mumitauro yakawanda-mutsara, rudzi rwakakosha runoratidzika nekusarudza mutsara wehurukuro muChirongwa chebhokisi yebhokisi .

Sezvo nekukurumidza, rudzi hunoshandiswa runorondedzerwa nekuratidza mazita emisoro kana mazita emumunda , mutafura ine chinyorwa.

Rongedza pa Multiple Columns Example

Mumuenzaniso uri pamusoro apa, matanho anotevera akateverwa kuti arongedze data iri muhara H2 kusvika ku12 pazvikamu zviviri zvematare - kutanga mazita, uye nezera.

1. Simbisa mhando yemasero ekugadziriswa
2. Dzvanya paImba yebhu yebhoni .
3. Dzvanya paMhando & Firiza icon pane ribhoni kuti uzarure rondedzero.
4. Dzvanya pa Custom Custom Sort in the down-list list kuti uburise Hurongwa hwebhokisi yebhokisi
5. Pasi peColumn iri mubhokisi rebhokisi, sarudza Zita kubva pakaderera pasi kuti utange kusarudza data neZita column
6. Rudzi Rwakasarudzwa sarudzo yakasara rakatarirwa kuMaitiro - sezvo rudzi rwacho rwakavakirwa pamashoko chaiwo ari patafura
7. Pasi peMutungamiri weChirongwa , sarudza Z kusvika A kubva pane doro rezasi kuti uenzanise Dhizita reDzidziso muchibvumirano
8. Pamusoro pebhokisi rebhokisi, tanga pane Bhokisi Rokuwedzera kuti uwedzere wechipiri sarudzo
9. Nokuda kwechipiri svondo, pasi peChongwe chinyorwa , sarudza Zera kubva pakaderera pasi kuronga zvinyorwa zvine mazita akanyorwa neChirungu chekare
10. Pasi Pakuda Kuronga musoro, sarudza Kubva kudiki kuduku kubva pakuderera-pasi urongwa kuti uenzane neDhese yeDhese pakudzika kurongeka
11. Dzvanya OK mubhokisi rebhokisi kuti uvhare bhokisi rebhokisi uye sarudza data

Somugumisiro wekutsanangura chechi yechipiri yakakosha, mumuenzaniso uri pamusoro apa, zvinyorwa zviviri zvine maitiro akaenzana eZita reZita zvakarongedzerwa mukudzika kwekushandisa achishandisa munda we Age , zvichiita kuti zvinyorwa zvevadzidzi A. Wilson ane makore 21 ari pamberi nhoroondo yechipiri A. Wilson ane makore 19.

Row Rokutanga: Column Headings kana Data?

Nhamba ye data yakasarudzwa pakusarudza mumuenzaniso wepamusoro yakabatanidza zvinyorwa zvinyorwa pamusoro pemutsara wokutanga we data.

Excel yakaona rutsara iri rine data yakange yakasiyana neda data mumitsara inotevera kuitira kuti iite mutsara wekutanga kuva korona yemusoro uye yakagadzirisa mawanikidzwa aripo muGadziriro yebhokisi yekubhokisi kuti uiise.

Imwe nzira iyo Excel inoshandisa kugadzirisa kana mutsara wekutanga une mutsara wemusoro uri kufomesa. Mumuenzaniso wepamusoro, mutsara mumutsara wokutanga ndeye faira yakasiyana uye inenge yakasiyana nemuvara kubva kune imwe nzvimbo mumamwe mazere. Inoparadzaniswawo kubva kumitsara iri pasi nechepamhi muganhu.

Excel inoshandisa mutsauko wakadaro mukugadzirisa kwayo kana mutsara wokutanga uri mutsara wekutungamirira, uye zvakanaka kuti uite zvakanaka - asi hauna kukwana. Kana ikakanganisa, Rudzi rwebhokisi yebhokisi rine chekibhokisi bhokisi - My data ine musoro - iyo inogona kushandiswa kudarika izvi zvakasarudzwa kusarudza.

Kana mutsara wekutanga usingasina misoro, Excel inoshandisa tsamba yemutsetse - yakadai seChongwe D kana Column E - sezvisarudzo muColumn sarudzo yeChirongwa chebhokisi yebhokisi.

03 of 05

Rongedza Zuva Nezuva kana Nguva muExcel

Mukuwedzera pakusarudza magwaro dhiabhibheti kana kuti nhamba kubva kuhukuru kusvika kuduku, Excel sarudzo dzakasarudzika dzinosanganisira kutarisa maitiro ezuva.

Mitemo yakatarwa yezuva ndeyekuti:

• Kukwidza urongwa - hukuru kudarika
• Kunyorera kurongeka - itsva kupfuura yekare

Kurumidza Muchiranidza neChirongwa Chebhokisi Dialog

Kubva pamazuva uye nguva dzakangoshandiswa nhamba yedata, nekuda kwetsika imwechete - yakadai seTsika yakakweretwa mumuenzaniso mumufananidzo uri pamusoro - nzira yakakurumidza nzira inogona kushandiswa kubudirira.

Pamhando dzinobatanidza mikoko yakawanda yemasikati kana nguva, Rudzi rwebhokisi yebhokisi rinofanira kushandiswa - sekunge sekusarudza pamakoromendi akawanda emutsamba kana deta deta.

Rongedza Nomusi Wemuenzaniso

Kuti uite nokukurumidza kuronga nezuva mukukwira urongwa - yakwegura kusvika kune itsva - nokuda kwemufananidzo uri pamusoro apa, matanho angave:

1. Simbisa mhando yemasero ekugadziriswa
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya paChirangaridzo & Firiza icon paibhoni kuti uzarure pasi rezasi
4. Dzvanya paMhando Yekare-kare kusvika kuNewest sarudzo mune urongwa kuti urongedze data mukukwira urongwa
5. Zvinyorwa zvinofanira kuenzaniswa nematare akare kare muKorodhe yakakweretwa kumusoro kwetafura

Dhesi Nenguva Dzakachengetwa seMagwaro

Kana migumisiro yekutsvaga nezuva isingashandisi sezvinotarisirwa, iyo data iri mumutsetse ine chinyorwa chinogona kunge ine mazuva kana nguva dzakachengetwa semashoko ekunyora panzvimbo pane nhamba (mazuva uye nguva dzakangoshandiswa nhamba yedata).

Mumufananidzo wepamusoro, nhoroondo yeA. Peterson yakaguma pazasi kwerwendo, apo, zvichibva pazuva rekubhadhara - November 5, 2014 -, rekodhi yacho inofanira kunge yakaiswa pamusoro pezvinyorwa zve A. Wilson, iyo zvakare ine zuva rakakwereta raNovember 5.

Chikonzero chemigumisiro isingatarisirwi ndeyokuti zuva rakakwereta kuna A. Peterson rakachengetwa semashoko, panzvimbo pekuverenga

Mixed Data uye Quick Sorts

Paunenge uchishandisa nzira yakakurumidza nzira kana zvinyorwa zvine mazita uye nhamba ye data zvakakanganiswa pamwe chete, Excel inoshandisa nhamba uye deta zvinyorwa zvakasiyana -kuisa zvinyorwa nemashoko ekunyora pasi pezorongwa zvakarongwa.

Excel inogonawo kusanganisira mutsara wehurukuro mumigumisiro yemhando - kuidudzira ivo seimwe mutsara wemashoko ekunyora pane kufanana nemazita emumunda etafura ye data.

Rongedza Manyevero - Sarudzai Bhokisi Remutauro

Sezvinoratidzwa mumufananidzo wepamusoro, kana Hurukuro yebhokisi yebhokisi iri kushandiswa, kunyange kune marudzi pane imwe korombo, Excel inoratidza mharidzo inokuyambira kuti yakasangana nemashoko akachengetwa semashoko uye inopa iwe sarudzo ku:

• Ronga chero chinhu chinoratidzika senhamba sehamba
• Rongedza nhamba uye nhamba dzachengetwa sezvinyorwa zvakasiyana

Kana ukasarudza sarudzo yekutanga, Excel ichaedza kuisa dhidhiyo dhesi panzvimbo yakakodzera yemigumisiro yakadaro.

Chisarudzo chechipiri uye Excel ichaisa zvinyorwa zvine dhiyabhorosi data pasi pemigumisiro yemhando - sezvinoitwa nemitambo yakakurumidza.

04 of 05

Kuronga Dhiyabhorosi Mazuva Evhiki kana Mwedzi muEexcel

Rongedza nemazuva evhiki kana kwemwedzi yegore uchishandisa imwechete yakagadzirirwa mumutsetse wekodzero iyo Excel inoshandisa kuwedzera mazuva kana mwedzi kushizha rinoshandisa kushandisa kuguta .

Aya mazita anobvumira kutarisa nemazuva kana mwedzi nguva yezvakanyorwa kwete pane zvinyorwa zvemafabheti.

Mumuenzaniso wepamusoro, deta yakarongwa nemwedzi apo vadzidzi vakatanga purogiramu yezvidzidzo.

Sezvimwe nezvimwe zvarudzo, kusarudza maitiro nemhando yemaitiro kunogona kuratidzwa mukukwira (Svondo kusvika Mugovera / January kusvika munaDecember) kana kuburuka kuronga (Mugovera kusvika Svondo / December kusvikira munaJanuary).

Mumufananidzo uri pamusoro apa, matanho anotevera akateverwa kuti agadzire sampuli yedhesi muhara yeH2 kusvika kuL12 nemwedzi yegore:

1. Simbisa mhando yemasero ekugadziriswa
2. Dzvanya paImba yebhu yebhoni .
3. Dzvanya paMhando & Firiza icon pane ribhoni kuti uzarure rondedzero.
4. Dzvanya pa Custom Custom Sort in the down down list to bring up the Sort dialog box
5. Pasi peColumn iri mubhokisi rebhokisi, sarudza Mwedzi Uchitanga kubva pakaderera pasi kuti uenzanise data nemwedzi yegore
6. Rudzi Rwakasarudzwa sarudzo yakasara rakatarirwa kuMaitiro - sezvo rudzi rwacho rwakavakirwa pamashoko chaiwo ari patafura
7. Pasi pemutsetse weGood Order , tsvaira pasi pasi petsva iri pedyo nekusarudzwa kweA kusvika kune Z kuti uzarure mamiriro ekuderera
8. Mune menyu, sarudza Custom List kuti uzarure Custom Lists dialog box
9. Muruwindo rworuboshwe rwebhokisi rebhokisi, tora kamwe chete pane zvakanyorwa: January, February, March, April ... kuti uchisarudze

10. Dzvanya OK kuti usimbise kusarudzwa uye dzokera kuChengetedza bhokisi rebhokisi

11. Tsanangudzo yakasarudzwa - January, February, March, April - icharatidzwa pasi peChirevo cheHurumende

12. Dzvanya OK kuti uvhare bhokisi rebhokisi uye sarudza data nemwedzi yegore

Cherechedza : Nekutadza, maitiro emhando anongoratidzwa chete mukukwira urongwa muList Lists dialog box. Kuti urongedze dhesiro muchibhururuka kuronga uchishandisa rwendo rwetsika mushure mokusarudza yaunoda kuti urarise kuitira kuti inoratidzwa pasi peChirongwa cheChirongwa muChirongwa chebhokisi yebhokisi:

1. Dzvanya pamusorosoro pasi pedyo neakaiswa urongwa - saJanuary, February, March, April ... kuti uzarure mhando inodonha
2. Mune menyu, sarudza tsika yakasarudzwa sarudzo iyo inoratidzwa mukudzika kwehurongwa - saDecember, November, Gumiguru, Svondo ...

3. Dzvanya OK kuti uvhare bhokisi rebhokisi uye sarudza dambudziko iri richidzika kuronga uchishandisa tsika yechirongwa

05 of 05

Rongedza Nzira dzekudzorerazve Columns mu Excel

Sezvinoratidzwa nemhando dzakasarudzwa dzinoshandiswa, data inowanzogadziriswa uchishandisa misoro yemusoro kana mazita emumunda uye chigumisiro ndechekudzokorora kwemitsara yose kana zvinyorwa zve data.

Izvo zvisingazivikanwi, uye naizvozvo, zvisarudzo zvisingashandiswi kushandiswa muExcel ndeyekugadzira nemuganhu, unova nemugumisiro wekugadzirisa zvakare urongwa hwemasumeri kubva kuruboshwe mune pepa rekushanda

Chimwe chikonzero chekutsvaga mumutsara ndechokufananidza nhaurirano yakarongwa pakati pematafura akasiyana e data. Nehurukuro kune imwechete yakasara kusvika kurongwa hwakarurama, zviri nyore kuenzanisa zvinyorwa kana kukopa nekufambisa data pakati pematafura.

Kugadzirisa maCorumn Order

Kazhinji, zvisinei, kuwana mapuranga mukurongeka kwakakodzera basa rakananga nekuda kwekukwanisa kwekukwira nekudzika kwezvinhu zvakasarudzwa zvekuita kwehutano.

Kazhinji, zvakakosha kushandisa tsika yakarongeka, uye Excel inosanganisira nzira dzokusarudza nesero kana fonti ruvara kana nemifananidzo yakagadzirisa mafashoni .

Izvi zvingasarudzwa, sezvinotsanangurwa pasi peji rino, zvichiri kushanda zvakaoma uye hazvisi nyore kushandisa.

Zvichida nzira iri nyore yekuudza Excel urongwa hwemutsara ndeyekuwedzera mutsara wepamusoro kana pasi pematafura epa data ane nhamba 1, 2, 3, 4 ... iyo inoratidza kurongeka kwemasumeri kubva kuruboshwe.

Kuronga nemitsara zvino inova chinhu chisinganzwisisi chekuenzanisa zvikamu zviduku kusvika kune zvakakura pamutsara une nhamba.

Kana imwe nguva yakagadzirwa, mutsara wakawedzerwa weunhamba unogona kubviswa nyore nyore .

Rongedza Rows Example

Muchidimbu chekushandisa chakashandiswa pane izvi zvakatevedzana pane zvakasarudzwa zveExcel, kadhi yeVadzidzi veIvadzidzi yakagara ichatanga kuruboshwe, inoteverwa neZita uye zvino inowanzo Age .

Muchiitiko ichi, sezvinoratidzwa mumufananidzo uri pamusoro, mazamu akadzorerwa kuitira kuti Purogiramu yePurogiramu ive yekutanga kuruboshwe ichiteverwa neMwedzi wakatanga , Zita, nezvimwe.

Aya matanho anotevera akashandiswa kushandura chikamu chekutarirwa kune izvo zvakaonekwa mumufananidzo uri pamusoro:

1. Isa mutsara usina chinhu pamusoro pemutsara une mazita emunda
2. Mutsara uyu mutsva, pinda nhamba dzinotevera dzakasara kusvika kurudyi kutangira
   chinyorwa H: 5, 3, 4, 1, 2
3. Simbisa rutivi rweH2 kusvika kune L13
4. Dzvanya paImba yebhu yebhoni .
5. Dzvanya paMhando & Firiza icon pane ribhoni kuti uzarure rondedzero.
6. Dzvanya pa Custom Custom Sort in the down-list list kuti uburise Hurongwa hwebhokisi yebhokisi
7. Pamusoro pebhokisi rebhokisi, chengetai pane Zvimwechete kuti uzarure Hurongwa Hwekugovera dialog box
8. Muchikamu cheAlternation chechipiri chebhokisi yebhokisi, tsvaga Ronga kurudyi kuruboshwe kuronga urongwa hwemapuranga kubva kuruboshwe mubasa
9. Dzvanya OK kuti uvhare bhokisi iri
10. Nekushandura kweAmi Orientation, iyo Column inotungamira muChirongwa dialog box inosvika kuRow
11. Pasi peRow rinotungamira, sarudza kugadzirisa neRow 2 - rutsara rine nhamba dzedzinza
12. Rudzi Rwakasarudzwa sarudzo rwasara rwuri kuVhu
13. Pasi peMutungamiri weChirongwa , sarudzai Dukuduku Kupfuura Dzemabhiza kubva pakaderera pasi kuronga mazita acho mumutsara 2 mukukwira urongwa
14. Dzvanya OK kuti uvhare bhokisi rebhokisi uye taura mapuranga akasiyiwa kurudyi ne nhamba mumutsara 2
15. Urongwa hwemashongwe hunofanira kutanga neChirongwa chinoteverwa neMwedzi wakatanga , Zita , nezvimwe.

Kushandisa Excel's Custom Sort Options kuti Udzose Columns

Sezvambotaurwa pamusoro apa, kana tsika dzedzinza dziripo muChirongwa chebhokisi rebhokisi muExcel, izvi zvingasarudzwa hazvisi nyore kushandisa kana zvasvika pakugadzirisa zvakare mapuranga mune pepa rekushanda.

Zvisarudzo zvekugadzira tsika yakarongeka yakarongeka iri muHutori dialog box ndeyekuti urongedze data ne:

• seroti
• font color
• icon

Uye, kunze kwekuti imwe nhare isati yave yakange iine mafashoni akasiyana-siyana akashandiswa - akadai semhando yakasiyana kana mavara emasero, iyo mafomati inoda kuwedzerwa kumasero ega ega mumuganhu mumwechete kuti imwe imwe yendarama ishandurwe.

Semuenzaniso, kushandisa mutsara wepavara kuti udzoke zvakare mapuranga mumufananidzo uri pamusoro

1. Dzvanya pazita rimwe nerimwe remunda uye shandura mutsetse wepavara kune umwe neumwe - zvakadai segurufu, ruvara, bhuruu, nezvimwewo.
2. MuChirongwa chebhokisi rebhokisi, sarudza Mararamiro pane zvaunogona kuisa Mavara
3. Mukurayira, shandisa manyore mazita emumunda mavara mavara kufanana neyodiwa ye column column
4. Mushure mekugadzira, shandisazve mavara emutauro wezita rimwe nerimwe