Marka aad rabto in aad alifbeetada ku qorto Excel^(Excel) , haddii ay tahay in la kala saaro tiir ama saf, nidaamku inta badan waa mid toos ah. Si kastaba ha ahaatee, marka ay timaaddo alifbeetada samaynta safaf badan ama tiirar, ama la macaamilka xarfaha iyo nambarada, nidaamku wuxuu u baahan karaa dhowr tillaabo oo dheeraad ah.

Maqaalkan waxaad ku baran doontaa wax kasta oo aad u baahan tahay inaad ka ogaato sida loo alifbeetada xogtaada ku jirta xaashida Excel .

Ku qor xarfaha Excel oo leh kala soocida

Habka aad u isticmaashid alifbeetada Excel waxay kuxirantahay inta tiir ama saf ay ku jiraan xogta aad rabto inaad habayso.

Kala soocida hal tiir oo xogta ah qaab alifbeeto ah ayaa ugu fudud. Haddii aad leedahay tiirar badan oo aad rabto inaad hubiso dhammaan xariiqyada xogta ee leh tiirka alifbeetada, waxaa jira dhowr tillaabo oo dheeri ah.

Ugu dambeyntii, waxaa jira tixgalin gaar ah oo maskaxda lagu hayo haddii aad rabto inaad kala soocdo tiirar badan, iyo haddii xogtu leedahay saf madax iyo in kale.

Guud ahaan

Habka ugu fudud ee lagu alifbeetada Excel waa haddii aad leedahay hal tiir oo xog ah. Tusaale ahaan, haddii aad leedahay tiir leh liis magacyo ah. 

1. Dooro tiirka xogta.

2. Dooro menu -ka guriga , oo dooro ^(Home)kala soocida &^{(Sort & Filter)} shaandhaynta hoos u dhaca ee kooxda tafatirka^(Editing) ee ribbon.

3. Dooro kala sooc A ilaa Z^{(Sort A to Z)} ama U kala sooc Z ilaa A^{(Sort Z to A)} iyadoo ku xidhan sida aad u habayn lahayd xogta^{(organize the data)} .

Hadda, markaad dib u milicsato tiirka aad iftiimisay, waxaad arki doontaa in xogta halkaas ku jirta loo kala soocay hab alifbeeto ah iyadoo la isticmaalayo habka aad dooratay.

Maxaa dhacaya haddii xogtaadu leedahay nambaro? Tusaale ahaan, aan nidhaahno waxaad haysaa tiir labaad oo leh da'da qof kasta.

Waxaad doonaysaa inaad kala soocdo tiirkaas, si aad u raacdo isla nidaamka kor ku xusan oo aad doorato tiirka xogta.

Markan, marka aad doorato Kala^(Sort) -soocida & Shaandhaynta^(Filter) ribbon, waxaad arki doontaa in xulashada sida loo kala saaro ay isbeddeleen.

Ikhtiyaaradani waxay kala sooci doonaan tirooyinka min tirada ugu yar ilaa kan ugu weyn, ama si kale.

Kala-soocidda tiirar badan

Waxaa jira hal dhib ah oo ku saabsan kala soocida tiirarka shakhsi ahaan shaxda oo ka kooban tiirar badan^{(that contains multiple columns)} oo xog ah. 

Haddii aad doorato hal tiir oo aad kala soocdo, tiirarka kale way sii jiraan. Tani waxay ka dhigan tahay xaashida xisaabaadkaaga ayaa dhammaan doona isku qasan oo xogtu hadda ka dib macno samayn mayso. Jawaabta tan waa in la kala saaro dhammaan tiirarka hal mar.

Aan ku samayno tan mar kale xaashida tusaalaha da'da ee magaca iyo da'da.

1. Markan, halkii aad ka dooran lahayd hal tiir, dooro shaxda oo dhan.

2. Menu -ga guriga , ka dooro ^(Home)kala soocida & shaandhaynta^{(Sort & Filter)} , oo sidii hore, dooro nooca dookhaaga.

