Ace My Paper - get your Excel tasks done by experts. - makes your homework shine.


Excel tutorials

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.

Sort and Filter Command in Excel

Also, on the Home toolbar located commands for sorting in the group Editing commands.

Sort and Filter command on Home tab in excel 2013

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 Sort command opens a dialog window 'Sort' on the which we can add more levels for sorting.

custom sort data by multiple 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 multiple data in excel