Q: NUMBERS v.3.0.1
-
Dec 19, 2013 4:30 AMby Yellowbox,Hi herbfox,
Print View and Layout View have gone in Numbers 3. Here is a long answer to a short question.
Hints on workarounds here:
23622372
In particular to your question,
How do I print part of of a spreadsheet?
1. From Barry. (A workaround for Numbers 3, and this was useful in Numbers 2 also.)
Select the portion of the table you want to print. Copy.
Open Preview.
Go File (menu) > New from Clipboard (or press command-N)
Print the resulting PDF document in Preview.
2. Also (not a workaround because Numbers 3 has this feature).
Numbers > File > Print… shows Print Preview.
Click on the Print… button bottom right.
You will see the print dialogue box. Choose which pages to print.
Show Print View and Show Layout have gone. Workaround hints:
Work out where the pages are in print preview and then draw a line on the side of your Sheet. That line will hold it's position if you make changes to your row heights or add photos etc. It will add pages to your overall sheet, but then just select the page range to print.
Export a modified Numbers file to Numbers '09, make any required print view adjustments there and save. Then open in Numbers 3.0 and see if it prints okay. You may find that one line spills over to the second page; deleting one blank line may make a second try perfect. Perhaps the top or bottom margins are smaller than the default size in 3.0.
Menu > View >Show Rulers. Drag Alignment Guides from a ruler to where you want them. Caution: the rulers and/or Alignment Guides may not be accurate. Try Format Inspector > Arrange > Position (or Size) to see if that works better for you.
Menu > Numbers > Preferences > Rulers > Alignment Guides. Turn on (tick) both guides. That allows you to align objects with *each other* (as well as with the ruler guides). These guides help to align objects left, middle, right, top, bottom.
Select multiple objects (command click), then Format Inspector > Arrange > Align (or Distribute). Also under Menu > Arrange.
When duplicating an object (such as a nicely formatted Table that you want to reuse) select the Table, copy, and before you paste, click on the canvas below. Pasted Table will automatically align with the original. This will sometimes work if you click on the canvas to the right. I haven't worked out why it will not always paste neatly on the right.
Menu > File > Print to see the Print Preview. Use the Content Scale slider.
No way to set margins. Workaround: Print the document as PDF. Open the PDF in Preview and use the Cropping Tool to crop out the white space.
Also, see where you can delete blank rows or columns, or make columns narrower, or drag objects to reduce white space. Not as easy as editing in Print View in Numbers 2, but you are still responsible for (and in charge of) the final look!
****
Features that Apple has promised to reinstate:
http://support.apple.com/kb/HT6049
What has been GAINED in Numbers 3 is here:
https://discussions.apple.com/thread/5473882?start=75&tstart=0
What has been lost in Numbers 3 is here (with corrections where Apple has already reinstated some lost features in the Numbers 3.0.1 update):
https://discussions.apple.com/thread/5470448?start=240&tstart=0
Regards,
Ian.
