Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Sorting Data in Excel 2013

Sorting data values​​, numbers or text in Excel 2013 is done in the following order:

The sequence of alphanumeric characters that Excel supports sorting

0 1 2 3 4 5 6 7 8 9 (space) ! "# $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` { | } ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

On the Data toolbar in the group commands 'Sort & Filter' are commands for sorting. Automatic sorting from A - Z and reverse the order from Z - A (ascending-descending) can be done by clicking on the command buttons i.e. showing letters with an arrow.

How to sort data in Excel

Also, on the Home toolbar located commands for sorting in the group commands Editing.
Sort A to Z, and sort from Z to A in Excel

A dialog window 'Sort' also you can run a combination of keys on the keyboard that is a shortcut ALT+ASS (ALT+HSU)

Multiple sorting in Excel 2013

In the dialog window to sort by multiple columns, i.e. more types of data, we can do the following: On the Data toolbar, click on the command Sort opens a dialog window 'Sort' on the which we can add more levels for sorting.

How to sort the data by columns or more criteria in Excel

In the picture below you notice that I did sort by two criteria. So sorting is done by the column 'B', followed by the column 'D'.

Sort data in Excel