Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .