RE: Excel pagination Help

Subject: RE: Excel pagination Help
From: "Pinkham, Jim" <Jim -dot- Pinkham -at- voith -dot- com>
To: "Marguerite Krupp" <mkrupp128 -at- yahoo -dot- com>, <techwr-l -at- lists -dot- techwr-l -dot- com>, "jopakent" <jopakent -at- comcast -dot- net>
Date: Fri, 16 Oct 2009 13:50:06 -0500

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!
 
Good luck!
Marguerite

--- On Fri, 10/16/09, jopakent <jopakent -at- comcast -dot- net> wrote:


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.



J. Paul Kent



^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/mkrupp128%40yahoo.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat





^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/jim.pinkham%40voith.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


Follow-Ups:

References:
Excel pagination Help: From: jopakent
Re: Excel pagination Help: From: Marguerite Krupp

Previous by Author: RE: TOOLS: Extract PDF MetaData Freeware
Next by Author: RE: Interesting Article on Windows 7
Previous by Thread: Re: Excel pagination Help
Next by Thread: RE: Excel pagination Help


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads