Numbers and page orientation solution for Numbers
Show the Inspector panel.Go to the 2nd box Sheet at top and youll see Page Layout.
via Apple – Support – Discussions – Numbers and page orientation ….

Show the Inspector panel.Go to the 2nd box Sheet at top and youll see Page Layout.
via Apple – Support – Discussions – Numbers and page orientation ….

Barry says
Hi Herbert,Click on a cell anywhere to show the column and row reference tabs.Hover the mouse over the reference tab for row 1, then click the triangle that appears.Choose the first item in the popup menu—Convert to header row.Repeat for row 2.
via Apple – Support – Discussions – How to make an existing row a header? ….
Apple – Support – Discussions – Drag sheet from document to another? …. This isn’t literally possible but a great idea. You can achieve this however by following Barry’s suggestion.
Apparently not possible. You can, however Select the sheet in the source document, Copy it, then Select any sheet in the target document and Paste.
The pasted sheet and the objects it contains will be added to the target document.
If you select a table on one of the existing sheets in the target document. or select a cell on a table. the Paste will add the objects on the source sheet to the sheet containing the selected table or sheet on the target document.

GTR gives a clear and logical answer here. What at time saver this would be!
Barry has a couple of good suggestions. Sort of obvious when you think about it. One way is to narrow the size of the column.
You can do so with Barry’s great programming skill. He is a very helpful contributor!
Looks like Yvan has a script on doing this. Excellent work.
“Such a script is available for months on my idisk :
<http://public.me.com/koenigyvan>
Download :
For_iWork:iWork ’09:for_Numbers09:NombreEnLettres.zip”