Laba ka mid ah hawlaha aasaasiga ah ee Excel waa inay kuu oggolaadaan inaad wax ka beddesho oo aad xogta ka aragto dhinacyo kala duwan, mid ka mid ah barnaamijyada fudud laakiin qalabka ugu awoodda badan ee sidaas lagu sameeyo waa shaqada Kala^{(Sort )} -soocidda .

Haddi ay tahay fudeyd kor u kaca/socod, kala soocida wax ka badan hal doorsoome si loo soo bandhigo xogta kooxaha ama si loo ilaaliyo daacadnimada safka, ama noocyada alfanumeric fudud si xogtaada jaantuska loo ilaaliyo, kala soocida xogta Excel waa xirfad lagama maarmaan ah.

Barnaamijyo yar ayaa ku habboon kala soocida xogta shaxda marka loo eego Excel , noocyadaagana waxay ka socon karaan kuwa fudud oo aan yarayn oo aad u casrisan. Inkasta oo karti-soocidda Excel -waxa aad ku samayn karto xogta saxda ah ee saxda ah iyo aqoonta yar ee hawlaha gudaha ee barnaamijka-runtii waa mid adag oo qoto dheer, tignoolajiyada maanta waxay diiradda saaraysaa laba nooc oo asaasi ah, sida soo socota:

• Kala soocida xogta hal tiir
• Kala soocida xogta tiirar badan

Xaashiyaha faafintu, dabcan, waxay ka kooban yihiin tiirar iyo saf unugyo ah, ama xog taxan, halkaasoo tiir kastaa ka kooban yahay qayb macquul ah oo xaqiiqo ah, tirooyin, ama faahfaahin kasta oo kale qayb ahaan, sida, tidhaah, magacyo, cinwaanno, lacag, qaybo tirooyinka, iyo wixii la mid ah-waxay kuxirantahay nooca xaashida. Safka^(Rows) , dhanka kale, waxay soo bandhigayaan dadka, walxaha, ama tirooyinka dhinac-dhinac ama isla tusaale ama dhacdo.

Iyada oo ku xidhan nooca xaashida iyo xogta uu ka kooban yahay, sida liiska magacyada, ciwaanada, lambarada telefoonada, iyo xogta kale ee muhiimka ah, safafka ayaa inta badan la mid ah diiwaanada xogta.

Marka aad kala soocdo xogta safafka ah, saf kastaa waa inuu ilaaliyaa hufnaantiisa, iyada oo aan si badheedh ah xogta looga wareejin saf kale, taas oo, sida aad hoos u arki doonto, waa halka kala soocidda xogta tiirar badan ay ku anfacayso.

Ku kala soocida goob kali ah

Waxaad u kala sooci kartaa diiwaanada xaashidaada ku jira saf, waxaadna u kala sooci kartaa unugyada kaydka ku jira tiirar. Waxaad, dabcan, cayimi kartaa amarrada kala-soocidda ee koraya ama hoos u dhacaya. Sida caadiga ah, kor u kaca / alfanomer ahaan, barnaamijku wuxuu habeeyaa qoraalka A ilaa Z iyo nambarada ka yar ilaa kan ugu weyn. Ku kala-soocidda nidaamka kala-soocida ee hoos-u-dhaca, dabcan, waxay ka beddelaysaa kan ka weyn Z ilaa A , ama si tirooyin waaweyni uga bilowdaan xagga sare.

Sida hawlo badan oo Excel ah , waxaa jira dhowr siyaabood oo loo sameeyo nooc fudud; Wax kasta oo aad u baahan tahay nooca noocan ah, in kastoo, ay ku yaalliin badhanka midig ee duullimaadyada-menu, sida hoos ku cad.

1. Midig ku dhufo^{(Right-click)} meel ka mid ah tiirarka aad rabto inaad ku kala saarto xaashida faafinta si aad u furto liiska soo baxay.
2. Hoos^(Scroll) u dhaadhac oo ku dul rog rogrogmada dusha kala soocida^(Sort) si aad u furto liiska duulista.
3. Guji Kala soocida A ilaa Z^{(Sort A to Z)} kor ama u kala sooc Z ilaa A^{(Sort Z to A )} soo degaya ( Ogsoonow^(Note) in Excel aanay ku jirin xogta unugyada safka 1 ee nooca ah; barnaamijku waxa uu u malaynayaa in safkani uu hayo calaamadaha tiirarka, ama madaxyada.).

Noocan fudud wuxuu u shaqeeyaa noocyo badan oo xog ah, marka laga reebo marka safafkaagu iyo tiirarkaagu ay leeyihiin xog isku mid ah, ama nuqul ah. Xaaladahan, waa inaad kala saartaa laba ama in ka badan oo tiir, soo socda.

