Excel page break preview

When I go to a page break preview I see 4 pages. When I do a print preview
or print the spreadsheet I only get 3 pages with all the data from the 4th
page not printed. If I try to print just page 4 I'm told that Excel did not
find anything to print. I've had this happen on 2 differenct spreadsheet so
far.

Are the cells on what would be the 4th page greyed out in page break preview?

If so, you should be able to drag the bottom blue line down to include them.

"RK" wrote:

> When I go to a page break preview I see 4 pages. When I do a print preview
> or print the spreadsheet I only get 3 pages with all the data from the 4th
> page not printed. If I try to print just page 4 I'm told that Excel did not
> find anything to print. I've had this happen on 2 differenct spreadsheet so
> far.

The cell on the 4th page are not greyed out. They are included in the print
range and excel calculates it as the 4th page.

"Jo Betty Smith" wrote:

> Are the cells on what would be the 4th page greyed out in page break preview?
>
> If so, you should be able to drag the bottom blue line down to include them.
>
> "RK" wrote:
>
> > When I go to a page break preview I see 4 pages. When I do a print preview
> > or print the spreadsheet I only get 3 pages with all the data from the 4th
> > page not printed. If I try to print just page 4 I'm told that Excel did not
> > find anything to print. I've had this happen on 2 differenct spreadsheet so
> > far.

I would just copy and paste the data into a new spreadsheet and see if that
clears it. I can't think of any other settings that might affect it.

"rk" wrote:

> The cell on the 4th page are not greyed out. They are included in the print
> range and excel calculates it as the 4th page.
>
> "Jo Betty Smith" wrote:
>
> > Are the cells on what would be the 4th page greyed out in page break preview?
> >
> > If so, you should be able to drag the bottom blue line down to include them.
> >
> > "RK" wrote:
> >
> > > When I go to a page break preview I see 4 pages. When I do a print preview
> > > or print the spreadsheet I only get 3 pages with all the data from the 4th
> > > page not printed. If I try to print just page 4 I'm told that Excel did not
> > > find anything to print. I've had this happen on 2 differenct spreadsheet so
> > > far.