Nzira Yokufambisa Alfabhetize muExcel

Rongedza ruzivo sezvaunoda

Excel's neat columns, mizere yakajeka uye inoenderana nemamwe mapurogiramu e MS Office inoita kuti ive yakakodzera yekupinda nekuchengetedza zvinyorwa zvakanyorwa. Kana uchinge uine ruzivo rwese rwunopinda, unogona kuaronga kuti ruzadzise zvido zvako pasina zvinopfuura zvishomanana zvekipi.

Kudzidza kufanana neAlfabhethize muExcel pamwe nemamwe nzira yekugadzirisa mavara kunogona kukuchengetedza tani yenguva uye kukupa zvakanyanya kudarika dhesi raunoda kushandisa.

Tsvaga matanho ekutenderera shanduro dzose dzeMicrosoft Excel kusanganisira 2016, 2013, 2010, 2007 uye 2003 kana yapfuura pamwe neExcel for Mac 2016, 2011, 2008 uye 2004. Unokwanisa kuita zvimwe zvekushandisa uchishandisa Excel online neHof 365.

Nzira Yokugadzira Nhamba Yemabhadhiri muEccel

Nzira yakajeka yeaibhabhetiti yendarama muExcel ndiyo kushandisa sarudzo. Kwamunoona ichi chiitiko chinoenderana neshanduro ye Excel yauri kushandisa.

MuExcel 2003 uye 2002 yeWindows kana Excel 2008 uye 2004 ye Mac , tevera matanho aya.

1. Iva nechokwadi chekuti hapana mavharegi asina kuwanikwa mune urongwa.
2. Dzvanya pane chero sero iri mumutsara yaunoda kuronga.
3. Sarudza Dhavhidha pane toolbar uye sarudza Zita. The Sort dialog box ichazarura.
4. Sarudza iyo koromo yaunoda kuti uite alphabtize muChirongwa nebhokisi, sarudza Kukwira .
5. Dzvanya OK kuti ureruke runyora.

In Excel 2016, 2013, 2010 uye 2007 yeWindows; Excel 2016 uye 2011 yeMac; uye Office Excel Online, kusarudza zvakajeka zvakare.

1. Iva nechokwadi chekuti hapana mavharegi asina kuwanikwa mune urongwa.
2. Dzvanya Tonga & Futa muChirongwa chekugadzirisa cheItabhenakeri.
3. Sarudza Ronga A kusvika Z kuti uite alphabtize rako.

Rongedza maArabbeti neMawanda Ma Columns

Kana iwe uchida kuisa mafurafiti emhando yemasero muEexcel uchishandisa yakawanda pane imwe yendarama, Mhando yakarongwa inoita kuti iwe uite saizvozvo, zvakare.

MuExcel 2003 uye 2002 yeWindows kana Excel 2008 uye 2004 ye Mac , tevera matanho aya.

1. Sarudza ose emasero ayo waunoda kuronga nekunyora mazita ehefabheti maviri kana kupfuura pane urwu.
2. Sarudza Dhavhidha pane toolbar uye sarudza Zita. The Sort dialog box ichazarura.
3. Sarudza chinyorwa chekutanga chaunoda kuisa mafirofti yedhadharo muChirongwa nebhokisi uye sarudza Kukwira .
4. Sarudza ronda rwechipiri raunoda kutarisa mararamiro emasero muIpapo nerwendo. Unogona kutarisa kusvika pamatatu matatu.
5. Sarudza Musoro weRower Row redhiyo kana yako yakanyorwa ine musoro kumusoro.
6. Dzvanya OK kuti ureruke runyora.

MuEccel 2016, 2013, 2010 uye 2007 yeWindows kana Excel 2016 uye 2011 yeMac, kusarudza zvakajeka zvakare. (Izvi hazviwanike muHofisi 365 Excel Online.)

1. Sarudza ose emasero ayo waunoda kuronga nekunyora mazita ehefabheti maviri kana kupfuura pane urwu.
2. Dzvanya Tonga & Futa muChirongwa chekugadzirisa cheItabhenakeri.
3. Sarudza Maitiro Akarongwa . A Sort dialog box ichazarura.
4. Sarudza Dhiyabhorosi Yangu Ane Headers chengetedza bhokisi kana mazita ako ane zvinyorwa kumusoro.
5. Sarudza chinyorwa chekutanga chaunoda kunyora mafiropu mukati maro Ronga nebhokisi.
6. Sarudza Maitiro Emunharaunda Mukuronga Pabhokisi.
7. Sarudza A kusvika kuZ mubhokisi rekuda.
8. Dzvanya bhodhi yeAd Add Level kumusoro kwebhokisi rebhokisi.
9. Sarudza kora yechipiri iyo iwe unoda kuisa mafirofti yedheta muChirongwa nebhokisi.
10. Sarudza Maitiro Emunharaunda Mukuronga Pabhokisi.
11. Sarudza A kusvika kuZ mubhokisi rekuda.
12. Dzvanya Adhamu Nhamba yekutarisana neimwe imwe koromo, kana uchida. Dzvanya OK apo wakagadzirira kuverenga alphafeta tafura yako.

Yakagadziridza Kuronga mu Excel

Mune mamwe mamiriro ezvinhu, kuisa mazita echifabheti hazvizoiti. Semuenzaniso, iwe unogona kunge uine runyora rurefu rine mazita emwedzi kana masvondo ayo waunoda kuronga nguva. Excel ichakutora izvi iwe, zvakare.

MuExcel 2003 uye 2002 yeWindows kana Excel 2008 uye 2004 yeMac , sarudza urongwa hwaunoda kuronga.

1. Sarudza Dhavhidha pane toolbar uye sarudza Zita. The Sort dialog box ichazarura.
2. Dzvanya Bhokisi reKutora pasi pebhokisi rebhokisi.
3. Dzvanya mutsara wokudonhedzwa muChino Chokutanga Sort Order list uye sarudza sarudzo yaunoda kushandisa.
4. Dzvanya OK kaviri kuti uenzane nenyaya yako chronologically.

MuEccel 2016, 2013, 2010 kana 2007 yeWindows neExcel 2016 ne2012 yeMac, sarudza urongwa hwaunoda kuronga. Kuronga kuri nyore zvakare. (Izvi hazviwanike muHofisi 365 Excel Online.)

1. Dzvanya Tonga & Futa muChirongwa chekugadzirisa cheItabhenakeri.
2. Sarudza Maitiro Akarongwa . The Sort dialog box ichazarura.
3. Dzvanya mutsara wokudonhedzwa muIndaneti urongwa uye sarudza Custom List . Mhando yeList Lists ichazarura.
4. Sarudza rudzi rwaunosarudza kushandisa.
5. Dzvanya OK kaviri kuti uenzane nenyaya yako chronologically.

Kunyange Mamwe Mhando Zvekare

Excel inopa nzira dzakawanda dzekupinda, kuronga nekushanda pamwe nemhando ipi zvayo ye data. Tarisa 6 Nzira dzekugadzirisa Dhina muExcel kune mamwe mazano anobatsira uye ruzivo.