Sorting
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? |
Sorting
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? |
Sorting
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? |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com