Excel Sorting anomaly

[derrick]

An excel file was created with column headers, so rows 1-4 contain column titles. These are not included with the sort.

When a column is sorted for the first time, the sort ignores the topmost record that should be included. Yet when the sort is repeated the outcome is as expected.

Any explanations?

Cheers
Derrick

 

[melone]

Header Row vs. No Header Row? Check the options at the bottom of the sort window before clicking OK.

 

[derrick]

Header rows are set correctly, and are not involved in the sort