dc2slo

Q: HELP!! with Numbers 3.0  I need to see my page breaks.

I want to be able to work on my spreadsheet so that I can see where the page breaks are.  In the old version you could actually work in Print View.  Does anyone know how to show my page breaks besides actually go to print the sheet?

Posted on Nov 3, 2013 11:42 AM

Close

Q: HELP!! with Numbers 3.0  I need to see my page breaks.

  • All replies
  • Helpful answers

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Nov 3, 2013 6:07 PM in response to dc2slo
    Level 7 (30,001 points)
    Nov 3, 2013 6:07 PM in response to dc2slo

    DC,

     

    Use the Feedback option in the Numbers menu to tell Apple that you miss that capability.

     

    Jerry

  • by SGIII,Helpful

    SGIII SGIII Nov 3, 2013 6:47 PM in response to dc2slo
    Level 6 (10,782 points)
    Mac OS X
    Nov 3, 2013 6:47 PM in response to dc2slo

    Numbers 3.0 is great if you want to move more toward a paperless and dynamic approach, where you share and display your work (interactively if you want) online or on an iPad or another Mac, with automatic syncing so you don't have to fuss with moving documents back and forth. 

     

    For obvious reasons Apple would prefer that you send your output to an iPad or a Mac screen or iCloud to show people rather than print it out on paper using equipment manufactured by other companies. For many purposes that is a more efficient approach anyway. It saves trees, saves time, saves costs, and allows recipients to easily view your data in different ways. Among spreadsheets Numbers 3 does this best right now; in fact it does it very well.  If they continue to develop it, it is going to be tough to beat.

     

    But if you need to print out a lot of things on paper or to pdf in a traditional static fashion with precise margins and all that, Numbers 3.0 can't compete with Numbers 2.3 or Excel.  It can print, but just isn't that easy.

     

    SG

  • by Jerrold Green1,Helpful

    Jerrold Green1 Jerrold Green1 Nov 4, 2013 9:14 AM in response to dc2slo
    Level 7 (30,001 points)
    Nov 4, 2013 9:14 AM in response to dc2slo

    DC,

     

    If you like other features of Mavericks-era iWork and want to stay with it, I suggest that you consider Editing you spreadsheets in Numbers and Publishing them in Pages. In Pages you can control your layout and decorate your project the way you used to be able to in Numbers. Just Copy the tables in Numbers and Paste into Pages. If the tables are long enough that they need to flow across page boundaries, make sure that they are "inline", now called Arrange > Move with Text. One warning though - Pages can only handle table of 999 rows or less.

     

    Jerry

  • by dc2slo,

    dc2slo dc2slo Nov 4, 2013 9:32 AM in response to dc2slo
    Level 1 (0 points)
    Nov 4, 2013 9:32 AM in response to dc2slo

    Thank you for all of your feedback.  It looks like the best answer is to stay with the old version or buy Excel. 

  • by SGIII,

    SGIII SGIII Nov 4, 2013 9:36 AM in response to Jerrold Green1
    Level 6 (10,782 points)
    Mac OS X
    Nov 4, 2013 9:36 AM in response to Jerrold Green1

    Hi Jerry,

     

    That's a great tip. I've never had Pages. (It seems I don't qualify for a free copy based on my ownership of Numbers 2.3).  I didn't know it could work that way with Numbers.  Given its name, one would think it would be good at laying things out on pages. But one never knows what the software designers are thinking these days.

     

    SG

  • by Lock Low Man,

    Lock Low Man Lock Low Man Dec 12, 2013 5:43 AM in response to dc2slo
    Level 1 (0 points)
    Dec 12, 2013 5:43 AM in response to dc2slo

    Okay, so, to make sure all my stuff is laid out correctly in Numbers, my choices are:

     

    • Go back and forth and back and forth between the print preview and the document, adjusting blind and checking if I got it right.
    • Exporting to a different program entirely, be it Excel or Pages, wherein if I make any changes to the tables themselves I have to go back to Numbers, make the changes, export again, etc, to make sure my Numbers document and the printing document are in Sync.
    • Live with it looking ugly. Which will cause dialogue like:

     

                   "Hey, what did you use to make these tables, they're all misaligned, it looks pretty sloppy."

                   "I used Numbers."

                   "Please don't use Numbers on anything we have to show to clients."

     

    The one huge advantage of Numbers used to be that you could use it to layout pages with multiple tables.

     

    The multiple tables are still here, the layout ability is (for all significant purposes) gone.

     

    I filed a Feedback complaint on this, I suggest that anyone who cares do the same.

  • by Yellowbox,

    Yellowbox Yellowbox Dec 12, 2013 5:54 AM in response to Lock Low Man
    Level 6 (10,515 points)
    Mac OS X
    Dec 12, 2013 5:54 AM in response to Lock Low Man

    Hi Lock Low Man,

     

    Here is my boilerplate reply to you. Do what you will.

     

    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

     

    Hints on workarounds here:

    https://discussions.apple.com/message/23622372#23622372

     

    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.

  • by Badunit,

    Badunit Badunit Dec 12, 2013 8:35 AM in response to Lock Low Man
    Level 6 (11,705 points)
    iTunes
    Dec 12, 2013 8:35 AM in response to Lock Low Man

    Lock Low, you are preaching to the choir here.  I've heard no one say "I am so happy Apple removed print view and margin adjustments (etc etc etc). It makes Numbers so much better and easier to use". Not a peep.

  • by C-Lo D,

    C-Lo D C-Lo D Jan 10, 2014 10:01 AM in response to SGIII
    Level 1 (0 points)
    Jan 10, 2014 10:01 AM in response to SGIII

    Respectfully, it is ridiculous to think that people don't need paper and that we saving trees (and we all here know we are certainly not saving any time on this). People are going to print whether they use numbers or not, they just won't use this product anymore.  For work I NEED to have paper copies of some of my documents that I mail out to other vendors, as do they need a paper copy. I work on weddings, and I can't rely on every vendor to have an ipad tucked into their pant pocket for a timeline while they're running around setting up for a wedding.  I was so embarrased to learn that when I exported what should have been a 3 page pdf doc to them, it printed miniature on one page.  Now it is going to waste a whole lot more of my time reformatting my templates into excel so I can actually send them to clients.

  • by SGIII,

    SGIII SGIII Jan 10, 2014 11:18 AM in response to C-Lo D
    Level 6 (10,782 points)
    Mac OS X
    Jan 10, 2014 11:18 AM in response to C-Lo D

    Hi C-Lo D,

     

    You can give feedback to Apple via Numbers > Provide Numbers Feedback.

     

    Assuming the hundreds of wedding planning apps available for the iPad and Android devices are downloaded and used, then it seems many people are not nearly as paper-based as they were just a few years ago.

     

    Having said that, it would be nice if Apple beefs up print capabilities in Numbers 3. They have suggested they will do just that, in the support document linked to in Ian's post.  Specifics are scarce.

     

    However, as I said upthread, if you need to print out a lot of things on paper or to pdf in a traditional static fashion with precise margins, etc., then you're better off with Numbers 2.3 or Excel.  Those products, however, don't play well with mobile. And, like it or not, mobile is on the rise.

     

    SG

  • by C-Lo D,

    C-Lo D C-Lo D Jan 10, 2014 1:32 PM in response to SGIII
    Level 1 (0 points)
    Jan 10, 2014 1:32 PM in response to SGIII

    Hi SG,

     

    Thanks for taking the time to respond. I do intend to leave feedback.  I completely agree that there are tons of great tools out there in the wedding world, though I still need a good program to use to type up docs and 95% of those tools have nothing to do with what I do, as they are targeted towards my client, not to my business. When I send a timeline to 40 people, I can't assume that everyone has a smartphone or tablet to view on.  Just to be clear, I LOVE apple, I think in my home we have 9 apple products for just two of us.  I would venture to guess that most people on here do, but I can't assume that every soul I'm working with is using the same technology, nor would it be very convenient for my client or her maid of honor or whomever, to carry around her ipad that can't be tucked into a tiny purse, or may vibrate, or make sure she logs into her Numbers app or email to view it. I have to make things as simple as possible for my clients, as I believe is in accord with apple's outlook on their products.  I know that not everyone on here has remotely close to the same work situations I stumble upon daily, but it seems by the number of people viewing this topic that I am not alone.  I don't "not like" that mobile is on the uprise, but I don't work alone and I would still like to be able to use apple products to communicate with other people.

  • by SGIII,

    SGIII SGIII Jan 10, 2014 2:19 PM in response to C-Lo D
    Level 6 (10,782 points)
    Mac OS X
    Jan 10, 2014 2:19 PM in response to C-Lo D

    Hi C-Lo D,

     

    Not that it's as good as a paper solution for what you do, but keep in mind that Numbers displays surprisingly well on an iPhone too, much better than I would ever have thought.  There seem to be iPhones being pulled out of purses everywhere these days.

     

    And remember it is quite easy to take screenshots (from Mac, iPad, or iPhone) and print those to paper or convert to pdf (or whatever) as needed for viewing on any device..

     

    And you can share a Numbers document in a way that anyone with a modern browser can view it and edit it. They don't even need a Mac. Nor do they need an iCloud account.

     

    Having said that, I'm hoping Apple will make it easier to control printouts from Numbers 3 for Mac.  For documents with precise printing requirements (there are fewer of these as time goes on) I use Excel.

     

    SG