TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Agree. However, I didn't mean PowerPoint when I said "presentation."
Actually there is a PowerPoint that "leads" the discussion, but there are
links sprinkled through it hither and yon that lead to all kinds of exciting
places (illustrations, drawings, specifications documents, etc).
This particular spreadsheet is 11x17 and runs to about 30 pages. I'm
printing it to a PDF that displays full screen when you navigate the
corresponding link. It displays fine onscreen and I can zoom in and out as
needed.
I think I've got this solved now. On the Page Setup screen, I selected Fit
to 1 wide by 28 long and that seems to fix it.
J. Paul Kent
206-383-0539
-----Original Message-----
From: Pinkham, Jim [mailto:Jim -dot- Pinkham -at- voith -dot- com]
Sent: Friday, October 16, 2009 11:50 AM
To: Marguerite Krupp; techwr-l -at- lists -dot- techwr-l -dot- com; jopakent
Subject: RE: Excel pagination Help
Marguerite is exactly right, IMHO, if you're really trying to wedge a
massive spreadsheet into a PowerPoint slide or slides. If you meant,
however, that you'll be printing out presentation content and including a
spreadsheet printout along with it, another tool that may help is ASAP
Utilities, which is an Excel lifesaver in many ways, and well worth the
relatively small investment after you take it for a free trial spin. For
example, the Paper Saver tool under the Format collection of utilities,
might help in this instance. The site is: http://www.asap-utilities.com/index.php.
HTH,
Jim
-----Original Message-----
From: techwr-l-bounces+jim -dot- pinkham=voith -dot- com -at- lists -dot- techwr-l -dot- com
[mailto:techwr-l-bounces+jim -dot- pinkham=voith -dot- com -at- lists -dot- techwr-l -dot- com] On Behalf
Of Marguerite Krupp
Sent: Friday, October 16, 2009 1:19 PM
To: techwr-l -at- lists -dot- techwr-l -dot- com; jopakent
Subject: Re: Excel pagination Help
This may sound like an end-around run, and maybe I'm misreading your
question, but why would you put such a spreadsheet into a Powerpoint
presentation? It'll be practically illegible. Instead, perhaps you could put
the real "big, ugly spreadsheet" into a handout possibly done on 11x14"
paper, then put some sort of summary spreadsheet into the presentation
itself. Your audience will still get both the message and the details, and
the presentation will be the better for it.
BTW, I've been in the same situation myself. It's not pretty!
From: jopakent <jopakent -at- comcast -dot- net>
Subject: Excel pagination Help
To: techwr-l -at- lists -dot- techwr-l -dot- com
Date: Friday, October 16, 2009, 11:32 AM
I am feeling absolutely brain dead right now. I'm trying to do something
that seems so simple, yet I keep spinning my wheels. I've got a large-ish
spreadsheet that I need to print out to include in a presentation. The row
heights vary a good deal, based on the content. Some of the content ranges
from a couple of sentences (approx 1") to several paragraphs (some are 4 or
5 inches).
The issue I am having is trying to get the printed output to paginate so
that I don't have some pages with a single skinny row. The problem is that
when I use the Page Break Preview view to display the existing page breaks
and then drag the breaks to where I want them, the scaling shifts for the
entire sheet. That's not the look I want. I've got my column and page
margins and text size set up to read just the way I want them. (There are
multiple sheets and I want them all to look the same), so when Excel tweaks
the scaling down to 58%, it messes up what I'm looking for.
So my question is, how do I change the placement of the page break, without
changing the Scaling setting on the Page Setup dialog box.
XP SP2 and Excel 2002, plz cc me directly as I'm on digest, and thanks a ton
in advance as I'm (of course) on a deadline.
Free Software Documentation Project Web Cast: Covers developing Table of
Contents, Context IDs, and Index, as well as Doc-To-Help
2009 tips, tricks, and best practices. http://www.doctohelp.com/SuperPages/Webcasts/
Help & Manual 5: The complete help authoring tool for individual authors and
teams. Professional power, intuitive interface. Write once, publish to 8
formats. Multi-user authoring and version control! http://www.helpandmanual.com/
---
You are currently subscribed to TECHWR-L as mkrupp128 -at- yahoo -dot- com -dot-
Free Software Documentation Project Web Cast: Covers developing Table of
Contents, Context IDs, and Index, as well as Doc-To-Help
2009 tips, tricks, and best practices. http://www.doctohelp.com/SuperPages/Webcasts/
Help & Manual 5: The complete help authoring tool for individual
authors and teams. Professional power, intuitive interface. Write
once, publish to 8 formats. Multi-user authoring and version control! http://www.helpandmanual.com/
---
You are currently subscribed to TECHWR-L as Jim -dot- Pinkham -at- voith -dot- com -dot-
Free Software Documentation Project Web Cast: Covers developing Table of
Contents, Context IDs, and Index, as well as Doc-To-Help
2009 tips, tricks, and best practices. http://www.doctohelp.com/SuperPages/Webcasts/
Help & Manual 5: The complete help authoring tool for individual
authors and teams. Professional power, intuitive interface. Write
once, publish to 8 formats. Multi-user authoring and version control! http://www.helpandmanual.com/
---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-
