Which of the Following Can You Sort Excel Data by?

Tabular array of Contents

• Sorting in Excel
• Examples of Sorting in Excel

Sorting in Excel

Sorting in excel is nothing but arranging data stored in excel according to your requirement. It tin be done by depending on the value type stored in cells. Some common examples include sorting alphabetically (A to Z or Z to A), by value (largest to smallest or smallest to largest), by solar day of the week (Mon, Tue, Wed..), or by calendar month names (Jan, February..) etc. Filter Method sorting in Excel tin can be done depending on the type of information (number or text); there are many ways to sort data using the filter method.

With basic sorting, there are few problems like multiple columns in sort not available; customized list sorting cannot be done with basic sorting. To overcome this, the Advanced sorting option is bachelor in Excel; past using that, we can eliminate the above-mentioned limitations; besides, information technology has wonderful features of sorting depending upon cell color and cell icon. (Explained later in this guide), Multi-level sorting tin be done by advanced sorting. Y'all can also build your own criteria in Excel for sorting. To sort any particular dataset, select the entire dataset, go to the Information tab click on the SORT Selection. The hotkey is (Alt key + A+ SS).

Examples of Sorting in Excel

Let'southward sympathize the following examples of sorting in excel.

You can download this Sorting Excel Template here – Sorting Excel Template

Example#ane

• Suppose yous have information equally shown below:

• Now the information in the to a higher place image can be sorted based on employee name, i.e. alphabetically (A to Z or Z to A) or on the basis of Total sales. (numerically- lowest to highest or highest to lowest).

• While in the above case, sorting is done on the ground of one column, but what if you take data something similar in the beneath image, So to do sorting on the basis of 2 or more columns, you need to have some boosted steps.

• In the higher up illustration, you want to sort information at multiple levels, Eastward.thou. You want to showtime sort data past reporting director, then by employee name and and so by club full (highest to lowest). Why is it required? Suppose you accept to find out which employee of every manager has done the maximum order sales.? Y'all tin can find out answers to queries similar this past using multi-level sorting. This tin be only be done by advanced sorting. So to sort data at multiple levels. Simply select the entire dataset and Printing (Alt central +A+ SS).

• This volition open a dialogue box like this:

• In the above dialogue box, y'all have to fill your requirements for sorting in cells and add together levels 1 by one.

• Now, as shown in the to a higher place image, I accept applied sorting criteria, information technology will requite results something like this:

Options bachelor in sorting dialogue box:

1. Add Level: to add together different levels to mention sorting criteria depending on the dataset.
2. Delete Level: to delete whatsoever particular level
3. Level: to re-create any particular level. (Generally used when sorting is required on the aforementioned column but with dissimilar values.)
4. Arrow Buttons: to move any level above or below.
5. Options: Here, you tin select the level orientation of sorting and if values are instance sensitive or not.
6. My Information Headers: Check if your dataset has headers.
7. Columns: This volition contain all headers of your data.
8. Sort on: Hither, yous can mention you want to sort information on the basis of jail cell values, cell colour, font color or provisional formatting.
9. Society: Information should be sorted A-Z, Z-A, smallest to largest, largest to a smallest or customized list.

You tin expect at some of them in the below Screenshots.

Sorting Options

The cavalcade having all headers

Sorting Options

Example#2

• Now taking the same data equally given in the beginning case, you lot are going through all the orders, and y'all take doubt that few orders are wrongly punched, or you have some problems with it. You have highlighted all the orders having issues with yellow color. Suppose,

1. Orders wrongly punched marked with red.
2. Orders with a total value of less than g are marked with yellow.

• So nosotros volition select the data from the sheet.

• Now you want to sort data and so that you tin can find out which employee of each Reporting Manager has punched wrong orders and orders with a value less than 1000; you will give sorting criteria.

• And the sorted data will be like this:

At that place is another fashion to sort data at multi-levels(Explained later on). However, the in a higher place-mentioned method has more steps equally compared to the multi-level sorting method; it is still recommended to use this one considering it is less confusing. Multi-level sorting can exist done in two ways: –

1. By using the Dialogue box (Discussed in the higher up two Examples)
2. Using Sort Icons

Example#iii

• We volition use the aforementioned data of previous examples, now using the sorting icon. Both the methods mentioned above works in the aforementioned way; the only difference is that hither in the sorting icon method, the final level is sorted outset and and then goes to the first level Viz. sorting is washed from bottom to acme. Confusing? Isn't it?

• And then at present, select the column y'all want to sort concluding. (E.g. Gild Total in our case).

• Now go to Information Tabular array and Sort and click on Z-A to. (This will sort the society total from largest to smallest). Hot Key (Alt Key +A+ SD).

• Excel is smart enough to recognize that you have data stored in a cavalcade backside or side by side to information technology. Later on clicking the sorting icon, a pop-up window will announced; it will inquire you whether to expand the selection? Or keep with the current selection? Brand sure to expand the selection.

• And the event is shown in the below image.

• Now, select the Employee name column and repeat the above steps.

• Here click on the A-Z selection in Sort & Filter. Hot Cardinal (Alt Key +A+ SA).

• And the effect is shown below.

• And aforementioned steps for Reporting Manager select the Reporting Director Cavalcade.

• And then click on the A-Z pick in Sort. Hot Key (Alt Fundamental +A+ SA).

• And the result is shown beneath.

While both the methods piece of work fine, information technology is all the same recommended to use the dialogue box method considering it is less decumbent to errors, as we can clearly see which level is getting sorted in which order.

Things to Recollect about Sorting in Excel

• Sorting in Excel is arranging data according to our requirements.
• It can be done alphabetically or numerically.
• Basic Sorting works when sorting is to exercise on only one column.
• Advanced Sorting is used in multi-level sorting, viz sorting required in 2 or more than ii columns.
• 2 methods can do advanced Sorting:

1. Sorting Dialogue Method
2. Sorting Icon Method

Recommended Manufactures

This has been a guide to Sorting in Excel. Here nosotros talk over Sorting in Excel and how to utilize the Sorting in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

1. Excel Sort By Number
2. Sort Column in Excel
3. VBA Sort
4. Excel Sort by color

giddingsdigetund66.blogspot.com

Source: https://www.educba.com/sorting-in-excel/

Bagikan Artikel ini