Microsoft Excel 2007 tutorial: sort orders


Sort orders

VII. Sort orders

In Microsoft Office Excel, there are two types of sort order: ascending order (A to Z) and descending order (Z to A). In an ascending order, Excel uses the following sort order, but in a descending order, this sort order is reversed.

- Number: Numbers are sorted from the lowest values to the highest values. For example, -10,-7,1,2,3,5.

- Date: Dates are sorted from the earliest data to the oldest date. For example, 30-03-2011, 23-04-2011, 11-09-2013.

- Text: Text is sorted from left to right, character by character. For example, you have entered text data in three cells (A1=B100, A2=B1, A3=B11); when you sort these text data, Excel replaces the cell containing B100 after the cell containing B1 and before the cell that contains B11 (B1, B100, B11).

Text, signs, and numbers stored as text are sorted in the following order:                 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

Notes:

- If you set the default sort order to be case-sensitive through the Sort Options dialog box, the sort order for alphabetical characters is the following:
a A b B c C d D e E f F g G h H i I j J k K l L m M n N o O p P q Q r R s S t T u U v V w W x X y Y z Z.

- To set the default sort order to be case-sensitive, do the following:

1. Select the cells containing data that you want to sort

2. On the Home tab, in the Editing group, click Sort & Filter, and then click Custom Sort.

Excel 2007 custom sort command

3. In the Sort dialog box, click Options button.

4. In the Sort Options dialog box, select Case sensitive check box, and then click Ok button.

Excel 2007 select case sensitive

5. In the Sort dialog box, click Ok button to set the case sensitive option successfully.

- Logical: In logical values FALSE is replaced before TRUE.

- Error: Error values such as #NUM! and #REF! are equal when you sort.

- Blank: Both ascending and descending sort, blank cells are always at the bottom of the selection.

Note: The blank cell is an empty cell that is different from the cell containing space characters.

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.