sorting

  • Thread starter Thread starter semisam
  • Start date Start date
S

semisam

When sorting, every once in a while a row will refuse to
sort. All info below it will sort, but the first row will
not. To get around this, I have been entering all info
into another row then deleting the row that will not
sort. There has to be a better way!

Semisam
 
If you want the first row to sort, go the long
way: "Data/Sort and then check the box "My list has no
header row". If the box "My list has header row", then
Excel considers the first row as a header and will not
sort it with the rest of the list---useful if you have a
header to your columns. Connie
 
Back
Top