Numbers Print Two Copies per Page

I have a Numbers sheet that consumes 1/2 a page. Is there a print setup I could use to print 2 copies per 8-1/2 x 11 piece of paper?

MacBook Pro (13-inch, Late 2016, 4 TBT3), macOS Sierra (10.12.2)

Posted on Mar 19, 2017 8:54 AM

Reply
9 replies

Mar 19, 2017 11:05 AM in response to Bruce Kieffer

Bruce Kieffer wrote:


This works, but the size is shrunk too much.

As you already found, one page of PDF will fill the half of paper sheet on 2-copy/page printing.

You can try to adjust orientation and scale to make the sheet (tables, etc) fit in one page.

Numbers: [ Orientation=portrait, Fit=on ] (default)

User uploaded file

Numbers: [ Orientation=landscape, Fit=on ] -> Open PDF in Preview

User uploaded file

Preview: [ Copy per page=2, Orientation=portrait, Scale to Fit: & Fill enter paper=checked ]

User uploaded file

With these steps, I don't see difference much in the size of first one and last one.

Mar 19, 2017 9:27 AM in response to Bruce Kieffer

You can do 2-page/sheet printing in Details setting of Print dialog. ( actually up to 16 page/sheet )

For your case, adjust the scale (and change the orientation) to fit the table in one page on Print Preview.

Then,

  1. Hit the [Print...] button (bottom right), which brings up Print dialog.
  2. Hit [Show Details] button at bottom ( if Details is hidden )
  3. Choose [Layout] ( 1 in fig )
  4. Choose Pages per Sheet ( 2 in fig )

User uploaded file

This is standard feature on OS X and works on almost every applications.

Mar 19, 2017 11:36 AM in response to Bruce Kieffer

Hi Bruce,


The 'multiple pages on one sheet (of paper)' setting in the print dialogue when set to '2' will print pages 1 and 2 on the first sheet of paper, pages 3 and 4 on the second sheet, etc. It will not print two copies of the same page on the same sheet (unless you provide two copies of that page in the document).


IdrisSeabright's solution will give the result you want, and could be tweaked to avoid the need to edit both copies when changes are made in the table(s).


Here's an example:

User uploaded file

Table 2-1 is a copy of Table 2.

After copying, I replaced the contents of Table 2-1 with this formula, entered in cell A1, then filled down and right to the rest of the cells in the table:


A1: =Table 2::A1


I then locked Table 2-1 to prevent editing or moving that table, then made the changes show in the center block of Table 2:

User uploaded file

Results are shown in Table 2-1. Note that the Content, including the formatting (bold) of that content is transferred, but the formatting (colour fill) of the Cell(s) is not. Cell highlighting applied by a conditional highlighting rule would not be transferred, but if the corresponding cells on each table had the same CH rules applied, their highlighting, controlled by the rule(s) and the cell's content, would also match.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers Print Two Copies per Page

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.