Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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

languages

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
add comment

2 Answers 2

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
add comment
up vote 5 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 skitch.com –  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
add comment

Your Answer

 
discard

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.