Excel - Sorting

Asked By zi on 13-Mar-07 01:20 PM
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?


David McRitchie replied on 13-Mar-07 01:28 PM
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/shortx2k.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
zi replied on 13-Mar-07 01:43 PM
Thank you so much David!
I knew it had to be easy but I just could not figure it out!