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...]

FAQ: How to sort lists in Calc

I addressed sorting in OpenOffice Writer in a previous post, and have since had a request for a tutorial on sorting in Calc, so here it goes. Step 1 Select the entire data range that you want to sort. This includes all the columns that have data that need to be kept in line with the column that you want to sort. Include the headers of the column as well, as OpenOffice will pick these up as … [Read more...]