I have a 2800 row 2 column spreadsheet I want to print. The table only takes up half a page, so if I click Print, 6 pages per sheet, there is a lot of space between each table and it is reduced in size. I would like to print multiple tables per page without so much space between the tables so I don't have to print 82 pages. What is the best way to do this?
MacBook Pro 13″, macOS 10.13
Thanks for the help.
If I do this in the future, is there a better way to set it up before I start so I can have 3 columns per page and it will just continue to the next one automatically as I am inputting data?
I don't immediately see a way to sort a 'full column" once it has been split into three columns.
You could, though, create a second table containing three columns, then use INDEX to extract the contents of the first third of the rows of the original table into the first column of the new table, a second set of ndex to do th same for the middle third in column 2 of the new table, and a third set to bring the results from the bottom third into the third column.
As the index values would be based on the ROW() function, the second table would mirror the segments of the first even after the first was sorted.
Placed on a separate sheet, the second tble's three columns could be printed by speciying the sheet number to send to the printer.
Regards,
Barry
I would still need to be able to sort the data also.
Your table is a single object, like this shape:
The object is taller than the sheet of paper on which it is being printer, and (in the case of the spreadsheet ) has places (row boundaries) where it can be split when the current page does not provide sufficient room to accommodate the whole table.
Horizontally, though, there is no lack of space to accommodate thewidth of the object, and from Pages' perspective, no reason to split the object,
IF this were text, not contained in the cells of a table, you could set the layout of the pages to four columns and let the text flow into those columns.
BUT that is a text layout format, and presumes starting with a single column of linear text, not two columns of structured text in a table.
One process that might work to fit the task, but that is relativily labour intensive:
Press command P to open Print Setup.
Press command-P again to open the print dialogue,
Click the PDF button at bottom left of the Print Dialogue, and choose Open in Preview.
In Preview, copy each page using either control-click and copy image or taking a screen shot of the table part only, then Paste that image onto a new Pages document, and resize to fit as many as desired on each Pages page.*
Print the Pages document.
*You may find it useful to create a custon 'half-legal' page size for your printer to place the original table into while avoiding the empty space to the right of the table in the PDF image produced by the printer's PDF option.
Regards,
Barry
Printing a long spreadsheet in Numbers 10.2
