There are already numerous posts in the discussions about this (I think one is at the top of page two), the general answer is, nope. Doesn't work in numbers, not yet. You can use the print preview or other work arounds.
Please use the submit feedback option in the Numbers menu to send Apple Programmers suggestions. thats the best way to get them to notice a area that needs work.
Yvan KOENIG (from FRANCE mardi 11 septembre 2007 09:26:51)
Hello - I am trying to do the same thing and to discover that Apple "forgot" or didn't include this feature is pretty poor planning on their part. This is the kind of omission that can halt adoption. I'm very disappointed with Apple about this and was excited about using numbers... guess I'll have to keep using Excel until it is fixed.
Message was edited by: Andrew Brackenbury
Apple didn't forget it, they didn't want it Numbers isn't just another excel clone.
Numbers is for multiple tables on multiple sheets not for Monolithic excel type grids.
The tables are individual graphics and have the number of rows and columns needed for the job in hand, Another job = another table
Have a play with it, there's a huge number of different options.
Yep I've posted exactly the same as this elsewhere. Each worksheet is a blank page, awaiting all sorts of goodies, including lots of little tables.
Do we really want another Excel clone?
The direction Numbers is heading towards - lots of linked tables ala a relational DATABASE - is exciting.
I want Numbers to develop in this direction.
Oh yeah, in case you can't find what you want in the menus of Numbers - look in the Inspector - tons of goodies in there!
And why we can't have the great options of excel plus the great ones of numbers together?
I love the idea of indivual spreadsheet of numbers, really I do... but I want also have the option of freezing rows or columns. Cause the finality is do our work more simply, right?
I know numbers is designed to design (sorry :)) but writing in vertical it's design too and it's not included in numbers.
It's only my opinion.
please see all the other linked topics, and keep searching in the forums here.
You will see that many people have stated that it would have to be coded for each table to be a scrollable entity in itself to implement this. because we can place tables anywhere on a page, including on top of one another, how would you suggest implementing locking the headers on one table while letting the other scroll off the page? It would be visually confusing.
I'm sure that I'm bright enough to program my own spreadsheet program actually.
So, numbers is like a program for those people who have time on their hands to be creative with data. I can definitely appreciate that but I guess I was just hoping for an Apple solution or improvement on Excel. I don't quite have the time to be getting creative with the data analysis I need. I simply want results. However, maybe over Christmas I'll have a more thorough play with it and be converted. I hope so because Microsoft products are pretty terrible.