Sort only selected columns

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I am trying to sort a list of students, but leave the
first column unchanged because this is my count (1-100).
I want to leave that column unchanged so I can see how
many students I have enrolled.

When I select the columns I wish to sort, I go to Data,
Sort. But the entire sheet is selected. In Office 97, I
was able to insert a blank column and this allowed me to
sort the data in the cells next to the cell I selected.
Can I do this in Office XP?
Thanks and you can p-mail me at (e-mail address removed)
 
If you want a field in your table to "autonumber" the records continually I
prefer to use a formularized value for such. In excel if your first actual
record (not the header) is on Row # say 5 and column C in that cell (C5)
enter =Row()-4 then copy downward to your last record. the formula
actual determines the current row number and subtracts 4 from it giving you
the current record number. Any amount of sorting while including the field
will always autonumber your listing as you want it....
HTH
 
Back
Top