﻿ Microsoft Excel 2007 tutorial: sort orders

# 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.

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.

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.