Printing prints only the column header row on the first page

Ronald Dodge · External Since: May 15, 2007 Posts: 41

OS: WXPPro, SP2
APP: XLXP, SP3

The column header row is row 1
Rows to repeat at top: $1:$1
Print Area: Either A1:M798 or A2:M798 (Doesn't matter which, same effect
except the latter shades out the header row under page view)

Current situation: Rows 2 through 725 are hidden.

Illeffect: When printing, it prints only the header row for the first page.

Impact: Don't like to have to change the Print area each and every time
additional rows are hidden.

Under current situation, if the first row of the print area is 314 or
higher, it will print the data as the first page, but if the first row of
the print area is 313 or lower, then that same data is printed as page 2.

What needs to be done without necessarily having to adjust the print area
everytime one goes to print out the report?
--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

manuel maza · External Since: Jul 25, 2007 Posts: 2

Hi,

you can go to the printer properties, In advanced you will see the option to
customize the print area
"Ronald Dodge" <ronald.dodge RemoveThis @sonoco.com> wrote in message
news:eg4RAlklHHA.596@TK2MSFTNGP06.phx.gbl...
> OS: WXPPro, SP2
> APP: XLXP, SP3
>
> The column header row is row 1
> Rows to repeat at top: $1:$1
> Print Area: Either A1:M798 or A2:M798 (Doesn't matter which, same effect
> except the latter shades out the header row under page view)
>
> Current situation: Rows 2 through 725 are hidden.
>
> Illeffect: When printing, it prints only the header row for the first
> page.
>
> Impact: Don't like to have to change the Print area each and every time
> additional rows are hidden.
>
> Under current situation, if the first row of the print area is 314 or
> higher, it will print the data as the first page, but if the first row of
> the print area is 313 or lower, then that same data is printed as page 2.
>
> What needs to be done without necessarily having to adjust the print area
> everytime one goes to print out the report?
> --
>
> Sincerely,
>
> Ronald R. Dodge, Jr.
> Master MOUS 2000
>

Ronald Dodge · External Since: May 15, 2007 Posts: 41

Guess you didn't see the statement about not wanting to have to change the
print area everytime they want to print this report out as I did state that
in the original message.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"manuel maza" <mmjuan3.TakeThisOut@hotmail.com> wrote in message
news:%23Sjka1szHHA.5476@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> you can go to the printer properties, In advanced you will see the option
> to customize the print area
> "Ronald Dodge" <ronald.dodge.TakeThisOut@sonoco.com> wrote in message
> news:eg4RAlklHHA.596@TK2MSFTNGP06.phx.gbl...
>> OS: WXPPro, SP2
>> APP: XLXP, SP3
>>
>> The column header row is row 1
>> Rows to repeat at top: $1:$1
>> Print Area: Either A1:M798 or A2:M798 (Doesn't matter which, same effect
>> except the latter shades out the header row under page view)
>>
>> Current situation: Rows 2 through 725 are hidden.
>>
>> Illeffect: When printing, it prints only the header row for the first
>> page.
>>
>> Impact: Don't like to have to change the Print area each and every time
>> additional rows are hidden.
>>
>> Under current situation, if the first row of the print area is 314 or
>> higher, it will print the data as the first page, but if the first row of
>> the print area is 313 or lower, then that same data is printed as page 2.
>>
>> What needs to be done without necessarily having to adjust the print area
>> everytime one goes to print out the report?
>> --
>>
>> Sincerely,
>>
>> Ronald R. Dodge, Jr.
>> Master MOUS 2000
>>
>
>

kkc97 · Joined: Aug 15, 2007 Posts: 4

Try this:

Go to:
File
Page Setup
Sheet
(Clear print area-this will eliminate need to change print area when records added )
Rows to repeat at top: $1:$4 ( if you want rows 1-4 repeated on all pages )
OK
Smile