If you previously sorted a list on the same worksheet, Microsoft Excel uses the same sorting options unless you change them.
Click a cell in the column you would like to sort by.
Click Sort Ascending

Sort rows in descending order based on the contents of one column
If you previously sorted a list on the same worksheet, Microsoft Excel uses the same sorting options unless you change them.
Click a cell in the column you would like to sort by.
Click Sort Descending

Answered by Smarty , an ibibo Master, at 4:11 PM on May 07, 2008

hi trisha!
hru!

In an ascending sort, Microsoft Excel uses the following order. (In a descending sort, this sort order is reversed except for blank cells, which are always placed last.)

Numbers Numbers are sorted from the smallest negative number to the largest positive number.

Dates Dates are sorted from the earliest date to the latest date.

Alphanumeric sort When you sort alphanumeric text, Excel sorts left to right, character by character. For example, if a cell contains the text "A100," Excel places the cell after a cell that contains the entry "A1" and before a cell that contains the entry "A11."

Text and text that includes numbers 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

Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last.

Logical values In logical values, FALSE is placed before TRUE.

Error values All error values are equal.

Blanks Blanks are always placed last.


you can also check the sorting formula and all tools at this site.
i hope this site will help u to understand excel and sorting techniques.

http://www.microsoft .com/technet/scriptcenter/resources /officetips/jul05/tips0719.mspx

thanks!
take care!

Answered by Aryan Singh , an ibibo Specialist, at 5:34 PM on May 01, 2008

Sort rows in ascending order based on the contents of one column

If you previously sorted a list on the same worksheet, Microsoft Excel uses the same sorting options unless you change them.
Click a cell in the column you would like to sort by.
Click Sort Ascending

Sort rows in descending order based on the contents of one column
If you previously sorted a list on the same worksheet, Microsoft Excel uses the same sorting options unless you change them.
Click a cell in the column you would like to sort by.
Click Sort Descending

Answered by Nagendra , an ibibo Master, at 7:44 PM on April 30, 2008

you will find many formulas on this site

http://www.exceltip.com/exc eltips.php?view=archive_showtips&ID =605

Answered by RushON , an ibibo Citizen, at 12:06 PM on April 30, 2008

Well I don't know about formulas really but you can easily sort a range of values by selecting the range and then selecting sort from Data -Menuu in the toolbar and selecting your sort criterion i.e which columns to sort on ( Ascending or Descending ) . You can sort on multiple columns . Another way would be to put on the Autofilter form Data Menu again and you can sort and filter out by value the items displayed .Hope this helps .

Answered by Clayton , an ibibo Advisor, at 12:02 PM on April 30, 2008

Well Trisha, Sorting in Excel lets you easily reorder your data based on the type of sorting that you choose.

Excel Sorting: Alphabetical Order (Ascending)

The most common type of sorting, and one that is applicable to our situation, is alphabetical ordering. This kind of ordering places the cells that start with the early letters of the alphabet (a, b, c...) at the top and the later letters (t, u, v...) at the bottom of the list.

1. First we need to select all the data so we can begin to sort it. Because each name has a corresponding score we need to select both columns to preserve the students' correct scores.

2. Left-click and hold on cell A1 then drag down-right to cell B10 to highlight all the data for sorting! Your spreadsheet should look like this:

3. Left-click the "sort ascending" button, located near the top, on the shortcut bar (it has a blue A on top and a red Z on bottom with a downward pointing arrow).

4. Your spreadsheet should now be sorted.

Numerical Ordering / Sorting :

If you wanted to instead sort the homework assignments by highest to lowest score you would follow these steps to use Excel's numeric sorting.

The only difference between this example and our previous examples is which column you start your selection from, so pay close attention to the first step!

1. Left-click cell B1 and drag down-left to cell A10

2. Left-click the "sort descending" button, located near the top, on the shortcut bar (it has a red Z on top and a blue A on bottom with a downward pointing arrow).

3. Your Excel data should be sorted now.

For more information and screen shots , Please visit the source site :

http://office.tizag.com/e xcelTutorial/excelsorting.php

Answered by Alok Gupta , an ibibo Guru, at 11:32 AM on April 30, 2008