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 … [Read more...]