Hadda, waxaad arki doontaa in aan magacyada lagu kala soocin oo keliya xaashida xaashida ee Excel , laakiin da'aha la xidhiidha tiirka labaad ayaa la soocay iyaga. Da'daas waxay la haayeen magaca saxda ah.

Tani kuma shaqeyneyso oo kaliya laba xaashida tiir ee Excel , laakiin way shaqeyn doontaa iyada oo aan loo eegin inta uu le'eg yahay xaashida xaashida, ilaa inta aad doorato dhammaan xogta xaashida ka hor inta aanad kala soocin.

Haddii aad rabto, waxa kale oo aad u kala sooci kartaa tiirar badan oo mid ka mid ah^{(sort multiple columns into one)} , ka dibna aad u kala sooci kartaa hal tiir.

Habka gaarka ah

Waxaad ku arki doontaa ikhtiyaar kale oo ku jira kala soocida^(Sort) & shaandhaynta^(Filter) liiska hoos u dhaca waa Kala-soocida Gaarka^{(Custom Sort)} ah .

Si aan u aragno sida tani u shaqeyso, aan soo qaadanno xaashida faafinta oo aad uga weyn tusaale ahaan. Xaashida faafinta ee tusaalahan waa liiska buundooyinka SAT ee dugsiyada sare ee gobolka New York . 

1. Dooro shaxanka xogta oo dhan ee xaashida faafinta, dooro menu -ka guriga , dooro ^(Home)Kala-soocida & Shaandhaynta^{(Sort & Filter)} , oo dooro Kala-soocida Habboon^{(Custom Sort)} .

2. Waxaad arki doontaa pop-up cusub oo soo baxay halkaas oo aad ka dooran kartaa sida tiir kasta si gaar ah loo soocay. Dooro tiirka aad rabto in aad u kala soocdo, dooro habka aad doonayso in aad u habayso, ka dibna dooro habka aad u kala saarayso (A ilaa Z, Z ilaa A, ama Custom ).

Waxaad ogaan doontaa inay jiraan xulashooyin kala-soocidda oo xiiso leh. ^{(Sort On)}Kuwani waa:

• Qiimaha Unug^{(Cell Values)} : U kala sooc alifbeetada, ama xaalad tirooyinka, hoose ilaa sare ama sare ilaa hoose
• Midabka unugga^{(Cell Color)} : Habbee xogta oo loo qaybiyey midabka unugga
• Midabka Font^{(Font Color)} : Abaabulaan xogta lagu ururiyay midabka font
• Astaanta Qaabaynta Shuruudaha^{(Conditional Formatting Icon)} ah: Ku habbee xogta summada unugga ku jirta macquul ahaan qaabaynta shuruudaha

Tani waxay u kala saaraysaa shaxda xogta oo dhan tiirka kowaad ee aad dooratay. Laakiin sidoo kale waxaad samayn kartaa nooc labaad (marka tiirka ugu horreeya ee la doortay la kala saaro).

Kaliya dooro Heerka Ku dar^{(Add Level)} . Laga soo bilaabo meelaha cusub ee soo muuqda, dooro tiirka^(Column) , Kala soocida^(Sort) , oo dalbo^(Order) hoos u dhaca mar labaad sida la rabo.

Dooro OK oo waxaad arki doontaa in miiskaaga oo dhan hadda loo kala soocay tiirar badan. 

Waxay marka hore u kala sooci doontaa tiirka hore ee aad dooratay, ka bacdina kan labaad, kan saddexaad, iyo wixii la mid ah.

Fiiro gaar^(Note) ah: Waxaa laga yaabaa inaad dareentay in kala-soocidda tiirka ee hoos-u-dhaca sare ay ku jiraan magacyada madaxa ee aan ahayn xarfo. Tani waa sababta oo ah sanduuqa hubinta ee ku xiga xogtaydu waxay leedahay madax^{(My data has headers)} daaqadaha la doortay. Haddii xaashida faafintaadu leedahay madax, hubi inaad tan doorato.

Alifbeetada ku dheji Excel oo leh Filter

