Page Layout View Hides Rows at the Bottom of Sheet

[Mielikki55]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

The sheet based off of the Account Balance template hides the bottom rows in Page Layout View. I can see all rows in the Normal Layout View. How do I fix this?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

The sheet based off of the Account Balance template hides the bottom rows in
Page Layout View. I can see all rows in the Normal Layout View. How do I fix
this?

Can you explain the problem in a little more detail? This does not happen
for me. How many rows have you filled in on the template? Is it possible you
have flowed onto a second page?

 

[Mielikki55]

I've filled in enough rows in the template to have several rows in the 2nd page already. Between the bottom of the first page and the beginning of the second page, two to three rows are missing in Page Layout View. The missing rows are visible and accounted for in the Normal Layout View and mathematically accounted for in the Page Layout View, just not visible. I had previously adjusted the margins (and made them smaller) but shouldn't Excel account for adjusted margins?

 

[Bob Greenblatt]

I've filled in enough rows in the template to have several rows in the 2nd
page already. Between the bottom of the first page and the beginning of the
second page, two to three rows are missing in Page Layout View. The missing
rows are visible and accounted for in the Normal Layout View and
mathematically accounted for in the Page Layout View, just not visible. I had
previously adjusted the margins (and made them smaller) but shouldn't Excel
account for adjusted margins?

Yes it should. What template are you using? I'd like to try this to see what
is happening.

 

[Mielikki55]

Account Balance template.

 

[Bob Greenblatt]

Account Balance template.

Well, I don't see this at all. All lines appear in both page layout and
normal view. Have you tries using a different printer? Does the sheet print
properly? Have you altered the top or bottom margin?

 

[Mielikki55]

I just checked my spreadsheet and now all the rows are showing. I'm not sure how it fixed itself but it did. Thanks for your time and help!