Re: I have a centering Problem on excel documents.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 01/17/05 

Date: Sun, 16 Jan 2005 17:44:54 -0700

In article <uvEp27##EHA.1400@TK2MSFTNGP11.phx.gbl>,
 "Phillip M. Jones, CE.T." <pjones@kimbanet.com> wrote:

> Maybe I explained wrong. Some applications (Filmmaker for example) allow
> for what is called a Master Header. which is printed only on the first
> Page then other pages do not have any header information.
>
> The first page of my Excel *** shifts down as though some header
> information is printed on first page Then any pages after center
> correctly. When in reality there is nothing entered. Making it appear
> there is a Master Header setting somewhere. In Word and EXCEL 2001 and
> on 6.0.1.a and 5.0.1a there actually was a setting where you could set
> formatting to apply only to first page, selected pages or, whole document.
>
> I can't find anything like that in Excel2004.
>
> I've even tried setting Header, and footer to zero in Document setup. I
> still have the same problem.
>
> The reason I need this ability is that I need (or would like to trim
> sides and top and bottom to just around the spread*** so that it can
> be folded in half for storage.

Are your two pages of different sizes? If the first page is smaller, and
you have things centered vertically, that would explain the difference.

Try looking at your pages in Page Break Preview (where you can drag the
break) or Page Layout View (2004) - are the pages the same size?

Quantcast