Indlela yokuAlfabhethi kwi-Excel

Hlela ulwazi ngokuchanekileyo njengoko ufuna

Iikholeji ezintle ze-Excel, imigqa edibeneyo kunye nokuhambelana nezinye iinkqubo ze-MS Office zenza ukuba kube ngumsebenzi olungeleyo wokungena nokugcina izintlu ezisekelwe kumbhalo. Xa unayo yonke loo ngcaciso ingenayo, ungayilungisa ukuze uhlangabezane neemfuno zakho ngaphandle kweefowuni ezimbalwa ze mouse.

Ukufunda indlela yokwenza i-alphabetize kwi-Excel kunye nezinye iindlela zokuhlenga itekisi kunokukugcina iitoni zexesha kwaye kukunikeze ukulawula ngaphezulu kwedatha ofuna ukuyisebenzisa.

Fumana amanqanaba malunga nonke iinguqulelo ze-Microsoft Excel kubandakanya i-2016, 2013, 2010, 2007 kunye no-2003 okanye ngaphambili kunye ne-Excel ye-Mac 2016, ngo-2011, 2008 no-2004. Unokwenza olunye uhlobo olusisiseko usebenzisa i-Excel online ne-Office 365.

Indlela yohlobo lweAlfabheti kwi-Excel

Indlela elula yokwenza i-alphabetize ikholomu kwi-Excel kukuba isebenze uhlobo lohlobo. Apho ufumana le nkalo kuxhomekeke kwiyiphi i-Excel oyisebenzisayo.

Kwi- Excel 2003 kunye no-2002 kwi-Windows okanye i-Excel 2008 no-2004 ye-Mac , landela la manqaku.

1. Qinisekisa ukuba akukho namaseli angenanto kwiluhlu.
2. Cofa kunaliphi iseli kwikholam ofuna ukuyihlela.
3. Khetha Idatha kwibar yomhla kwaye khetha uhlobo . Ibhokisi yencoko yencoko iya kuvulwa.
4. Khetha ikholomu ofuna ukuyifaka kwi-alphabetize kwibhokisi yohlobo , khetha ukwenyuka .
5. Cofa Kulungile ukuhlela uludwe lwe-alfabhethi.

Kwi- Excel 2016, 2013, 2010 no-2007 kwi-Windows; Excel 2016 no-2011 ye-Mac; kunye ne-Office Excel Online, ukukhetha kulula.

1. Qinisekisa ukuba akukho namaseli angenanto kwiluhlu.
2. Chofoza Uhlobo & Hlaziya kwicandelo loHlelo lwethebhu laseKhaya.
3. Khetha uhlobo lwe-A ukuya kwi-Z ukuze uluhlu lweelfabhethi lwakho.

Hlela uluhlu lweAlfabhethi ngamakholomu amaninzi

Ukuba ufuna u-alphabetize uluhlu lweeseli kwi-Excel usebenzisa iikholomu enye, uhlobo lwe-Sort uyenza ukuba wenze njalo, ngokunjalo.

Kwi- Excel 2003 kunye no-2002 kwi-Windows okanye i-Excel 2008 no-2004 ye-Mac , landela la manqaku.

1. Khetha zonke iiseli ofuna ukuzenza ngohlu lwe-alfabhethi ezimbini okanye ngaphezulu uluhlu kwibanga.
2. Khetha Idatha kwibar yomhla kwaye khetha uhlobo . Ibhokisi yencoko yencoko iya kuvulwa.
3. Khetha ikholam yokuqala ofuna ukuyifumanisa idifayile kwiBhokisi yoHlelo uze ukhethe Ukunyuka .
4. Khetha ikholomu yesibini ofuna ukuyilungisa uluhlu lweeseli kwiWindows. Unokwenza uhlele kwiikholam ezintathu.
5. Khetha inkinobho yomsakazo ye- Header Row ukuba uluhlu lwakho luba nekhanda phezulu.
6. Cofa Kulungile ukuhlela uludwe lwe-alfabhethi.

