Complete and basic training of various types of information sorting in Excel software

Introduction

Organizing and organizing information becomes very important when you give a lot of content to the page. You can quickly reorganize a page by sorting the data.

For example, you can organize and sort the list of contact information by last name. Content can be arranged alphabetically, numerically, and in several other ways. 

Types of sorting

When sorting data, it is important to first decide whether to apply this order to the entire page or just to a row of cells.

point icon   Page categorization organizes all the data on the worksheet with one column. When the classification is done, the information for each row is put together. In the following example, the contact name column (column A) is arranged alphabetically to indicate names.

C: \ Users \ takrayaneh \ Desktop \ sort_explain_sheet2.png

point icon   Row sorting organizes data in a row of cells, which can not affect the contents of other worksheets when working with a page that has multiple lists.

C: \ Users \ takrayaneh \ Desktop \ sort_explain_range3.png

Sort a page

In our example, we ordered the T-shirt alphabetically by last name (column C).

1. In a column, select the cell you want to sort. In our example, we have selected cell C2.

C: \ Users \ takrayaneh \ Desktop \ sort_sheet_select.png

2. Select the DATA bar on the ribbon. Then click the command (top to bottom) to sort from letters A to Z, (bottom to top) to sort from letter Z to A. In the example we have selected the top-down command.

C: \ Users \ takrayaneh \ Desktop \ sort_sheet_command.png

3. The worksheet will now be sorted by the selected column. In our example, the worksheet is now sorted by last name.

C: \ Users \ takrayaneh \ Desktop \ sort_sheet_done.png

Sort a row

In our example, we have selected a separate list of T-shirt order forms to sort the number of T-shirts ordered on different dates.

1. Select the cell row you want to sort. In our example, we have selected cell rows A13 to B17.

C: \ Users \ takrayaneh \ Desktop \ sort_range_select2.png

2. Select the DATA bar on the ribbon. Then the SORT command.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_command.png

3. The SORT table appears, select the COLUMN section to sort it. In our example, we want to sort the data by the number of t-shirt orders. So we have selected ORDERS.

4 – Specify that the data is written from top to bottom or bottom to top. In our example, we have selected from the smallest to the largest size.

5. OK when you have made your selection.

C: \ Users \ takrayaneh \ Desktop \ sort_range_ok.png

6- Cell rows will be arranged in the selected column. In our example, the order column is selected from the shortest to the longest. Note that other worksheet content is not affected by this sort.

C: \ Users \ takrayaneh \ Desktop \ sort_range_done2.png

If your data is not sorted correctly, check the cell values ​​again to make sure they are entered correctly on the worksheet. Even a small letter can be a problem when arranging a large worksheet. In the following example, we forgot to put a dash in cell A18, which caused our sorting to be incorrect.

C: \ Users \ takrayaneh \ Desktop \ sort_explain_splat.png

Custom sorting

Sometimes you may find that the default sort options do not sort the data as you need it. Fortunately, Excel allows you to create an order list where you can specify your sort order. In the example below, we want to sort the worksheet by the size of the T-shirt (column D). A typical order arranges sizes alphabetically, which may be incorrect. Instead, we will create a custom list that sorts the sizes from smallest to largest.

1. In a column, select the cell you want to sort. In our example, we have selected cell D2.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_select.png

2. Select the DATA bar, then click the SORT command.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_comman11d.png

3- The SORT table will appear. Select the column. From the ORDER section, select the custom list (CUSTOM LIST). In our example, we have selected the sort by t-shirt size.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_dialog_custom.png

4. The CUSTOM LIST table will appear. From the CUSTOM LIST menu, select NEWLIST.

5. Type the goods in the desired order list in the LIST ENTERIES section. In our example, we want our data to be sorted from smallest to largest by T-shirt size. So we type SMALL, MEDIUM, LARGE, and X-LARGE, while after each product, we press the ENTER key on the keyboard.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_add6.png

6. Click ADD to save the new sort command. The new list will be added to the custom lists. Make sure the new list is selected, then OK.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_dialog_ok2.png

7- The custom list box will be closed. OK again to apply the new sort.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_ok.png

8. The worksheet will be sorted by custom command. In our example, the worksheet is now sorted from smallest to largest by T-shirt size.

C: \ Users \ takrayaneh \ Desktop \ sort_custom_done2.png

 

Sort by cell formatting method

You can also choose to sort your worksheet by formatting, rather than cellular content. This can be extremely useful. If you add color encoding to the main cells. In the example below, we sort through cell dye to find out which T-shirt orders are late.

1. In a column, select the cell you want to sort. In the example we have selected cell E2.

C: \ Users \ takrayaneh \ Desktop \ sort_color_select.png

2. Select the DATA bar and then click the SORT command.

C: \ Users \ takrayaneh \ Desktop \ ریبذ. Png

3- The SORT table will appear. The column in which you want to sort. Select, then select to sort by cell color, font color, or cell symbol in the SORT ON field. In our example, they are selected according to the payment method (column E) and cell color.

C: \ Users \ takrayaneh \ Desktop \ sort_color_cell.png

4. From the ORDER section, select a color to sort, in our example, we have selected bright red.

C: \ Users \ takrayaneh \ Desktop \ sort_color_cell_color.png

5- OK. In our example, the worksheet is now sorted by cell color, and the red cells are up. This allows us to see which ones still have arrears.

C: \ Users \ takrayaneh \ Desktop \ sort_color_done2.png

Sorting levels

If you want to have more control over how your data is organized, you can add several levels. This allows you to organize your data in more than one column.

  • Add a level
  • In our example, we have selected the worksheet based on the HOME ROOM number (column A).
  • Then last name (column C)

1. In the column you want to arrange, select a cell. In our example, cell A2 is selected.

C: \ Users \ takrayaneh \ Desktop \ sort_mult_select.png

2. Click the DATA bar and then select the SORT command.

C: \ Users \ takrayaneh \ Desktop \ ریبذ. Png

3- The SORT table will appear. Select the column. In our example, we chose with HOME ROOM #.

4. Click ADD LEVEL to add another column.

C: \ Users \ takrayaneh \ Desktop \ sort_mult_add_level.png

5. Select the next column and then OK. In the example we have selected according to the last name (column C).

C: \ Users \ takrayaneh \ Desktop \ sort_mult_ok.png

6. The worksheet will be arranged according to the selected command. In our example, the HOME ROOM numbers are arranged numerically. Students are also sorted alphabetically by last name.

C: \ Users \ takrayaneh \ Desktop \ sort_mult_done.png

If you need to change the order of multiple levels, an easy way to control which column is sorted first.

C: \ Users \ takrayaneh \ Desktop \ sort_mult_splat.png

Just select the desired column, then click the up or down arrow to adjust its priority.

Leave a Reply

Your email address will not be published. Required fields are marked *