Indlela Yokubhala Nge-Alphabet ku-Excel

Hlunga ulwazi ngendlela oyifunayo ngayo

Amakholomu afanelekile e-Excel, imigqa ehambisanayo nokuhambisana namanye amahlelo we-MS Office enza kube uhlelo lokusebenza oluhle lokungena nokugcina uhlu olusekelwe ematheksthini. Uma usungenayo yonke imininingwane, ungayilandela ukuze uhlangabezane nezidingo zakho ngaphandle kokuchofoza okumbalwa kwegundane.

Ukufunda ukuthi u-alphabetize kanjani ku-Excel kanye nezinye izindlela zokuhlunga umbhalo kungakusiza amathani wesikhathi futhi kukunikeze ukulawula okungaphezulu kwedatha oyidingayo ukuyisebenzisa.

Thola izinyathelo cishe kuzo zonke izinhlobo ze-Microsoft Excel kuhlanganise no-2016, 2013, 2010, 2007 no-2003 noma ngaphambili kanye ne-Excel ye-Mac 2016, 2011, 2008 no-2004. Ungenza ngisho nokukhetha okuyisisekelo usebenzisa i-Excel online ne-Office 365.

Indlela Yokuhlela U-Alphabeti ku-Excel

Indlela elula yokwenza i-alphabetize ikholomu ku-Excel ukusebenzisa i-Sort Sort. Lapho uthola khona lesi sici kuncike kunguphi uhlobo lwe-Excel oyisebenzisayo.

Ku- Excel 2003 no-2002 ye-Windows noma i-Excel 2008 no-2004 ye-Mac , landela lezi zinyathelo.

1. Qinisekisa ukuthi awekho amangqamuzana angenalutho ohlwini.
2. Chofoza kunoma iyiphi iseli kukholomu ofuna ukuyihlunga.
3. Khetha Idatha kubha yamathuluzi bese ukhetha Hlunga . Ibhokisi lebhokisi lengxoxo lizovuleka.
4. Khetha ikholomu ofuna ukuyi-alphabeti ebhokisini loHlelo , khetha ukukhuphuka .
5. Chofoza OK ukuze uhlele uhlu lwama-alfabhethi.

Ku- Excel 2016, 2013, 2010 no-2007 ye-Windows; I-Excel 2016 no-2011 ye-Mac; kanye neHhovisi Excel Online, ukukhetha kulula futhi.

1. Qinisekisa ukuthi awekho amangqamuzana angenalutho ohlwini.
2. Chofoza Uhlobo & Hlunga kusigaba sokuhlela sethebhu yasekhaya.
3. Khetha u- A ukuya ku-Z ukuze u-alphabetize uhlu lwakho.

Hlunga ngo-Alfabhethi ngamakholomu amaningi

Uma ufuna ukwenza i-alphabetize ububanzi bamaseli ku-Excel usebenzisa ikholomu engaphezu kweyodwa, ukuhlelwa kohlelo kukuvumela ukuba wenze kanjalo, futhi.

Ku- Excel 2003 no-2002 ye-Windows noma i-Excel 2008 no-2004 ye-Mac , landela lezi zinyathelo.

1. Khetha wonke amaseli ofuna ukuwahlela ngokubhala ngama-alfabhethi amabili noma ngaphezulu ohlwini.
2. Khetha Idatha kubha yamathuluzi bese ukhetha Hlunga . Ibhokisi lebhokisi lengxoxo lizovuleka.
3. Khetha ikholomu oyinhloko ofuna ukuyifaka ngayo i-alphabeti yedatha ebhodini lokuHlunga bese ukhetha Ukukhuphuka .
4. Khetha ikholomu yesibili ofuna ukuhlunga ububanzi bamaseli kuLowo ohlwini. Ungakwazi ukuhlela ngamakholomu amathathu.
5. Khetha inkinobho yomsakazo we- Header uma uhlu lwakho lunenhloko phezulu.
6. Chofoza OK ukuze uhlele uhlu lwama-alfabhethi.