Kala-saarista Diiwaanada Goobo Badan

Iyada oo ku xidhan kakanaanta xogtaada, waxa laga yaabaa inaad u baahato inaad ku kala saarto wax ka badan hal tiir. Waxaa laga yaabaa in tusaalaha ugu fiicani uu yahay u-kala-soocidda kaydka xogta alifbeetada siday u kala horreeyaan. U sheeg in xogtaadu ay leedahay dhowr qof oo isku magacyo dambe leh. Xaaladahan, waxaad u baahan doontaa inaad hubiso in Linda Johnson ay timaado Lydia Johnson ka hor , iyo Cherri Anderson oo soo bandhigay Charles Anderson ka dib...Waxaad helaysaa fikradda.

Waxaad samayn kartaa raadinta khaaska ah oo leh shuruudo badan oo kala soocida^(Sort) sanduuqa wada hadalka, sidan oo kale ah.

1. Guji^(Click) unug ku yaal tiirka kowaad ee xogta aad rabto inaad kala soocdo.
2. Guji Xogta^{(Data )} hoose ee ciwaanka si aad u furto ribbonka Xogta . ^(Data)(Rabbadu waa, dabcan, safka tabaha macnaha guud ee korka ee daaqada codsiga.)
3. Qaybta Kala Soocida & Shaandhaynta^{(Sort & Filter)} , dhagsii badhanka kala soocida^{(Sort )} si aad u furto sanduuqa wada hadalka.

• Guji kala soocida^{(Sort by)} hoos-hoos oo dooro magaca tiirka koowaad si aad u kala saarto. (Ogsoonow in Excel uu soo bandhigayo waxa ku jira safka 1 ee tiirka, taas oo kiiskan haysa calaamadaha tiirarka. Waxaad damin kartaa doorashadan adiga oo iska saaraya xogtayda waxay leedahay sanduuqa hubinta madaxa .)^{(My data has headers)}
• Guji Heerka Ku dar^{(Add Level )} si aad ugu darto tiir kale nidaamka kala-soocidda.
• Guji ka dibna^{(Then by)} hoos-hoos oo dooro tiirka ku xiga si aad u kala saarto.
• Ku celi tillaabooyinka 6 iyo 7^{(Steps 6 and 7)} sida loogu baahdo si loo habeeyo cabbirrada noocaaga.

Riixitaanka hareeraha sanduuqa wada-hadalka Kala^(Sort) -soocida waxay daaha ka qaadaysaa dhowr ikhtiyaar oo kala duwan oo lagu beddeli karo noocyadaaga, in kasta oo qaarkood, ilaa aad si sax ah u garanayso sida mid kastaa u saameeyo noocaaga, ay u badan tahay inay soo saaraan natiijooyin aan loo baahnayn.

• Guji OK _
• Haddii aad hesho sanduuqa wada hadalka Digniinaha kala soocida , dooro ^{(Sort Warning)}Balaadhi doorashada^{(Expand the selection)} ka dibna dhagsii kala soocida.^(Sort.)

Ka sokow, marka aad doorato tiir, Excel wuxuu falanqeeyaa waxa ku jira unugyada tiirkaas wuxuuna sameeyaa qiyaaso aqoon leh oo ku saabsan qiyamka ay tahay inay buuxiyaan Goobaha Kala-soocidda^{(Sort on)} iyo Dalbashada^(Order) . Ilaa aad haysato sabab gaar ah (oo macquul ah) oo aad kuwan u beddesho, ha samayn. (Dabcan ilaa aad tijaabinayso mooyee. Had iyo jeer waan dhiiri-geliyaa taas-iyo muujinta Undo ee Excel si cajiib ah ayay u shaqeysaa.)

Sida aan hubo inaad qiyaasi karto, tani waa bilawga sida aad u kala saari karto xogta gudaha Excel . Waxaa muhiim ah in la xasuusto, in kastoo, aad ka taxadarto mooyaane, isticmaalka xuduudaha khaldan ay isku dhejin karto xogtaada oo ay si buuxda u beddesho booskeeda xaashida. Kala soocida^(Sort) waa dhakhso waana fududahay in la habeeyo. Akhbaarta wanaagsan ayaa ah in Undo uu yahay mid degdeg ah, sidoo kale. Ha^(Don) ka baqin inaad ka noqotid oo^(Undo) mar kale isku day. Oo haddana.

Basic One-Column and Multi-Column Data Sorting in Excel Spreadsheets

Two of Excel’s primary functions are to allow yоu to manipulate and view data from different perspectives, and one of the program’s more simple but powerful tools for doing so is thе Sort function.

