RE: Excel pagination Help

Subject: RE: Excel pagination Help
From: "Combs, Richard" <richard -dot- combs -at- Polycom -dot- com>
To: "jopakent" <jopakent -at- comcast -dot- net>, <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 16 Oct 2009 09:57:08 -0600

jopakent wrote:

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

Well, I'm by no means skilled/proficient with Excel, so this isn't based
on any particular expertise. But simple logic suggests that if Excel
scales down to 58% when you drag a page break where you want it, that
means it simply can't accommodate your request at a larger size. The
page is only so big...

If you've got rows up to 5 inches tall (which can't break across pages),
it's not unlikely that some combination of tall and short rows can only
be made to fit (at your desired size, margins, etc.) with the
unfortunate break you're trying to get rid of.

Have you tried moving the break up instead of down, so that the lone
skinny row is joined by a row or two preceding it? Sometimes we get
focused on fitting a little bit more on a page and don't consider going
in the other direction. You might even fiddle with slightly _increased_
margins, text size, etc., to get page breaks at better places.

Or you could ruthlessly edit the text in those 5" rows. :-)


Richard G. Combs
Senior Technical Writer
Polycom, Inc.
richardDOTcombs AT polycomDOTcom
303-223-5111
------
rgcombs AT gmailDOTcom
303-777-0436
------





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

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


References:
Excel pagination Help: From: jopakent

Previous by Author: RE: Guide to Visio for FrameMaker users?
Next by Author: RE: Documentation confidentiality level policy
Previous by Thread: Excel pagination Help
Next by Thread: Re: Excel pagination Help


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


Sponsored Ads