-
All replies
-
Helpful answers
-
Oct 31, 2013 11:17 AM in response to Werner 2ndby Jerrold Green1,Numbers 3.0 has fixed, preset margins. Not much we can do about that. It's very difficult to adhere to margins anyway since it's impossible to see where they are.
My suggestion, having thought about this for a few days, is to create your tables and charts in Numbers and Copy/Paste them over to Pages for publication. Probably the best way to get to Pages with a graphic, like a Chart, is to pass through Preview and bring it in as a PDF. Tables transfer very nicely as long as you set them to Move with Text if they are Long and Stay on Page if they are smaller than a page.
Jerry
-
Oct 31, 2013 11:27 AM in response to Jerrold Green1by Werner 2nd,Maybe they are promoting the sales of Microsoft Excel?
-
Oct 31, 2013 1:28 PM in response to Jerrold Green1by jmtl,Not including document setup and page margins in Numbers 3 is a step backward.
Copying tables and information from a worksheet into Pages for printing is needless busywork and completely inappropriate for any kind of workflow..
Removing useful features from Numbers '09 resulting in documents that cannot be printed on letterhead or preformatted forms is a serious mistake.
Please don't try to placate a fellow user with "it's very difficult to adhere to margins." On the contrary, margins worked until today. Less-than-obvious, sure? But that's much better than undocument and fixed margins.
Apple is sending me back to Excel.
-
Nov 12, 2013 12:49 AM in response to Werner 2ndby Suzyplums,I'm visually impaired and having to move number docs accorss to pages via preview is just rediculous.
If I wanted to make life hard for myself I would go back to a windows.
I love working with Apple peoducts please give us back our page set up in numbers
by the way I got round this was to go full page, screen grab and print. Still a very silly way to do things
-
Nov 12, 2013 7:24 AM in response to Suzyplumsby Jerrold Green1,Suzy,
Have you tried doing your composition in Pages, rather than Numbers. Tables can be copied over easily.
Jerry
-
Nov 19, 2013 2:18 AM in response to Werner 2ndby Momadi,Werner 2nd
This ia a work around because you cannot adjust the margins of your selected paper size in Numbers 3.
Export your table to pdf format and open in Preview. Select Print and make sure you can see the details. Adjust the scale below the Autorotate selector to maximize the table size on your selected paper and print. Works OK on my Docuprint CP205 but my Photosmart ink printer cuts off at the bottom of the sheet.
Good luck
Malcolm
-
Nov 19, 2013 5:17 AM in response to Suzyplumsby Yellowbox,Hi Suzy,
by the way I got round this was to go full page, screen grab and print.
Thank you for this idea. I will try it out.
I find these ideas, gleaned from other users, helpful:
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.
More hints on how to work around the new ways forced upon us by Numbers 3.0 can be found here ("Workarounds in Numbers 3.0?")
https://discussions.apple.com/message/23622372#23622372
Regards,
Ian.
-
Mar 3, 2014 10:35 AM in response to Jerrold Green1by chappa-ai,No page setup tools in Numbers is just yet another design logic MISTAKE by Apple. I recently "upgraded" to newer versions of the iWork applications, and I must say they are not near as user-friendly nor as functional as the '09 versions. Apple needs to stop monkeying around with things that aren't broken and stop taking away useful features in alleged "upgrades". Now I need to create my tables in Pages instead of Numbers just so I can have access to page layout tools? That's stupid and negates the whole reason for having Numbers (an inferior and mediocre substitute for Excel) in the first place! I switched from Excel to Numbers because I don't agree with the Micros**t mentality of usurping a user's computer with incessant updates and horrendously SLOW application performance, but the new version of Numbers is worse than its previous version, making the other beast slightly more appealing now. Maybe it's time for me to try OpenOffice on my system. Apple doesn't seem capable or competent enough anymore for sensible software decisions.
-
Mar 3, 2014 10:43 AM in response to chappa-aiby SGIII,Hi chappa-ai,
Please see this page. And if you have feedback to give Apple you could try Numbers > Provide Numbers Feedback in your menu. We are just fellow users here.
SG
-
Mar 4, 2014 11:49 PM in response to Werner 2ndby Adj007,well, i finally ditched windows pc, just spent in excess of £3500 on imac and macbooks..
having been blown away by the packaging and how easy to set it all up, my first job was to produce a very very simple numbers spreadsheet for a quotation.. about 6 pages long..
then when i go to print it out all a want to be able to do is set the page margins so i can have the exact breaks in my information on each page..
at the moment i keep going back and forth from the preview screen, inserting rows or deleting ones to get a page break exactly where i require it, its really awkward.
surely im doing someting really daft here, as everything else has been an amazing experinace so far but for the life of me i can find a page margin/break feature..
i cant believe that the software writers could make such a schoolboy error... so it must be an error my end..
please help..
thanks
-
Mar 5, 2014 12:30 AM in response to Adj007by Yellowbox,Hi Adj,
Many features have been lost in Numbers 3. You can send feedback to Apple with Menu > Numbers > Provide Numbers Feedback.
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.1 update):
https://discussions.apple.com/thread/5470448?start=240&tstart=0
Hints on workarounds here:
https://discussions.apple.com/message/23622372#23622372
In particular,
Try Alignment Guides and Rulers as suggested here:
Numbers has never had Page Breaks. The Numbers approach is to have several tables, each with a purpose. For example, an input table, a number crunching table, and a "Presentation" table to summarise results.
If your quotation runs to six pages, perhaps you could have 6 tables designed so that each fits within a layout guide:
Option 2, if you previously had Numbers 2.3 (Numbers '09) it now lives in a folder called iWork '09 inside your Applications folder. It works just as well as it used to, and has a proper Print View.
Option 3, copy and paste your table to Pages where I believe the layout is easier to arrange (maybe).
Regards,
Ian.
-
Mar 5, 2014 7:49 AM in response to Werner 2ndby t quinn,Hi all,
I have a few tables that I really wanted to print with minimal margins. I exported it to '09 and set the margins there. I made sure that "use printer margins" was unchecked and ignored all the formulas that were now throwing errors. Opening it back up in N3 my margins are where I want them and the formulas are intact. This seems easier to me than getting Pages involved.
Quinn
-
Apr 2, 2014 8:09 AM in response to Werner 2ndby jmtl,Hurrah! The latest update to Numbers (3.2) has returned the Margin settings as an option. In the File menu, choose Print… (command-p) and in the settings on the right you will now have page margins.
These settings can be applied to the current page or the whole document.
These settings DO NOT apply to the Export -> PDF.
If you want a formatted PDF with margins of your choose, click the Print… button (bottom right) and then select the PDF output you want.
-

