Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Instead of data, I would like the first row to be the names of the columns. How can I do this? One of the reasons I want this is so that if the rows are rearranged the names wont be jumbled up. I think this may be called headings but am not sure.

share|improve this question
up vote 0 down vote accepted

Admittedly in LibreOffice, this is very easy. Make sure your columns have names (meaningful or even just A, B, C ...), select the applicable range (including headers - you are right about the terminology) then Format > Autoformat, OK. Thereafter the headers should stay put even if the rest of the table (data) is sorted.

share|improve this answer
Thanks it worked. I had a humerus experience, when I was trying things out the date got converted into the format 1999-12-31 then when I auto-formatted it must've thought it was an equation and subtracted the numbers...such a silly program. – Celeritas Jun 19 '13 at 18:46
@Celeritas Computers "are machines that do exactly what you tell them but often surprise you in the result." -Richard Dawkins. – pnuts Jun 19 '13 at 18:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.