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?

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?

Thank you so much David!
I knew it had to be easy but I just couldn't figure it out!


"David McRitchie" wrote:

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?