How to sort data in Excel Ascending and descending, according to ABC
Sorting lists in alphabetical order or descending order is often used in lists of names of people, searching for elements with the greatest number of values. And the arrangement of such data is not difficult with the help of Excel in the following article of TipsMake.com .
1. Simple way to organize data in Excel
To sort the data in Excel by ABC first you need to highlight the column containing the data we need to sort by. Just hover your mouse over the column name and click once to highlight the entire column.
Then open the Data ribbon on the toolbar.
In the Data ribbon there is a Sort & Filter section, this item contains the Sort function to sort the data for you.
You click on the icon A -> Z (Sort A to Z) or Z -> A (Sort Z to A) in this section to proceed to sort data. In which, A -> Z is the data sorting in alphabetical order and Z -> A is the data sorting type in reverse order CBA.
A Sort Waring warning panel will appear to ask you what kind of data you want to sort:
- Expand the selection : This sort of arrangement will entail a change of data of other columns. Based on the arrangement of the data in the selected column, data of other columns will be moved in each corresponding row. This type of choice is usually chosen because the data in a table is usually linked together in horizontal rows, so when changing the arrangement of one column, the other columns must follow.
- Continue with the current selection : Sort data only within the range of the selected column without affecting other columns.
As a result, you will get a data table that has been sorted by ABC of the word name column as below:
Similarly, we can sort numeric data in ascending and descending order by highlighting that numeric data column and entering the Data ribbon on the toolbar.
Selecting A -> Z will sort data in order from small to large while Z -> A will sort data in order from large to small.
Then you also select Expand the selection or Continue with the current selection as the rule mentioned above. The result will be as shown below:
2. The way to sort data in Excel is more complicated
Except for the easy method of data arrangement above, you can also use the data arrangement on the entire data table with many different columns and with different criteria.
This time you can black out the entire data table or black out all the columns that contain data to sort.
Then you go to the Data ribbon on the toolbar of Excel.
This time you do not select the two functions A -> Z and Z -> A faster but click on the Sort icon next to it.
The dialog box of the Sort function will appear, you change the selection in Column to the name of the column you want to sort the data.
And in the Order column , if in the Column that you select the numeric data column, you will have two options Smallest to Largest (smallest to largest) or Largest to Smallest (largest to smallest).
Also Column you to select a column of data words (or characters) will have two choices are A to Z or Z to A .
Not only that, you can continue to create more arrangements besides the first data sorting settings by clicking on Add Level .
Another row of data sorting will appear, you do the same way as above.
Note that the data sorting priority will be in order from top to bottom. That is, after sorting the data according to the settings of the above line, Excel will continue to sort by the sort of data in the bottom row for the same data cluster arranged close together.
In the example shown in the picture, Excel will sort the list according to the student's final grade, then between students with the same score, Excel will continue to sort them in alphabetical order of first and last name.
Click OK to sort the data and the results you get will be similar to the table below:
Thank you for following the article on how to sort data in Excel Ascending and descending, according to our ABC's TipsMake . Wish you can successfully implement the above trick in your data sheet. Please visit our other articles for more knowledge about Excel, see you again.
You should read it
May be interested
- How to fix word errors in Word are spaced, words are far away in Wordtext that has a typo error will make the overall presentation for your article not look good. the reasons for this disruption are several types and their respective fixes, all of which will be covered in the following article by tipsmake.vn.
- Instructions on how to create input forms in Excel extremely fast and simplecreating an input form in excel is a very necessary tip if you are an accountant or office worker. it helps you to make statistics and input data for excel simpler and faster. below, tipsmake will guide you the most basic steps to create a simple input form.
- How to cut a PDF file into any small number of pagesyou want to split pdf files into any number of small pages to facilitate the exchange of files with friends faster instead of having to send an entire pdf file. in this article, tipsmake.com would like to guide you how to cut pdf files into many small pages quickly and accurately.
- How to cross cells in Excelyou're making a table in excel and have a blank data cell and you want to cross that box but don't know how to do it. let tipsmake.com help you through the article how to cross cells in excel offline!
- How to create List Box in Excelyou want to create a list of options (list box) for your excel file but do not know how to do it. in this article, tipsmake.com would like to guide you how to create list box in excel most accurately. let's follow along!
- How to split tables and join tables in Wordwhile working with tables in word, sometimes you need to split a table into two tables or join two or more tables together. if you do not know how to split tables and join tables in word, then please refer to the following article.