How to Sort Data in Excel (Numbers, Names, Dates)

There are three approaches to kind data in Excel. The first technique is Sort A to Z, the 2nd approach is Sort Z to A, and the 1/3 technique is Custom Sort.

These three techniques can be used to kind numbers in Excel. In addition to numbers, sorting records can moreover be used for textual content material information such as names and date data. How to do? Check out Nuqimust's talk below until the end. Let's begin through sorting the numbers first, guys.

If you have study the put up on how to make Rp in Excel, you need to be acquainted with this ITEMS AND PRICE DATA. Because there are already many posts that use this facts and coincidentally there are fees and names (goods) there too.

However, to be in a role to type facts in Excel, the header of the data needs to be modified slightly, the merged columns have to be deleted first. Sorting data is no longer possible if there are unified columns. There will surely be an error "To do this, all the merged cells desire to be the identical size.".





So after a little modification, this is what the statistics appears like now.



After modification, we proceed sorting facts in Excel opening with numbers first. Here are the steps.

First, we block/select the data in the inline column that we desire to kind (in this case research about it is the PRICE column). Next, we opt for to type the product prices from the smallest to the biggest price.

Data geared up from smallest to biggest cost ability the use of Sort A to Z. Sort A to Z is additionally recognized as Sort Ascending.

After the column is blocked, click on on Sort & Filter in the Home tab of the Editing region (top left corner). Then click on Sort Smallest to Largest.

Next, the Sort Warning dialog appears to confirm to us whether or no longer the sorting of records is entirely in the blocked column or the whole column of records rows. Options:

- Expand the selection, which ability sorting statistics into all rows and columns
- Continue with the modern-day selection, which conceivable sorting statistics completely on the blocked/selected column of rows.


 Here we pick out Expand the willpower so that the exclusive row columns additionally change in accordance to the column sorting motion that we block (the PRICE column). The end end result will be like this.



Seen in the PRICE column, the product charge starts off evolved with a price of Rp. 2,350,000 and is the smallest charge of all present products. Then proceed with the growing nominal price.

Well. That's how to kind information in Excel, in particular numbers. We've managed to type from smallest to largest.

Next, let's try the exclusive way around. Sorting records from largest to smallest is referred to as Descending Sort. In Excel, the characteristic is Sort Z to A. More or tons less the approach is related to Sort Ascending.

First, of course, we block the column that we decide on to sort. Then click on Sort & Filter in the Home tab of the Editing phase (top left corner).

Well here is the location it is different. Now, we click on on Sort Largest to Smallest. Keep deciding on Expand the resolution in the Sort Warning dialog that appears. Done and the end end result will be like this.



The distinction is clear, right? The cost starts off evolved from IDR 10,600,000 and is the quality price. Then proceed with reduce charges and so on.

Oh, how about how to kind the rankings in Excel, right? Is it the same way as above? It's the same, if the ranking is a broad range too. Wait a minute, speaking of rankings, first take a look at how to make rankings in Excel.

How? So far, do you recognize how to kind Excel, mainly numbers from small to giant and vice versa? Alright, that ability we go on to the subsequent discussion.