Currently Being ModeratedJan 2, 2013 7:35 AM (in response to canalhopper)
select the sheet you want to duplicate then selecting the menu item "Edit > Duplicate". You can also hold the option key, then click and hold, then drag to duplicate, then release
Currently Being ModeratedJan 2, 2013 1:30 PM (in response to Wayne Contello)
Thanks Wayne. I did that, and got a new sheet, exactly like the first one, so that was a bonus, except that it also comes up with all the data on it which I had input....
An empty one would have been good, so that I could continue inputting the data. Is there a way of doing that?
What I'm actually doing is making a list of all the Christmas cards we received this Christmas, in alphabetical order of surname, so I would like the pages to roll on after each other, showing the names in alphabetical order.
Currently Being ModeratedJan 2, 2013 3:05 PM (in response to canalhopper)
You could just make your first table longer, reaching into a second page on the first sheet. In fact, you could go on for years to come adding christmas cards to your original table.
Just drag the Add Rows Handle at the lower left corner of the table to add rows.
Click on a cell in the table and the handle will appear.
Currently Being ModeratedJan 2, 2013 3:22 PM (in response to Jerrold Green1)
Brilliant Jerrold. Many thanks. That's just what I wanted. I haven't tried printing it out yet, but presumably it will just sort itself out into pages? Thank you once again.
Currently Being ModeratedJan 2, 2013 7:17 PM (in response to canalhopper)
Depending on how your margins are set and the height of your table rows, you will get some number of rows per page. Your only control of where the pages break is with those controls. Margin setting is a Sheet Property and can't be changed page by page, but if there's a particular row that you want to end a page with, just increase the height of that last row until the rows below pop to the next page.
If you have a Header Row, you can ask it to repeat at the top of each page, so you don't have to manually repeat the column headings.
Knowing how to easily change the dimensions of a table, in rows and columns, is amongst the basic stuff covered in the Numbers User Guide. You can get it from the Help Menu. A good read on a Winter's evening.