Kwi- Excel 2016, 2013, 2010 kunye no-2007 kwi-Windows okanye i-Excel 2016 no-2011 ye-Mac, ukukhetha ukulula kulula. (Le nto ayitholakali kwi-Office 365 Excel Online.)

1. Khetha zonke iiseli ofuna ukuzenza ngohlu lwe-alfabhethi ezimbini okanye ngaphezulu uluhlu kwibanga.
2. Chofoza Uhlobo & Hlaziya kwicandelo loHlelo lwethebhu laseKhaya.
3. Khetha Uhlobo oluhle . Ibhokisi yencoko yencoko iya kuvulwa.
4. Khetha I- Data Yakho Inamakhanda abhekishe ibhokisi ukuba uluhlu lwakho luba neentloko phezulu.
5. Khetha ikholam yokuqala oyifunayo ukuba uyi-alphabeti idatha kwi Hlela ngebhokisi.
6. Khetha Iimpawu zeeSeli kwiBhokisi lokuLungiselela.
7. Khetha i- A ukuya kwi-Z kwibhokisi le-oda.
8. Ncofa iqhosha le- Add Level phezulu kwibhokisi yencoko.
9. Khetha ikholomu yesibini ofuna ukuyifumatha i-alphabetize idatha kwiBhokisi lohlobo.
10. Khetha Iimpawu zeeSeli kwiBhokisi lokuLungiselela.
11. Khetha i- A ukuya kwi-Z kwibhokisi le-oda.
12. Nqakraza iNqanaba lokuNgezelela ukuhlenga kwelinye ikholomu, ukuba ufuna. Cofa kwi- OK xa ulungele ukufakela i-alphabetize itafile yakho.

Uhlobo oluphambili kwi-Excel

Kwiimeko ezithile, ukukhetha i-alfabhethi nje ayiyi kwenza. Ngokomzekelo, unokufumana uluhlu olude oluqulethwe ngamagama eenyanga okanye ngeveki ongathanda ukuhlaziya ngokulandelana kwazo. I-Excel iya kuthatha le nto kuwe, ngokunjalo.

Kwi- Excel 2003 kunye no-2002 kwi-Windows okanye i-Excel 2008 no-2004 ye-Mac , khetha uluhlu ofuna ukuluhlela.

1. Khetha Idatha kwibar yomhla kwaye khetha uhlobo . Ibhokisi yencoko yencoko iya kuvulwa.
2. Cofa iqhosha lokukhetha phantsi kwebhokisi yencoko.
3. Cofa umcibisholo ohlahlayo kwicandelo lokuQala loLwimi oluQhosha oluQhosha kwaye ukhethe uhlobo olukhethiweyo ofuna ukuyisebenzisa.
4. Cofa kwi- OK ngokuphindwe kabini ukuhlela uluhlu lwakho ngokulandelana.

Kwi- Excel 2016, 2013, 2010 okanye 2007 kwi-Windows kunye ne-Excel 2016 no-2011 ye-Mac, khetha uluhlu ofuna ukuluhlela. ukukhetha kulula. (Le nto ayitholakali kwi-Office 365 Excel Online.)

1. Chofoza Uhlobo & Hlaziya kwicandelo loHlelo lwethebhu laseKhaya.
2. Khetha Uhlobo oluhle . Ibhokisi yencoko yencoko iya kuvulwa.
3. Cofa umgca wokuhlahlaya kwiluhlu lweNqununu uze ukhethe uLuhlu lwangokwezifiso . Incoko yababini yoLwimi iya kuvula.
4. Khetha uhlobo olukhethiweyo ofuna ukuyisebenzisa.
5. Cofa kwi- OK ngokuphindwe kabini ukuhlela uluhlu lwakho ngokulandelana.

Ngaphezulu Uhlobo Lwezinto

I-Excel inikezela iindlela ezininzi zokungena, ukuhlela kunye nokusebenza kunye naluphina uhlobo lweedatha. Hlola iindlela ezi- 6 zokuhlela i-Data kwi-Excel ukuze ufumane iingcebiso kunye nolwazi oluncedo.