Question: Why does the header row keep moving when I sort?

In a previous post I have answered a question about sorting lists in Calc.

This usually has no problems, but every now and then an occasion occurs where Calc doesn’t recognise that the first row is a header row.

To deal with this, in Step 3 of the previous tutorial you need to click on the Options tab and ensure that the “Range contains column labels” tick box is checked (or ticked). Then you can continue to specify your sort criteria and sort your data.

Thanks to JDA for the question.

This also works in LibreOffice as well.


  1. Wow – thanks for this… Was trying to work out what I was doing wrong! Thanks!

Speak Your Mind