Sort - Worksheet

The Data | Data | Sort command arranges data according to rank in user-specified sort columns. Sorting rank is based on numbers, ASCII characters, and punctuation. Sort numeric data, text, or mixed columns. Sorting specifications are made in the Sort dialog.

 

Selecting Cells to Sort

Sorting is performed only on the selected columns (see Selecting Cells). If only one column is selected, only that column is sorted. To keep records (rows of data) together, select all columns containing data even if only one column is sorted.

 

Sort Dialog

Click the Data | Data | Sort command in the worksheet to open the Sort dialog.

 

Click the Data | Data | Sort command to sort data on multiple columns.

 

Sort Order

The Sort First By option defines the primary column on which the rows are sorted. The positions of the sorted rows are determined by the Ascending or Descending rank in the Sort First By column.

 

Secondary Sort

When two or more rows have identical entries in the Sort First By column, the Sort Next By column can further organize the data set. Duplicates in the Sort First By Column are then sorted according to the rank in the Sort Next By column.

 

Final Sort

The Sort Last By column can be used when the Sort Next By column contains duplicates.

 

Ascending or Descending Sort

The sort order in an Ascending sort is based on the ASCII table. Numeric values are placed first, followed in order by cells starting with a space character, common punctuation, numeric text (numbers entered as text), uppercase letters, less common punctuation, lower case letters, uncommon punctuation, and blank cells. Descending order is the opposite of ascending order although blank cells are still listed last.

 

0

1

2

3

4

5

6

7

8

9

space

!

"

#

$

%

&

'

(

)

*

+

,

-

.

/

"0"

"1"

"2"

"3"

"4"

"5"

"6"

"7"

"8"

"9"

:

;

<

=

>

?

@

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

[

\

]

^

_

`

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

{

|

}

~

blank

 

 

 

 

This ASCII table shows the sort order in the worksheet.

 

Ignore Case

Because sorting is based on an ASCII table, upper and lowercase letters are treated differently. For example, "A" is sorted separately from "a." If the letters are to be treated as the same during the sort, check the Ignore case option. When this check box is activated, "A" is considered identical to "a" in the sorting rank.

 

Labels in First Row

The data set may contain text identifying the data in the column (header information) in Row 1. In this case, click the Labels in first row option to exclude the label row from the sort process.

 

 

See Also

Selecting Cells

Data Tab Commands