Whether it’s simple ascending/descending sorts, sorting on more than one variable to display data in groups or to maintain row integrity, or simple alphanumeric sorts to keep your tabular data orderly, sorting data in Excel is an essential skill.

Few programs are better suited for sorting tabular data than Excel, and your sorts can run from the simple and relatively uncomplicated to the highly sophisticated. While Excel’s sorting prowess—what you can do with the right data set and a little knowledge of the inner workings of the program—is indeed robust and in-depth, today’s tech tip focuses on two basic types of sorts, as follows:

• Sorting data on a single column
• Sorting data on multiple columns

Spreadsheets are, of course, made up of columns and rows of cells, or tabular data, where each column comprises a logical division of facts, figures, or any other details by category, such as, say, names, addresses, currency, parts numbers, and so on—depending on the type of spreadsheet. Rows, on the other hand, display people, objects, or figures side-by-side or in the same instance or occurrence.

Depending on the type of spreadsheet and the data it contains, such as a tabular list of names, addresses, phone numbers, and other pertinent data, rows are frequently similar to database records.

When you sort rows of data, each row must maintain its integrity, without inadvertently moving data from one row to another, which, as you’ll see further down, is where sorting data on multiple columns comes in handy.

Sorting on a Single Field

You can sort the records in your spreadsheet by rows, and you can sort the cells within records by columns. You can, of course, specify ascending or descending sort orders. By default, ascending / alphanumerically, the program arranges text from A to Z and numbers from smallest to largest. Sorting with a descending sort order, of course, reverses the older from Z to A, or so that larger numbers start at the top.

As with many functions in Excel, there are a few ways to perform a simple sort; everything you need for this type of sort, though, resides on the right mouse button flyout-menu, as shown below.

1. Right-click a field in the column upon which you want to sort the spreadsheet to open the popup menu.
2. Scroll down and hover the cursor over Sort to open the flyout menu.
3. Click Sort A to Z for ascending or Sort Z to A descending (Note that Excel does not include the data in cells in row 1 in the sort; the program assumes that this row holds your column labels, or headers.).

This simple sort works for many types of data, except when your rows and columns have identical, or duplicate, data. In these instances, you must sort on two or more columns, coming up next.

Sorting Records on Multiple Fields

Depending on the complexity of your data, you may need to sort on more than one column. Perhaps the best example is sorting a database alphabetically in last-name order. Say that your data has several people with the same last names. In these instances, you’ll want to make sure that Linda Johnson comes before Lydia Johnson, and Cherri Anderson displays after Charles Anderson…You get the idea.

You can set up custom searches with multiple criteria from the Sort dialog box, like this.

1. Click a cell in the first column of data you want to sort.
2. Click Data just beneath the title bar to open the Data ribbon. (The ribbon is, of course, the row of contextual tabs across the top of the application window.)
3. In the Sort & Filter section, click the Sort button to open the Sort dialog box.

• Click the Sort by drop-down and choose the first column name to sort on. (Note that Excel displays the content in row 1 of the column, which in this case holds the column labels. You can turn this option off by unchecking the My data has headers checkbox.)
• Click Add Level to add another column to the sort order.
• Click the Then by drop-down and choose the next column to sort on.
• Repeat Steps 6 and 7 as needed to configure the parameters of your sort.

Clicking around in the Sort dialog box reveals several different options for modifying your sorts, though some of them, unless you know exactly how each one affects your sort, will most likely produce unwanted results.

• Click OK.
• If you get a Sort Warning dialog box, select Expand the selection and then click Sort.

Besides, when you choose a column, Excel analyzes the contents of the cells in that column and makes educated guesses as to what values should populate the Sort on and Order fields. Unless you have a specific (and logical) reason for changing these, don’t. (Unless you’re experimenting, of course. I always encourage that—and Excel’s Undo feature works marvelously.)

As I’m sure you can imagine, this is just the beginning of how you can sort data in Excel. It’s important to remember, though, that unless you’re careful, using the wrong parameters can juxtapose your data and completely change its position in the spreadsheet. Sort is fast and easy to setup. The good news is that Undo is fast, too. Don’t be afraid to Undo and try again. And again.

Related posts

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida Loo Geliyo CSV ama TSV Xaashida Shaqada ee Excel

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida Loo Raadiyo Excel

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

• Sida loo qoro IF Formula/Bayaanka gudaha Excel

• Sida Loo Sameeyo Liisaska Hoos-u-dhaca ee Isku Xirka Badan ee Excel

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

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

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida Loo Sameeyo Shaxda Pivot Fudud ee Excel

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo