setting print area

Pages has page boundaries which is what prints, not any part of a spreadsheet.

Are you actually asking a question about Numbers which is a different program?

Peter

Hello Peter

Such question make me think to beings asking for condoms in a confessional 😉

Yvan KOENIG (VALLAURIS, France) samedi 31 décembre 2011

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is : http://public.me.com/koenigyvan

Please : Search for questions similar to your own before submitting them to the community

For iWork's applications dedicated to iOS, go to :

https://discussions.apple.com/community/app_store/iwork_for_ios

The lack of a "Print Area" command in Numbers is a MAJOR reason why Excel is better than Numbers.

I don't want to have to split my files into different charts just to print them. A "Select Area" would be MUCH easier. Apple should get with it and fix this glaring weakness of Numbers.

Printing a subset of a Numbers document is really easy and was described many times.

I repeat the scheme one more time.

Don’t drown yourselves in a cup of water.

Cmd P to open the Print Dialog

Local menu PDF > Show in Preview.

When the doc is open in Preview, select what you want to print

Copy to clipboard

File > Create new doc from the clipboard

Print

Yvan KOENIG (VALLAURIS, France) lundi 9 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

You can also select what you want to print (in Numbers), then copy, then switch to Preview and create a new doc from Clip board (select the menu item "File > New From Clipboard"

then print from Preview. It seems like a lot of steps but is actually pretty easy.

Hope this helps

Hi Wayne

The problem with your scheme is that we can't print a subset of a table and a chart.

My scheme allows us to do that. 😉

Yvan KOENIG (VALLAURIS, France) lundi 9 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

I was only pointing out that you need not print from Numbers (but you can if you want) and, then you then create a temporary PDF in preview from the clip board. I think both ways are good. You can certainly select a portion of the resulting document in preview if you want than whant you copied originally.

The plus with copying what you want to the clip board is it maybe harder to get only what you want if you print the whole document to Preview-- I think both ways have merit.

Hello Wayne

It seems that you didn't read carefully 😉

I wrote :

The problem with your scheme is that we can't print a subset of a table and a chart.

We can't copy a subset of a table plus a chart to the clipboard exactly as we can't copy a chart plus its title/caption. To achieve this task we must print in a PDF before defining the area to really print.

Yvan KOENIG (VALLAURIS, France) lundi 9 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

Once you create the new doc in Preview you can select what you want-- as show in the selection.

You selected a table and a chart but you loose the chart title as well as its captions.

As I am lazy, in my messages, every word is useful.😉

Yvan KOENIG (VALLAURIS, France) lundi 9 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

Yup. Very good point

Flash2 wrote:

"The lack of a "Print Area" command in Numbers is a MAJOR reason why Excel is better than Numbers.

... Apple should get with it and fix this glaring weakness of Numbers."

This is a user-to-user forum. Here, you're talking to end users, not to Apple. If you think that adding this feature to a future version of Numbers is important, your path is to Provide Numbers Feedback, using the menu item of that name in the Numbers menu in Numbers, or using the link in this message.

Meantime, use whatever software is 'better' for your purposes.

Regards,

Barry

The tricks to print an area of a spreadsheet in Numbers are interesting and work as you say.

However, I use this feature only about once every four months and forget the details. It would be SO MUCH EASIER if Numbers just had a PRINT AREA command!

Apple focuses on the needs of 80% of the target population. I do not thins Print area is not one of the big features at the top of Apples' to do list-- it is NOT on my list... AND I understand it is important to you.

You must decide whether Numbers is the tool for you. 99% of the time my tables are far less than 1000 rows and 90% of the time less than 100 rows. So far I have never, once, wanted to use the print are because I plan my sheets.

Regards,

Wayne

Thanks, Barry. I used your link to give Apple a piece of my mind. I use the Select Print Area only a few times a year, and can never remember the handstands necessary to get it to work. I have to go back to this discussion area a couple of times a year to get refreshed on how to do it. This year, I spent about 45 minutes, especially as I struggled with it and managed to foul up the account that I was trying to print.

It would also be nice if the technique was listed in the HELP menu, but of course HELP is never very helpful anyway.

So, until Apple gets around to correcting this deficiency in Numbers, or at least putting it in HELP, I'll use Excel.