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
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.
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
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
"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.
"...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.
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.
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.
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.