Markaad isticmaalayso kala soocida^(Sort) iyo kala soocida hoos udhaca guriga^(Home) , waxaa laga yaabaa inaad dareentay inay sidoo kale jirto ikhtiyaarka^(Filter) Filter .^(Filter)

Haddii aad tan doorato, waxaad ogaan doontaa fallaadhaha hoos u dhaca oo ka muuqda xagga sare ee tiir kasta. Markaad doorato mid ka mid ah fallaadhaha ku yaal xagga sare ee mid ka mid ah tiirarkaas, waxaad arki doontaa liis dheer oo xulasho ah.

Waa kan sida mid kasta oo ka mid ah doorashooyinkan u shaqeeyo:

• U kala sooc A ilaa Z^{(Sort A to Z)} ama U kala sooc Z ilaa A^{(Sort Z to A)} : U kala sooc xaashida addoo tiirkan alifbeetada u kala sooc labada dhinac.
• Ku kala soocida Midabka^{(Sort by Color)} : Tani waxay soo saari doontaa isla daaqada kala soocida tiirarka badan ee qaybta u dambaysa ee sare.

Xulashooyinka kale ee shaandhaynta ee hoose kuma caawin doonaan inaad ku qorto Excel^(Excel) , laakiin waxaa jira xulashooyin badan oo aad ku shaandheyn karto xogta aadan dan ka lahayn. Markaad dooratid filtarrada qoraalka^{(Text Filters)} , waxaad dooran kartaa inaad kaliya ku muujiso xogta xaashida:

• Waxay la mid^(Equals) tahay qiimo gaar ah
• Uma eka^{(Does Not Equal)} qiimo gaar ah
• Wuxuu ku bilaabmaa^{(Begins With)} kelmad ama lambar
• Ku dhammaata^{(Ends With)} kelmad ama lambar
• Ka kooban^(Contains) yahay kelmad ama lambar
• Kuma koobna^{(Does Not Contain)} kelmad ama lambar
• Shaandheeyaha gaarka^{(Custom Filter)} ah wuxuu kuu ogolaanayaa inaad isku geyso mid ka mid ah filtarrada sare si aad u isticmaasho filtarrada badan

Sida aad arki karto, waxaa jira habab badan oo lagu alifbeeto (ama lagu dalbo tirooyinka) gudaha Excel . Xulashada aad dooratay runtii waxay kuxirantahay inta xogta aad rabto inaad kala soocdo, inta uu le'eg yahay miiska aad rabto inaad kala soocdo, iyo haddii aad rabto inaad ku kala saarto hal tiir ama saf, ama mid badan.

Baro wax badan oo ku saabsan tabaha iyo tabaha kala duwan ee Excel^{(tips and tricks for Excel)} , oo la wadaag farsamo kasta oo kale oo aad ka taqaano si aad u kala saarto safafkaaga iyo tiirarka Excel .

How to Alphabetize In Excel

When you want to alphabetize in Excel, whether it’s to sort а column or a row, the process is usuаlly straightforward. However, whеn it comes to alphabеtizing multiplе rows or columns, or dealing wіth letters and numbers, the procesѕ may require a few extra steps.

In this article you’ll learn everything you need to know about how to alphabetize your data in an Excel spreadsheet.

Alphabetize In Excel With Sort

The method you use to alphabetize in Excel depends on how many columns or rows contain the data that you want to organize.

Sorting a single column of data alphabetically is the easiest. If you have multiple columns and want to make sure all of the data lines up with the alphabetized column, there are a few extra steps.

Finally, there are special considerations to take in mind if you want to sort multiple columns, and whether the data has a header row or not.

General

The simplest method to alphabetize in Excel is if you have one column of data. For example, if you have a column with a list of names. 

1. Select the column of data.

2. Select the Home menu, and select the Sort & Filter dropdown in the Editing group on the ribbon.

3. Select either Sort A to Z or Sort Z to A depending how you’d like to organize the data.

Now, when you look back at the column you highlighted, you’ll see that the data there has been sorted alphabetically using the method you chose.

