How to use Excel
You can sort the columns! Rows are often sorted, but...
In a sales table created in Excel, sorting in descending order of amount, or sorting in order of the Japanese syllabary in a customer list, etc. , it happens often.
For example, in the following "sales table by store", how can I sort the data in descending order of the total amount (①) in column F?
How can I sort the data in order of the total amount (①) in column F Let's try it. First, drag and select (2) the cell range "A3:F7" to be sorted. Click the [Data] tab (3) → [Sort] (4).
Drag and select the target cell range "A3:F7" (②). Click the [Data] tab (3) → [Sort] (4) The [Sort] dialog box will be displayed. Confirm that the [Use first row as data header] check mark is ON (⑤). Click the arrow icon (6) displayed to the right of [Top priority key] to display the items entered in the header row. In this case, we want to sort the data in descending order of the total amount, so select [Total] (⑦).
Confirm that the check mark for [Use first row as data header] is ON (⑤). Click the arrow icon (⑥) displayed to the right of [Highest Priority Key] → Select [Total] (⑦) because you want to sort the data in descending order of total amount Continue to [Order Click the arrow icon that appears to the right of ], select [Largest] (⑧), and click [OK] (⑨).
Click the arrow icon to the right of [Order] and select [Largest] (⑧) When you return to the sheet, the data will be sorted in descending order of the total amount in the previously selected cell range "A3:F7" (⑩).
In the cell range "A3:F7", the data has been sorted in descending order of the total amount (⑩) Many readers may be accustomed to sorting by row like this. But did you know that you can actually sort by column in Excel? In this "sales table by store", you can sort the data by column in descending order of the total amount for each month (row 8).
This time, I will explain how to sort the data by column in the Excel sales table.
![[Excel] Column sorting is Did you know you can?How to quickly sort data in Excel](https://website-google-hk.oss-cn-hongkong.aliyuncs.com/drawing/article_results_9/2022/3/10/955b39e63314cd43120aeb71f462192c_1.jpeg "[Excel]Did you know you can sort columns?How to quickly sort data in Excel")
Let's try to sort the columns
Using the same "sales table by store" as before, sort the data by column so that the total amount (①) in the 8th row is in descending order. Let's sort it.
Let's sort the data by column so that the total amount (①) in the 8th row is in descending order First, drag and select the cell range "A3:E8" to be sorted ( ②) Click the [Data] tab (3) → [Sort] (4).
Drag and select the cell range "A3:E8" to be sorted (②). Click the [Data] tab (3) → [Sort] (4) The [Sort] dialog box will be displayed. Now click Options (⑤) at the top of the dialog box.
Click [Options] (⑤) at the top of the dialog box The [Sort Options] dialog box will be displayed. )Click. Now you can sort by columns.
In the [Direction] field, select [By column] (⑥) and click [OK] (⑦) Since the sorting will be done by the total amount in the 8th row, in the [Sort] dialog box, [Priority Specify [Row 8] (⑧) in [Key]. Next, select [Largest] (9) from the [Order] drop-down list, and click [OK] (10).
Specify [Line 8] (⑧) for [Highest Priority Key]. From the [Order] drop-down list, select [Large to Large] (⑨) and click [OK] (⑩) The dialog box will close and you will return to the sheet. The monthly "total" row in the 8th row is sorted from the left in descending order of the amount (⑪).
The "Total" row for each month is sorted from the left to the largest amount In Excel, you can sort by row or by column!
This time, I explained how to sort the data by column in the Excel sales table. As in this example, if you can sort by either row or column, you can check and analyze the data from various angles, which is convenient. Please try it once.
notebook-laptop
