Sorting

[Guest]

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]

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

 

[Guest]

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