Excel won't print all pages

bhdzjameson

New Member
Joined
Aug 24, 2010
Messages
2
I've never encountered this before. Let me preface that I am a 20+ year user of Excel. Currently using Excel 2007.

I have 43 pages set up to print which encompasses 75 rows and 271 columns (I am using Page Break Preview when viewing the spreadsheet). Whenever I attempt to print, or review with Print Preview, only 37 pages are generated (through column #244).

There is no print area defined (only print titles). Any ideas? Thanks.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
try to define the print area.
or give some more info or upload the file.
 
Upvote 0
I forgot to mention that I did define the print area, and I still got the same result.

However, after looking to delete some columns - which still caused the number of pages to be short by 5 pages - I thought that the inverse may work. So I added the equivalent of 5 pages worth of columns at the end of the print area. This did the trick.

I'm still scratching my head. The sheet is all data with very little formulas. A very simple sheet, albeit a large chunk of columns. I am unable to upload due to the sensitive nature of the data.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top