Currently Being ModeratedMar 31, 2011 10:33 PM (in response to hotwheels 22)
hotwheels #22 wrote:
I am pulling down to "Paper Handling" and selecting "Scale to Fit Paper Size" (seems pretty straighforward...)
It is pretty straightforward. Scale to fit "paper size" does not mean scale to fit on a "single page". It means "resize this document so that one page of the document fits on one page of the size of paper I wish to print it on." This option in the Print dialogue is used when someone sends you a document laid out on an A4 page size, for example. If you Scale to fit paper size and choose US Letter, the content of the document will be scaled to fit one A4 page onto one US Letter page.
Would anyone mind walking me through how I 'manually' put information on separate pages in Numbers of how I insert a page break or whatever it is that I have to do to get my information to print out on a couple of 8 1/2 x 11 pages?
Numbers does not support the insertion of Page Breaks.
You can force two tables, which together would fit onto a single page, to print on separate pages by placing then on separate sheets. Each sheet will print as at least one page (but may print as more than one page, depending on content).
You can reduce the number of pages by:
Re-scaling the content using the Content Scale slider seen at the bottom of the window when Print View is shown.
Setting Layout in the Print dialogue to print 2, 4, 6, 9 or 16 pages on one page.
In addition to what Barry said, many new users need to be reminded that if you have blank columns and rows on your sheet, they are considered content. Numbers assumes that if you have a table, you want to print the entire table, blank cells and non-blank ones. In Excel there is an assumption that you don't want to print the millions of empty cells on the typical sheet. That's why in Excel you really need a Print Area command. In Numbers you don't need it. Your content determines what gets printed, and where.
So, if you have blank rows and columns that are causing extra pages to be printed, delete them before trying to print.
Jerry(dead)iMac G5, 10.5.8 / iMac Core 2 Duo & MBP, 10.6.6
PRINTING IN NUMBERS
• Numbers lacks the 'Set print area' command and the work around isn't that flash.
* make sure you're not in Print View - check the 'View' menu.
1. select the cells you wish to print
2. Choose 'Copy' from the 'Edit" menu
3. Click the 'Sheet' icon (top left corner of window, just below the red/orange/green buttons.
4. Choose 'Paste' from the "Edit" menu
5. Use the grey corner (at the bottom right corner of the pasted data) to resize the table - removing any unneeded columns/rows. The grey corner is highlighted in the sheet below. In this example, I'd remove column E as it contains no data.
6. Choose "Print" from the "Edit" menu.
1. Choose "Show Print View" from the "Edit" menu
2. Use the "Content Scale" slider at the bottom of the window, to scale the content so that it fills the page.
3. Choose "Print" from the "Edit" menu.
See examples below - see how sliding the scaler to 150% makes the content fill the page - but there are still empty columns (F&G) that can't be scaled away as doing so forces the data in the bottom rows, off the page. Hence, I think Option One is the better method.
Here's what I believe to be the most compact set of instructions for printing a segment of a table, filling a printed page:
- Select area of Table to be printed.
- Switch to Preview.app
- Select the Scale to Fit option in the Print Dialog
- Change the Portrait/Landscape selection if you wish
- Click Print.
Currently Being ModeratedMay 6, 2011 11:05 PM (in response to Jerrold Green1)
That's an even better solution. I posted my two solutions as hadn't found a documented useful solution, and there appeared to be lots of people with the issue. Plenty of people willing to bag Numbers, and compare it to Excel, but no solutions...
Change can be difficult and anyone coming to iWork thinking it's equal to Office but better since it's by Apple may be disappointed by the differences in the interface. Many of the differences aren't deficiencies. I think this Print Area thing is just a matter of habit, for instance. If you take the case where the area you want to print right now is different from the area you printed an hour ago and compare the number of keystrokes in Excel vs. Numbers, you won't find much difference, and Numbers offers much more flexibility in how it may be done.