Select your data range, including all the relevant rows and columns. Then
Data/ Sort by .../ and choose the relevant column by which to sort.
--
David Biddulph

"Martin" wrote in message
.. .
Hello,

I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with
the
following, please.

I have an Excel spreadsheet, running many hundreds of pages, that has 7
columns.

They are, from left to right, as follows:

1. Person's name
2. Person's street address
3. Person's city
4. Person's state
5. Person's Zip code
6. Reference number assigned to the person
7. Monetary amount

The *current* spreadsheet is neither in alphabetical nor numerical order.

For example, 3 consecutive entries may appear as:

Poe, John 895 Main Street New York NY 10120 753 6.20
Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23

What I would like to do is re-order the spreadsheet by *monetary amount*,
as
long as the data associated with each amount is maintained by the same
re-ordering.

To be more specific, I wish the spreadsheet to appear as:

Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
Poe, John 895 Main Street New York NY 10120 753 6.20
Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57

OR

Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
Poe, John 895 Main Street New York NY 10120 753 6.20
Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23

Any help would be greatly appreciated!

Thank you.

Martin