Selecting Print Areas in Numbers
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Numbers has a serious shortcoming in its design when it comes to _selecting print areas_ from a spreadsheet. As as example, if I have a spreadsheet with 8 columns and 12 rows, but I only want to print an area that covers columns B to D and rows 3 to 8, there is no "easy" way to do this as there is in Excel. The only solution I can see is for me to copy columns B to D and rows 3 to 8, and then open a new sheet and paste this selection, at which time I can print the new spread sheet. What a convoluted way of printing a selected area! I can't believe that Apple in all its wisdom did not see this as a problem when designing Numbers... and why has it not been addressed log before now. If there is an better solution than what I have mentioned, where is it hidden?
16 replies
Sign in or join Beachball Help to reply.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hello
This question was often asked and responded.
At this time there is no other way to print a selection.
I'm not sure that we will get one in a future revision of the program.
As far as I know this feature is unavailable in every Apple program.Yvan KOENIG
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Hello
This question was often asked and responded.
At this time there is no other way to print a selection.
I'm not sure that we will get one in a future revision of the program.
As far as I know this feature is unavailable in every Apple program.Yvan KOENIG
- 0
x-teacher ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I have used every version(I think) of Appleworks. I have always been able to select a print range. So this isn't tradition, in fact, it's a complete change in the way things have been done in previous Apple programs.
This has to be added or Numbers is of no value to me and I've just wasted the money I used to buy it.
- 0
Ashka ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I suppose it's a bit late to suggest using the Free 30 day trial of iWork from Apple first.
Not to worry, you still have Pages and Keynote to use if Numbers doesn't fit with your way of working. Personally I'd give yourself a bit more time playing with the different options in Numbers, it really is rather pleasant to use.
Have a great day.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
You forget a detail, AppleWorks was not designed in AppleLand but by a small company which was bought some time later by Claris.
At least since the delivery of Mac OS X, the program designed in AppleLand don't offer a print selection feature.
I'm always surprised when I read: i spent my money for a tool which doesn't fit my needs.
A free 30 days trial version seems to be sufficient to check if a tool fit our needs or doesn't.
Some users like to live dangerously 😉
Yvan KOENIG (from FRANCE mercredi 4 juin 2008 10:14:09)
- 0
Thomas Wright1 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Yvan, you write: "You forget a detail, AppleWorks was not designed in AppleLand but by a small company which was bought some time later by Claris."
To set the record straight, Claris was a spin-off company from Apple which was given the rights to Apple's software products, including AppleWorks, when it was spun off from Apple. Claris operated in that mode for several years before it was again absorbed back into Apple. During the time that Claris existed as a company, the product was called Claris Works. After Apple brought Claris back under its wing, the name AppleWorks was again used. So, the product we know as AppleWorks was "designed in AppleLand."
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
_You are wrong !_
Apple owned the AppleWorks 8 bits product, the one in text mode).
The original of the AppleWorks I wrote about, was a 16 bits product with graphical interface created by StyleWare.
Claris bought it and named it ClarisWorks.It becames an Apple product at version 5.3.
Look at:
http://www-swiss.ai.mit.edu/~bob/clarisworks.phpfor more details.
Yvan KOENIG (from FRANCE mercredi 4 juin 2008 18:30:59)
- 0
Thomas Wright1 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Thanks for the link to the clarifying info about Claris Works. I wasn't aware of those details.
By the way, there really isn't any need to underline and add exclamation points to your posts. A simple correction of a poster's error is sufficient without emphasizing your superiority.
- 0
x-teacher ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
x-teacher wrote:
I have used every version(I think) of Appleworks. I have always been able to select a print range. So this isn't tradition, in fact, it's a complete change in the way things have been done in previous Apple programs.This has to be added or Numbers is of no value to me and I've just wasted the money I used to buy it.
Actually, I didn't buy iWork for Numbers only. I wanted the Pages program, and thought I would be happy with the addition of Numbers.
The history of Appleworks is becoming interesting. I might add that I used Appleworks & ClarisWorks on the Apple II, later the graphics based "BeagleWorks on the Apple IIGS. That transformed into Appleworks GS. Somehow most of this was ported to the Mac. Numbers has lots of nice features, and I'm begining to like using it--just don't like the print features.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
x-teacher wrote:
The history of Appleworks is becoming interesting. I might add that I used Appleworks & ClarisWorks on the Apple II,My memory may fool me but af far as I know, the name ClarisWorks was used only for a Mac dedicated program.
later the graphics based "BeagleWorks on the Apple IIGS.
That transformed into Appleworks GS.I built the French version of AppleWorks GS but I don't remember this product as an evolution of BeagleWorks. In fact I'm sure that is was an evolution of StyleWare's GSworks.
Somehow most of this was ported to the Mac.
In the given link, the author clearly states that there was no link between AppleWorks GS which was already bought by Claris and the program he designed and which became ClarisWorks ("+we wanted to write new software, not maintain old software+.").
Numbers has lots of nice features, and I'm begining to like using it--just don't like the print features.
If we are numerous to ask for enhancements, maybe we will enter the 80% area 😉
Yvan KOENIG (from FRANCE vendredi 6 juin 2008 16:21:20)
- 0
Rex Heftmann ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
At the risk of interrupting this international nostalgia-fest, may we get back to topic? I can't believe you can't just print the part of a document that matters, without empty cells. It was easy in CWK. What modern program lacks a feature which doesn't allow you to fit content to page? Tell me it's not so!
- 0
R C-R ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
REXprints wrote:
What modern program lacks a feature which doesn't allow you to fit content to page?While it isn't a print range feature, the interactive content scaling feature of the Numbers page view is one of the quickest & easiest to use methods I have ever tried to fit content to page, light-years ahead of anything available in AppleWorks/ClarisWorks ... or in Excel, judging by the number of Excel spreadsheet printouts I have been given that require scissors & tape to make them really useable.
Numbers is missing many features, but this one is excellent.
- 0
WWJD ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
"Fit To" in Excel works great.
Regards,
- 0
R C-R ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
WWJD wrote:
"Fit To" in Excel works great.In theory I'm sure it does, but in practice it seems often not to: I get a lot of "fit to" printouts that have text so small that it takes a magnifying glass to read them. I also get a lot that span so many pages that they are much too unwieldy for quick reference.
Perhaps I should explain that the nature of much of my work involves a lot of spreadsheets created by people who are doing six things at once & are constantly trying to add content from a number of sources to the sheets, printing them out at the last minute to make them relevant for a very time-sensitive endeavor. (It is theatrical production work, should you be wondering. The spreadsheets are cue sheets that detail all the production's technical events & when they must occur.)
Anyway, for "time-crunch" situations like these the interactive ability of Numbers to scale content & immediately see the consequences for page layout is very well suited to avoiding these problems.
In fact, although Excel is pretty much the industry standard for generating these cue sheets (& PC's are more common than one might think in this kind of work), when some of these users see what this feature of Numbers does, they are quite impressed, sometimes so much so that they start asking about the price of Mac laptops, iWork, etc.
- 0
KOENIG Yvan ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
REXprints wrote:
I can't believe you can't just print the part of a document that matters, without empty cells. It was easy in CWK. What modern program lacks a feature which doesn't allow you to fit content to page? Tell me it's not so!Maybe you can't believe, but this is a feature of the program.
No "print selection" tool available.Yvan KOENIG (from FRANCE mardi 24 juin 2008 08:36:29)
- 0
schilfgras ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Why do you guy always want everything that is featured in other apps. I've worked with excel many years, and switched to Numbers from the beginning. Print area is completely unnececary in Numbers. Dump your supporting data and tables on a other sheet. Or, if you are a lazy person, add them in additional columns and rows and hide them before printing. But that is the dirty excel-way.
The Numbers way of working is to make a summary of only that data you want to show/print in a nicely layouted Sheet to publish. 🙂