I have a question about sorting when using the sort function in Excel 2000. If i make a spreadsheet that uses 10 columns and column A is a unique number, how can I sort this spreadsheet without jumbling columns B thru J. Is there a way to make sure that A3, B3, C3, D3, etc... will stay in the same row? The example below hopefully shows what I am trying to do. If i accidentaly just select column A (Report Number) and do a sort, then all the other data is now not in the correct row. If i then save when I exit, this info is now permanately jumbled. Is there a way to lock the rows together so that they can not get out of order?
Report Date Job Rec'd by Rec'd by
Number Completed Vicki Documents
10000 05/22/09 05/22/09 5-22-09sf
23696 05/23/09 05/23/09 5-22-09sf
45214 04/15/09 04/15/09 5-21-09sf
52145 04/18/09 04/18/09 5-22-09sf
58458 03/19/09 03/19/09 5-20-09sf
58745 07/05/09 07/05/09 5-22-09sf
65455 09/14/09 09/14/09 5-2-09sf
65478 08/16/09 08/16/09 5-22-09sf
Bookmarks