What if your data has numbers? For example, let’s say you have a second column with the ages of each person.

You want to sort that column, so you follow the same procedure as above and select the column of data.

This time, when you select Sort & Filter on the ribbon, you’ll see that the selections for how to sort have changed.

These options will either sort the numbers from the smallest number to the largest, or the other way around.

Multi-Column Sorting

There is one problem with sorting columns individually in a table that contains multiple columns of data. 

If you only select one column and sort it, the other columns stay in place. This means your spreadsheet would get all mixed up and the data would no longer make sense. The answer to this is to sort all of the columns at once.

Let’s do this again with the name and age example spreadsheet.

1. This time, instead of selecting a single column, select the entire table.

2. In the Home menu, select Sort & Filter, and just as before, select your sort preference.

Now, you’ll see that not only have the names been sorted alphabetically in your Excel spreadsheet, but the associated ages from the second column sorted along with them. Those ages stayed with the correct name.

This works not only with a two column spreadsheet in Excel, but it’ll work regardless how large your spreadsheet is, so long as you select all of the data in the sheet before sorting.

If you wanted to, you could also sort multiple columns into one, and then sort that single column instead.

Custom Sort

You’ll notice another option in the Sort & Filter dropdown menu is the Custom Sort.

To see how this works, let’s take a much larger spreadsheet as an example. The spreadsheet in this example is a list of SAT scores for high schools in the state of New York. 

1. Select the entire table of data in the spreadsheet, select the Home menu, select Sort & Filter, and select Custom Sort.

2. You’ll see a new pop-up appear where you can select how each column is specifically sorted. Select the column you want to sort by, select how you want to sort it, and then select how you want to sort it (A to Z, Z to A, or Custom).

You’ll notice there are some interesting Sort On choices. These are:

• Cell Values: Sort alphabetically, or in the case of numbers, from low to high or high to low
• Cell Color: Organize data grouped by cell color
• Font Color: Organize data grouped by font color
• Conditional Formatting Icon: Organize data by the icon in the cell from its conditional formatting logic

This will sort the entire table of data by the first column you’ve selected. But you can also do a secondary sort (once the first selected column is sorted).

Just select Add Level. From the new fields that appear, select the Column, Sort On, and Order dropdowns again as desired.

Select OK and you’ll see your entire table is now sorted by multiple columns. 

It’ll sort first by the initial column you selected, then the second, the third, and so on.

Note: You might have noticed that the column sort options in the dropdown above included the header names rather than letters. This is because the checkbox next to My data has headers in the sort window is selected. If your spreadsheet does have headers, make sure to select this.

Alphabetize In Excel With Filter

While using the Sort & Filter dropdown in the Home menu, you might have noticed there’s also a Filter option.

If you select this, you’ll notice dropdown arrows appear at the top of each column. When you select one of the arrows at the top of any of those columns, you’ll see a long list of options.

Here is how each of these options works:

• Sort A to Z or Sort Z to A: Sort the sheet using this column alphabetically in either direction.
• Sort by Color: This will bring up the same multi-column sort window as in the last section above.

The other filtering options at the bottom won’t help you to alphabetize in Excel, but there are lots of options to filter out data you don’t care about. When you select Text Filters, you can choose to only display data in the sheet that:

• Equals a specific value
• Does Not Equal a specific value
• Begins With a word or number
• Ends With a word or number
• Contains a word or number
• Does Not Contain a word or number
• Custom Filter lets you combine any of the filters above to use multiple filters

As you can see, there are a lot of ways to alphabetize (or order numbers) in Excel. The option you choose really depends how much data you want to sort, how large the table is that you want to sort, and whether you want to sort by only one column or row, or multiple ones.

Learn more about different tips and tricks for Excel, and share any other techniques you know about to sort your rows and columns in Excel.

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Ku xidhida Excel iyo MySQL

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• 5 siyaabood oo loogu badalo qoraalka nambarada gudaha Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Waa maxay sababta ay tahay inaad u isticmaasho safafka la magacaabay ee Excel

• Sida loo qoro IF Formula/Bayaanka gudaha Excel