Re: Excel pagination Help

[Robert Lauriston <robert -at- lauriston -dot- com>]

Do you have the page scaling option set to "Fit to # page(s) wide by
## tall"? That can cause automatic downscaling when you set a manual
page break.

On Fri, Oct 16, 2009 at 8:32 AM, jopakent <jopakent -at- comcast -dot- net> wrote:
> 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 robert -at- lauriston -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/robert%40lauriston.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