Print partial spreadsheet

[bfstephen]

In the PC world, I used 'Set Print Area'; I cannot find any similar functionality in Numbers.

 

[RadDave]

In the PC world, I used 'Set Print Area'; I cannot find any similar functionality in Numbers.

Hello - welcome to the forum! You've not given us any information on your computer, OS X installed, nor the Numbers version being used?

I'll provide an explanation on my MBPro (Yosemite w/ Numbers 3.5.2) - see the screen capture below: 1) Select print - pick the print setup options desired (far right column) and then hit 'Print' (blue arrow); 2) Print dialog box will open - under 'Pages' select 'From' and put in the pages desired (red arrow) - I picked pages 1 & 2 of a 44 page spreadsheet; and 3) Select any other options, such as the printer to use, and hit 'Print' (green arrow).

Let us know if these directions work for you - Dave
.

 

[bfstephen]

Partial Print

Thanks for the suggestion. I was not clear in my description. I want to print only some of my columns and some of my rows, not just a few pages.
Example:
Spreadsheet has columns A-Z and Rows 1-50.
I want to print columns A-N and Rows 1-45.

I am on OS x Yosemite
Numbers 3.5.2.

 

[RadDave]

Thanks for the suggestion. I was not clear in my description. I want to print only some of my columns and some of my rows, not just a few pages.
Example:
Spreadsheet has columns A-Z and Rows 1-50.
I want to print columns A-N and Rows 1-45.

I am on OS x Yosemite
Numbers 3.5.2.

Sorry - I was not completely clear as to your intentions - you can use the 'Hide Row' & 'Hide Column' selections in the drop down menu under Table (see pic below w/ arrows); first, select the sheet of the spreadsheet you want to print; next, pick the columns or rows you want to 'hide', i.e. not print - click the appropriate menu item; and then go to the print options mentioned in my first post - whatever columns and/or rows you had chosen to hide should be absent in the print preview - Dave
.

 

[Rich578]

Setting Print Area

Can anyone tell me if the Numbers Application has a feature similar to "Print Area"?

I am not sure how long RadDave has been working with spreadsheets, but setting print area is a very common function used in business for at least 25 years that I know of. Suddenly Yosemite no longer provides that functionality. ***???

Is it possible to work around this significant limitation using the table feature? (Those of you old enough to remember, know that this whole category of software was developed to aid in calculating and presenting business financials. )

RadDave's solution does not work when you are trying to print financials spanning several years and the spreadsheet continues over on to multiple printed page. Without the ability to carry the header row and side column over from page to page, and set a print area from year-to-year the spreadsheets are worthless.

 

[bobtomay]

Good luck - see my post from a few days on another similar print function in that other OS...

I also work with spreadsheets all day at the office and often use the function you're talking about - don't use spreadsheets at home - so no familiarity with that in OS X at all.

 

[RadDave]

Can anyone tell me if the Numbers Application has a feature similar to "Print Area"?

I am not sure how long RadDave has been working with spreadsheets, but setting print area is a very common function used in business for at least 25 years that I know of. Suddenly Yosemite no longer provides that functionality. ***???

RadDave's solution does not work when you are trying to print financials spanning several years and the spreadsheet continues over on to multiple printed page. Without the ability to carry the header row and side column over from page to page, and set a print area from year-to-year the spreadsheets are worthless.

Well, I started on spreadsheets w/ VisiCalc and then used Excel for over 30 years when working on PCs - two years ago in retirement, switched over to Apple products and have been using Numbers occasionally for simple tasks only, so yes my experience w/ that app is limited and I believe my suggested 'potential' solutions simply reflect the limitations of the Apple offering vis a vis Excel - sorry not to be more helpful. Dave

 

[MacInWin]

Can anyone tell me if the Numbers Application has a feature similar to "Print Area"?

I am not sure how long RadDave has been working with spreadsheets, but setting print area is a very common function used in business for at least 25 years that I know of. Suddenly Yosemite no longer provides that functionality. ***???

Is it possible to work around this significant limitation using the table feature? (Those of you old enough to remember, know that this whole category of software was developed to aid in calculating and presenting business financials. )

RadDave's solution does not work when you are trying to print financials spanning several years and the spreadsheet continues over on to multiple printed page. Without the ability to carry the header row and side column over from page to page, and set a print area from year-to-year the spreadsheets are worthless.

Welcome to the forums. You'll find that here we prefer cordiality and not snark. Slamming RadDave was inappropriate and will probably lead to fewer of the "regulars" here being willing to assist.

As for your question, yes, we can tell you. It doesn't.

 

[bobtomay]

I don't actually use the "Set Print Area", although others in the office do. I actually just click and drag to select the cells I want, then head for Print and select "Current Selection". Don't have that in OS X either and for the life of me, can't comprehend why not.

Best option I can figure (real quick) for printing a selection of a spreadsheet is going to be to select, copy and paste what you want into a new sheet to print, then delete it. What a rigmarole.

I use that Print current selection numerous times throughout every single day.
Just these couple of print options missing totally rules out being able to use OS X in the business.
But, I still want that 5k iMac...

 

[MacInWin]

Best option I can figure (real quick) for printing a selection of a spreadsheet is going to be to select, copy and paste what you want into a new sheet to print, then delete it. What a rigmarole.

Or, you could create a second sheet with links to the working sheet, but without the stuff you DON'T want to print, that way when you change the working sheet the "rigmarole" is reduced to just changing to the print sheet, which should have updated because of the links, and print it. That assumes, of course, that the print area you want is consistent and fixed from month to month (or data entry to data entry).

 

[bobtomay]

That'd be great for those that only work with a few spreadsheets.

Most days I am creating 4-10 new workbooks - to the tune of 1,300 - 1,500 workbooks a year - with a minimum of 4 sheets and as many as 10 sheets per workbook.

I have a minimum of 2 pages in every single workbook where I need to be able to set the print area or print the current selection.
I already get mad everytime a change is made to the OS or apps that require even 1 additional click of the mouse to get my job done (thank you very much MS Office ribbon - yes, I'm still po'd about that although, I have managed to get all the most used stuff in the shortcut menu there) much less have to create 1500 more workbooks just to be able to print what I need.

At least there is an option to scale to fit, but that doesn't do a whole lot of good if you can't select the area you need to print from a document.

Glad I don't touch spread sheets when I get home, nor have much need for that.
While I still have and use a custom built Windows box here at home, I really wouldn't want to go back to Windows for my primary OS.
But, have to say, wth is that option not available with print drivers in OS X?
There should be options for both 'print selection' and 'print current view'.

 

[MacInWin]

Yeah, Bob, in your situation you need Excel, not Numbers. Not having set print area in Numbers is a real shortcoming.