In the PC world, I used 'Set Print Area'; I cannot find any similar functionality in Numbers.
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.
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.
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.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.
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).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.