Previous 1 2 Next 15 Replies Latest reply: Oct 29, 2013 4:44 AM by jordoapp
Cycles4Fun Level 1 Level 1 (5 points)
Is there a way to export just a single sheet of a Numbers spreadsheet? I have created a dashboard that I would like to publish as a PDF. The first two sheets are data and the third sheet is the dashboard. I don't want to include the raw data with it, just the dashboard. Is there a way to do this?

MacBook Pro 15.4, iMac 20, iPhone 3G, iPhone 4, iPad, Apple TV, Mac OS X (10.6.6)
  • Level 8 Level 8 (41,780 points)
    May you ask a precise question ?

    Are you really asking about sheets or about tables available in different sheets?

    (1) If the dashboard is the unique table embedded in a sheet, use Print > in a PDF file to print only the sheet embedding the table.

    (2) If the three tables are in a single sheet, you must move the 'extraneous' ones in an other sheet so that you will match case (1)

    It's really boring to have to guess what the poster is really asking about. Is it so difficult to describe completely the asked problem ?

    Yvan KOENIG (VALLAURIS, France) jeudi 3 mars 2011 17:10:20
  • Badunit Level 6 Level 6 (11,380 points)
    As Yvan said, use Print and choose one of the "PDF" options. You can create a PDF of the entire document (all sheets), just the current sheet, or selected pages from the current sheet. If you want to print a single table, it must be the only thing on the page. While in Numbers, not in the print dialog, use Show Print View (click the View button on the toolbar) to see how your pages are laid out and you can move things around to get the look you want.
  • Cycles4Fun Level 1 Level 1 (5 points)
    Thanks Badunit,

    I saw that part of Yvan's response and used it. It worked exactly as I hoped. I had forgotten that technique and was looking at the export function.

    Rob
  • Cycles4Fun Level 1 Level 1 (5 points)
    Ivan,

    I see no reason to be rude. I asked precise question.

    "Is there a way to export just a single sheet of a Numbers spreadsheet?"
  • Badunit Level 6 Level 6 (11,380 points)
    Rereading my response, the phrase "it must be the only thing on the page" isn't an accurate statement. Other things can be on the page (text boxes, shapes, etc). I think you got the idea; I'm clarifying it for new people who may run across this thread.
  • Level 8 Level 8 (41,780 points)
    Cycles4Fun wrote:
    Ivan,


    I see no reason to wrongly type my first name.

    I see no reason to be rude. I asked precise question.

    "Is there a way to export just a single sheet of a Numbers spreadsheet?"


    The use of Print in a PDF is so widely spread that I was wondering if you were really asking about sheets.
    Knowing that you were ignoring this feature I wouldn't have ask for precisions.

    Yvan KOENIG (VALLAURIS, France) vendredi 4 mars 2011 11:20:17
  • nakulchandakonmacbook Level 1 Level 1 (0 points)

    Hi I Wish to ask in the same line

     

    which is - I have a excel document which i have imported in my iPAD 2 via numbers app.

    this excel document has 10 sheets each labled from 1 to 10 differently.

     

    Now i want to email only sheet number 2 which has only one A4 size information on it.

     

    in this case who do i do the pdf exporting of only the sheet number 2 from my entire excel document.

     

    numbers exports the entire excel file to pdf and attachs the same in my mail app. but i only want the sheet number 2 from my entire set of sheets from my excel document

     

    pls help

     

    Regards

  • Barry Level 7 Level 7 (29,210 points)

    "Hi I Wish to ask in the same line"

     

    Well, the answer, for any document in any application that can access the print dialogue on the Mac, is pretty much the same.

     

    Press command-P to open the Print dialogue, set the page range you want to 'print', click the PDF button and choose one of the options.

     

    You'll get a PDF version of the page(s) you chose to 'print.'

     

    If you're asking about doing this from your iPad, that's a whole 'nuther question and a whole 'nuther community.

     

    You'll find the expert answers for that question here: Using iPad or here: iWork For iOS.

     

    Regards,

    Barry

  • nakulchandakonmacbook Level 1 Level 1 (0 points)

    Sorry Barry

    U thought this section would answer my question

     

    I shall post again in the using iPad section

     

    For mac I knew but u think the feature is not there for iPad 2 running numbers

     

    It's such a big drawback of numbers as a whole software

  • Barry Level 7 Level 7 (29,210 points)

    "...but u think the feature is not there for iPad 2 running numbers"

     

    Not what I said at all.

     

    This is the Numbers community. Poorly named, as it really handles only the Mac version of Numbers. You can find a few Numbers for Mac experts here, but not many of the people here use an iPad. We don't "think the feature is not there for iPad," we simply don't know whether it is or not. That's why we refer Numbers for iOS questions to the (also poorly named) iWork for iOS community, where there's a better chance of finding someone who does know.

     

    Regards,

    Barry

  • SorenFloripa Level 1 Level 1 (0 points)

    Going through the print dialog is really a workaround. Apple (if you are listening) should really allow for a choice of sheets when exporting from numbers, especially since they have not provided a Print Area option. It is just too easy to erroneously include unintended background calculations.

     

    The export option has the advantage over "printing" to pdf that you do not need to fiddle with your page setup to avoid that your sheet gets chopped up leaving orphan lines or columns on additional pages.

  • Jerrold Green1 Level 7 Level 7 (29,855 points)

    Soren,

     

    So you wish to Save a file in Sheet View to PDF, saving only 1 Sheet...

     

    o Click on the Sheet name in the Sheets Pane and Command-C

    o Switch to Preview.app

    o Command-N

    o Command-S

     

    Jerry

  • Barry Level 7 Level 7 (29,210 points)

    Hi Soren,

     

    Your wrote (numbers added):

     

    "1. Going through the print dialog is really a workaround.

    2, Apple (a) (if you are listening) should really (b) allow for a choice of sheets when exporting from numbers, especially since (c) they have not provided a Print Area option.

    3, It is just too easy to erroneously include unintended background calculations."

     

    1. I beg to differ. A PDF file is the electronic version of a printed document. When you print, you create a static document on paper. When you 'print' to PDF, you create a static document as a file. The ability to 'print to PDF' is universal—it's available to every application that runs on the Mac and has access to the Print dialogue.

     

    2a. Apple does not actively monitor these user-to-user forums. If you want to suggest this 'feature enhancement,' your best route is through the Feedback channel. Go to the Numbers menu in Numbers '09 and choose Provide Numbers Feedback. Feedback goes directly to Apple.

     

    2b. When you Save a document, you save the entire document. When you Export a document, you export the entire document. The reult is a live' document, not the static one you get by printing or creating a PDF.

     

    2c. Print Area is necessary in an application like Excel, which produces a huge, monolithic table populated by islands of data. The Numbers model differs, allowing for creation of several small, single purpose tables on one or more sheets within a single document. Once that concept is grasped and put to use, there's little if any need for Print Area.

     

    3. True, if you use Numbers as if it were Excel. Much less true as you gain the knowledge of the differences and start using Numbers as its designers intended.

     

    Regards,

    Barry

  • jordoapp Level 1 Level 1 (15 points)

    Hey Jerry - I used to use this hack / workaround religiously and appreciate you posting it for others to find. I'm curious if you have tried it on OS X 10.9 and Pages / iWork '13, if not, I would like to prompt you to do so as a couple things have changed:

    1) Alpha is not on immediately, this can be turned off when saving

    2) Bigger problem is the quality in which Preview.app is presenting the copied content, if you have a large doucment you are "exporting" via this method, it gets pretty gnarly.

     

    Best wishes,

    Jordan

Previous 1 2 Next