Page Break Preview
 

When I add rows in Excel, the page break does not seem to be adjusting
automatically. Every time I add a few rows, I have to go back into Page Break
Preview and manually slide down the blue bar down.

Is there any way that this could happen automatically???

I would appreciate any feedback and thanks in advance for your help.

wnfisba

Page Break Preview
 

Maybe it's time to reset the print area:

File|Print Area|Clear Print Area



wnfisba wrote:

When I add rows in Excel, the page break does not seem to be adjusting
automatically. Every time I add a few rows, I have to go back into Page Break
Preview and manually slide down the blue bar down.

Is there any way that this could happen automatically???

I would appreciate any feedback and thanks in advance for your help.

wnfisba

--

Dave Peterson

Page Break Preview
 

Do you need page breaks? It is better to put one page of data on each
worksheet. then when you print check the Entire worksheet box. Page breaks
automatically get inserted between worksheets.

"wnfisba" wrote:

When I add rows in Excel, the page break does not seem to be adjusting
automatically. Every time I add a few rows, I have to go back into Page Break
Preview and manually slide down the blue bar down.

Is there any way that this could happen automatically???

I would appreciate any feedback and thanks in advance for your help.

wnfisba

Page Break Preview
 

That was it Dave!

Thanks!

You learn something new everyday! Sometimes I feel like such an Excel novice.

"Dave Peterson" wrote:

Maybe it's time to reset the print area:

File|Print Area|Clear Print Area



wnfisba wrote:

When I add rows in Excel, the page break does not seem to be adjusting
automatically. Every time I add a few rows, I have to go back into Page Break
Preview and manually slide down the blue bar down.

Is there any way that this could happen automatically???

I would appreciate any feedback and thanks in advance for your help.

wnfisba

--

Dave Peterson