Excel pagination Help

Subject: Excel pagination Help
From: "jopakent" <jopakent -at- comcast -dot- net>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 16 Oct 2009 08:32:46 -0700

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.

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:


Previous by Author: font question: character height-to-stroke ratio
Next by Author: RE: Excel pagination Help
Previous by Thread: Re: Visio shape hide-and-seek
Next by Thread: RE: Excel pagination Help

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

Sponsored Ads