Currently Being ModeratedJan 3, 2013 11:34 AM (in response to nitrous_cyclings)
Currently Being ModeratedJan 3, 2013 12:01 PM (in response to nitrous_cyclings)
Adding to Wayne's answer to your specific question...
There are enough differences between AppleWorks's SS module and Numbers that you'll find reading at least the first few chapters of the Numbers '09 User Guide time well spent.
The guide is available for download through the Help menu in Numbers, as is the iWork Formulas and Functions User Guide. Both are well worth having available.
Currently Being ModeratedJan 3, 2013 12:02 PM (in response to Wayne Contello)
Wayne, thanks for prompt reply, I've tried following you instructions but I can't seem to get it to work. I can only select one row to get the 'convert to header row' command, selecting multiple rows removes this option. But even with one row selected as a header it still dissappears when I scroll.
Any ideas please?
Currently Being ModeratedJan 3, 2013 12:09 PM (in response to nitrous_cyclings)
Currently Being ModeratedJan 3, 2013 12:25 PM (in response to Wayne Contello)
Wayne, Great got it now, I need to think a bit differently than before.
Barry, I'll read up on guidance, I think I'll have too given my poor start to using it!
Currently Being ModeratedJan 3, 2013 12:51 PM (in response to nitrous_cyclings)
The best places to set the Header and Footer Rows, and Header Columns, are in the Format Bar and the Table Inspector. Here's the Table Inspector example:
Your Header options depend on which View mode you are in; Sheet View or Print View.
In Sheet View, where the Sheet is one huge page, you see:
Note that in the drop down menu you can choose the number of Header Rows and whether they are Frozen.
In the Print View, you see:
In this case, you can set the number of Header Rows and also choose to repeat the headers on each page.
These same controls appear on the Format Bar contextually.
The view you are in can be set in the lower left corner of the window, or in the View menu, first item: View or Hide Print View.
Currently Being ModeratedJan 3, 2013 2:37 PM (in response to Jerrold Green1)
Cheers Jerry that was what I originally wanted to do! I've certainly learned a bit about about numbers tonight. Thanks for replies.