Ku- Excel 2016, 2013, 2010 no-2007 ye-Windows noma i-Excel 2016 no-2011 ye-Mac, ukukhetha kulula futhi. (Lesi sici asitholakali ku-Office 365 Excel Online.)

1. Khetha wonke amaseli ofuna ukuwahlela ngokubhala ngama-alfabhethi amabili noma ngaphezulu ohlwini.
2. Chofoza Uhlobo & Hlunga kusigaba sokuhlela sethebhu yasekhaya.
3. Khetha Uhlobo Oluhlelekile . Ibhokisi lebhokisi lengxoxo lizovuleka.
4. Khetha Idatha Yami Inamakhanda ahlole ibhokisi uma izinhlu zakho zinamakhanda phezulu.
5. Khetha ikholomu oyinhloko ofuna ukuyifaka ngayo i-alphabeti idatha Hlunga Ngebhokisi.
6. Khetha ama- Cell Value kuBhokisi lokuHlunga.
7. Khetha i- A kuya ku-Z ebhokisini le-oda.
8. Chofoza inkinobho ye- Add Level phezulu kwebhokisi lengxoxo.
9. Khetha ikholomu yesibili ofuna ukuyifaka ngayo i-alphabeti yedatha ebhokisini lokuhlunga.
10. Khetha ama- Cell Value kuBhokisi lokuHlunga.
11. Khetha i- A kuya ku-Z ebhokisini le-oda.
12. Chofoza Engeza I-Level ukuze uhlele ngezinye ikholomu, uma ufisa. Chofoza u- OK uma usulungele ukwenza i-alphabetize itafula lakho.

Ukuhlelwa Okuthuthukisiwe ku-Excel

Ezimweni ezithile, ukukhetha u-alfabhethi ngeke nje kwenzeke. Isibonelo, ungase ube nohlu olude oluqukethe amagama ezinyanga noma izinsuku ongathanda ukuzihlunga ngokulandelana kwesikhathi. I-Excel izobhekana nalokhu kuwe, futhi.

Ku- Excel 2003 no-2002 ye-Windows noma i-Excel 2008 no-2004 ye-Mac , khetha uhlu ofuna ukuluhlunga.

1. Khetha Idatha kubha yamathuluzi bese ukhetha Hlunga . Ibhokisi lebhokisi lengxoxo lizovuleka.
2. Chofoza inkinobho yezinketho phansi kwebhokisi lengxoxo.
3. Chofoza umcibisholo wokudonsela phansi ohlwini lwe-First Key Sort Order bese ukhetha inketho yohlobo ofuna ukuyisebenzisa.
4. Chofoza KULUNGILE kabili ukuhlunga uhlu lwakho ngokulandelana kwesikhathi.

Ku- Excel 2016, 2013, 2010 noma 2007 ye-Windows ne-Excel 2016 no-2011 ye-Mac, khetha uhlu ofuna ukuluhlunga. ukuhlunga kulula futhi. (Lesi sici asitholakali ku-Office 365 Excel Online.)

1. Chofoza Uhlobo & Hlunga kusigaba sokuhlela sethebhu yasekhaya.
2. Khetha Uhlobo Oluhlelekile . Ibhokisi lebhokisi lengxoxo lizovuleka.
3. Chofoza umcibisholo wokudonsa ohlwini lohlu bese ukhetha Uhlu Lwezifiso . I-dialog Lists dialog izovuleka.
4. Khetha inketho uhlobo ofuna ukuyisebenzisa.
5. Chofoza KULUNGILE kabili ukuhlunga uhlu lwakho ngokulandelana kwesikhathi.

Ngisho nezici eziningi zohlobo

I-Excel inikeza izindlela eziningi zokungena, ukuhlela nokusebenza cishe noma yiluphi uhlobo lwedatha. Hlola izindlela ezingu-6 zokuhlela idatha ku-Excel ukuze uthole amathiphu kanye nolwazi oluwusizo.