Sorting Data in
a Table.
Sorting reorders the list either in
Ascending order (A to Z for text, lowest numbers first for numbers) or
Descending order (Z to A for text, highest numbers first for numbers) you can
sort the entire list or just a selected area. Excel 2007 unlike previous
versions can sort on up to 64 columns.
Unless you are able to Undo the sort you
can not recover the original order of the list so, if this is important to you,
insert a column into the list and enter some index numbers into this column so
that you can sort back to the original order.
Create and index by applying a number series.
Example: Creating a number series:
In “A1” type in the number 1, in “A2” type in the
number 2.
Highlight cells “A1 & A2” using the
fill handle (thin cross) drag down the series so that it goes 1,2,3,4,5.
In an Ascending sort, Excel uses the following order for text and text
that includes numbers:
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
Numbers are sorted from the smallest
negative number to the largest positive number. Alphanumeric text is sorted
left to right, character by character.
Apostrophes and hyphens are ignored,
except where if two text values are the same except for a hyphen, the text with
the hyphen is sorted last. Logical values; FALSE comes before TRUE. All error
values are equal. Blanks are always placed last.
A Descending
sort reverses the sort order except for blank cells, which are always last.
Sorting on an Individual Column.
1.
Click into an individual cell the column that you wish to sort.
2.
Select the Data tab.
Sorting by Multiple Columns.
In the previous example we will sort the
data in the table by ‘Department’ in column “C”.
In this example we will sort firstly by
‘Department’ then by the ‘surname’ columns.
Select the second sort level
‘Surname’ followed by the Sort Order (A
to Z or Z to A).
8. Click Ok to apply the sort
Preview
of the data table once the sort has been applied.
Additional Sort Options
Customising the Sort Order.
When sorting the table Excel sorts
either ascending or descending, however you able to override this by creating
your own sort order.
An example of this could be:
In the U.S.A. we often talk about the east and west coast, each having
various states, you may
wish to sort the table east coast first with the each state in a certain
order followed by the west coast.
The problem is in both east and west you
may have states starting with the same letter, so when sorted the east and west
will be mixed together incorrectly.
This is where we can create a custom
list, the custom list will allow us to enter each of the individual states into
the order required be sorted.
So in short we create a custom list and
apply the sort to the custom list allowing us to override the default sort
order.
For Further Course Details Visit Our Homepage
Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
No comments:
Post a Comment