how to print selected cells in numbers

Jan,

The two questions use the same basic answer. In OS X, printing an Object Selection is easily handled in Preview.app, and the native file type there is PDF.

Here's the procedure:

Select the cell range in Numbers and Command-C to copy it to the Clipboard

Launch or switch to Preview.app

Command-N to create a PDF file from the Clipboard content

Command-P to Print

Command-S to save the PDF file

Regards,

Jerry

You have got to be kidding me? This is how Numbers prints a selection? Unbelievable!

There's another answer, though Jerry's works just fine. I'm just offering a different way to look at the problem.

If the cells you're selecting are complete row(s), you can use the "Show" feature to limit what rows are seen on screen ... then just a regular print or save-as-pdf in the print dialog box will work.

Hover on the letter indicator of any column (A, B, etc.), and click on the small triangle that's on the right. Click on "Show More Options" and the 2nd option is "Show rows that match the following". Set up whatever criteria you need. Click the box and =presto= the other rows disappear. They're still there, usable for any calcuations, but unseen.

You can also "unsee" any specific columns you dont' want visable. Again, just hover over the column letter and click on the triangle. "Hide this column" will do the trick.

Vince

select the cells, copy,

open Preview

select the menu item "File > New From Clipboard"

print

Vince wrote:

"You can also "unsee" any specific columns you dont' want visable. Again, just hover over the column letter and click on the triangle. "Hide this column" will do the trick."

Also applies to several adjoining columns (or adjoining rows). Select the columns, reveal the triangle on one of them, and select Hide Columns from the pop-up menu.

Regards,

Barry

I know, right? In Windows, you can simply choose "print selection." But what else is new? Working on Apple software always requires six fingers, a third-party hack, and about triple the steps of working in Windows.

Numbers does not have Print Selection or Set Print Area because it does not need them. Numbers uses several discrete tables, each with a purpose. The Fruit table pulls values from the Very Big Data Table to produce a Presentation for printing. Similarly, a Vegetables table could the same, and so could any Department.

Each Presentation table can be on its own sheet. Formulas will link between sheets.

Choose a sheet

Command p (to see Print Preview)

Click on Current Sheet or This Sheet (depending upon which version of Numbers).

Confirm your intention to print.

Done.

Regards,

Ian.

Thank you for your suggestion, however, that isn't the same as the very-easy-to-use Print Selection feature in Microsoft Excel.

Hi nmygs,

How about this?

Cell A1 is a Pop-Up Menu containing names of the various "Departments"

Other cells contain formulas to find a match for whatever is chosen in A1 from the Very Big Data Table.

Reusable Print Me table. 😉

Regards,

Ian.

My thoughts exactly. This is an abomination. I thought I was just missing something obvious a la "set selected area for print" buried under some menu or cmd-key sequence. Surely there's another way. It's 2014 -- not 1984.

Surely there's another way. It's 2014 -- not 1984.

There may be some users that aren't quite as dependent on old-fashioned printouts in 2014 as in 1984. And when you do need to print out part of a document, Jerry's and Ian's suggestions do the job without much trouble.

However, if you feel strongly that you often need to print just parts of a document (and you don't want to redesign your document) then in your menu choose Numbers > Provide Numbers Feedback. We're just fellow users here.

SG

Hey, Wayne, could you explain how your method differs from Jerry's upthread? (The first reply to OP).

SG

Thanks for the reply. Why does it copy Table Name? How to avoid it?

Hi Chris,

Hide the table name in Format Panel > Table > Untick Table Name

Thank you so much, YellowBox