how to print selected cells in numbers

"Wouldnt it be most simple to simply highlight those cells with data and print that selection?"

Hi Chris,

No.

It might be if Numbers offered the menu option File > Print Selection.

But it doesn't.

But this is not Excel. You are not required to have an ocean of empty cells surrounding an island of data.

What would is simplest is to start with a table that contains only the rows and columns that you are actually using:

If you expand the team to include more players, it's quite easy to add a row to the table for each player.

If you expand the list of position categories, it's just as easy to add a column for each new category.

Regards,

Barry

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.

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

select the cells, copy,

open Preview

select the menu item "File > New From Clipboard"

print

Every response seems to miss the point. Numbers can't do what we want!

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

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.

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

While the tip for selecting and copying/pasting the desired rows to Preview and printing from there did technically "function", I still couldn't achieved the desired result. Why? Because when I printed from Preview, the output was too small! It didn't scale to the greatest width of the page. When I tried another print-option, it cropped off the sides. Grrrrrr. It seems the better method, at least for me, was to hide-columns. How annoying.

C'mon dude - I came here to look for answer and to engage with people about an element that I, and maybe others, feel is a limitation of Numbers (in our opinions). Not to come here and be told how to set up my desktop and/or my workflow is ugly and/or inefficient. Really not necessary, but thanks for your input.

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

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.

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.

Hello YellowBox. I know this is an old thread, but I hope you still receive this reply.. I do feel that a print selection is necessary for the example I am going to show you.. I have this sheet set up for playing time and rotations of my players for an upcoming game. I only want to print the cells that contain content. Wouldnt it be most simple to simply highlight those cells with data and print that selection?

Thank you

Hi Chris,

Can I highlight and delete both the unnecessary rows and columns until such time I need to add new players and then add more rows?

Yes.

I have a small custom template

My Numbers Preferences are set to make that my default template

To add rows, select any cell in the bottom row and press enter.

To add columns, select any cell in the rightmost column and press tab.

Regards,

Ian.