Long time Excel user that is converting to Numbers. I have spreadsheets that I need to print certain rows on a page, easy to do in Excel. In numbers I can’t find a page break command nor a page preview that would let me at least enter blank rows until the data is on separate pages. Any ideas?
—–
Patrick
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Insert a Page Break In Numbers?
Comments: One Response to “How Do I Insert a Page Break In Numbers?”
Comments Closed.
Printing in Numbers is completely different than in Excel. In Excel, a single table is an entire printed document. However, in Numbers, a "sheet" can contain (and often does) many different tables, charts and other elements.
So you'll need to re-think how you print, if you still need to print your documents.
One way to do this is to copy and paste the section you need into a new sheet temporarily, so that you can print that section. Another method is to print and use the PDF>Open in Preview option, then select the area you wish to print, and quickly create a new Preview document by copy and paste, and print that. It sounds like a lot of steps, but it only takes a few seconds.
It is hard to suggest other alternatives without knowing the details of what your sheet looks like, what information you have there, and how and why you only want to print some of it. For instance, simply hiding rows could be a quick and easy solution in many cases.