1

Is there any way to set a print range in Apple Numbers.app spreadsheets, to print just a subset of cells rather than entire document?

  • I use a sheet specialized for printing and another for data. If that idea interests you, I'll post an answer. – bjbk Mar 30 '17 at 19:45
1

Apple's Numbers is designed in a fundamentally different way than Microsoft's Excel or other spreadsheet solutions. Numbers uses "Canvases" instead of large tables of thousands of columns and rows. This allows for placing tables, even those made up of a single cell, anywhere on the canvas needed. Instead of merging cells and hiding borders, (which of course can be done with Numbers) Numbers allows more freedom to create a document designed for printing. For example, placing text, charts or even graphics anywhere on the canvas that seems logical. Setting the print range in Excel only allows for a continuous subset of cells. Also, the ability to have several tables on a single canvas allows for more creative use of the space. (See this Apple Support article on printing with Numbers.)

One can still use a very large data set in a large table as well. However, this concept of making spreadsheets on canvases can open up many opportunities for print layouts. The OP does not state how their spreadsheet is laid out, but it appears from the brief description that is styled in a traditional manner, which is perfectly acceptable, but this limits how it can be presented for printing.

One method I use, particularly with printing off invoice or expense type sheets, is to keep the working data on a separate sheet from my print sheet. Using formulas, such as one would use in Excel, data can be easily and automatically displayed in a printable format.

Below is a very simple example. The Data sheet contains the data not for printing. The [Print] sheet contains two simple tables with a colored rectangle object in the background. Changing data in the Data sheet changes the totals in the Print sheet accordingly. In the case of a traditional spreadsheet, a subset of the table could be displayed in the print sheet, each cell with a reference to the corresponding data sheet cells desired to be printed. This table could then be formatted for printing by adjusting fonts, size and scaling as noted in the Apple Numbers Help link above.


Data Sheet [Non print]

Data non-printing sheet


Print Sheet

Print Sheet


Print Sheet - Print view

Print layout view

0

Select the menu item File > Print, then use the controls on the right to scale the content:

Numbers print settings

  • 1
    I don't see how this is a solution. We want to suppress some cells from appearing on the printout. Scaling magnifies/shrinks the printed content. – Basil Bourque Dec 5 '14 at 6:32
0

Looking at the image in this answer, I got inspired to try something and what I discovered is that if you play with the "content scale", adjusting the percentage or sliding the scale's button, you can achieve the same effect as window's print range moving of the blue lines. I did have to delete a couple of rows (that were empty to begin with) to make 4 pages turn into 2), so its not as convenient as Window's blue lines, but one can still make it work :)

0

Copy the selection to the clipboard, then choose "New from Selection" in the Preview app. Job done!

You must log in to answer this question.

protected by Community Mar 20 at 21:07

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .