Ask Different is a question and answer site for power users of Apple hardware and software. 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

I'm working with a language file, with columns for different languages. My first row is the language names.


Is it possible to have the "A", "B", "C", etc as language names instead. That way, when I scroll I can still identify each column.

share|improve this question
up vote 7 down vote accepted

As often happens, a couple of minutes after posting the question, I found a way to do this.

In the Inspector, (opt-cmd-i), in the Table Inspector tab click on the middle button of Headers and Footers. Select the option Freeze Header Rows and the first row will stick to the top.

enter image description here

share|improve this answer
Nice solution! Which software do you use to take screenshots like that btw? – Michiel May 24 '12 at 13:06
Thanks! I used the wonderful Skitch – nevan king May 24 '12 at 13:09
Fantastic. Made my day (I'm traveling so it's easy to do). – Richard May 24 '12 at 15:44
You should accept your answer as the answer. – zevlag May 24 '12 at 19:31
@Richard good to hear! – nevan king May 24 '12 at 19:59

I would think it would be better to freeze the first row and by so, it will be visible all over the document when you scroll. But unfortunately, this function isn't wasn't available in Numbers.

You might try editing the document in Print View. The columns and rows are repeated as you scroll, which allows you to see what column/row you are on. Numbers does allow editing in print view. It's not exactly what you are looking for, but it's a solution.

Edit: And as you've answered your own question, it looks like this function is available at this moment.

share|improve this answer
I sure wish numbers had this, I can't believe it doesn't. I've been looking for it for a while now and gave up. Freezing or locking a row or column is incredible important and should be in every spreadsheet program. It's in the program Tables for what it's worth. – Richard May 24 '12 at 12:21
@Michiel Thanks for the answer. I actually found the option to freeze header rows a couple of minutes after I posted the question. The option to freeze header rows is a little hidden away. It's in the Inspector. – nevan king May 24 '12 at 12:50
Cool, didn't knew that :-) Great! – Michiel May 24 '12 at 13:07

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.