Forum: comp
Page 25
Subject: Excel...


  Posted by: PuNk42AE - Donor [36635522] Tue, Jun 08, 2004, 14:10

Is there a way in excel to lock everything down the way it is and then sort things by rows? Like in a baseball league I run i've got all the free agents written down, they aren't in order of what they play, would there be a way to have excel put them in order?
 
1biliruben
      ID: 441182916
      Tue, Jun 08, 2004, 14:17
In order of what they play? What do you mean? Sort by position? Sure. Highlight the entire spreadsheet (ctrl S) Then go to:
DATA->SORT

and select the column with the position in it.
 
2PuNk42AE
      Donor
      ID: 36635522
      Tue, Jun 08, 2004, 14:43
Thanks alot, I figured there was somehow to do it, but couldn't think of it.