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.
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-
