If you have Excel 2002 or earlier use Ctrl+A
to select all cells before doing the sort.
If you have Excel 2003 or later use Ctrl+A two or more time
until all cells on the worksheet are selected as Ctrl+A was made to
do what Ctrl+* does (and still does), and this can lead very quickly
to loss of your data.
More information:
http://www.mvps.org/dmcritchie/excel/sorting.htm
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"zil" wrote in message ...
I am trying to sort a document that was sent to me.
The first column (A) has job numbers and the following columns (b, C and D)
have information pertaining to those jobs in A.
But when I sort A ascending, the info in B, C and D does not stay with
Column A.
I want the things associted with the job numbers to change order according
to the order I want the numbers in....
does this make sense?