ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel page break preview (https://www.excelbanter.com/excel-discussion-misc-queries/13537-excel-page-break-preview.html)

RK

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.

Jo Betty Smith

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.


rk

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.


Jo Betty Smith

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.



All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com