Excel 16 print preview is off the page (have to scroll down to see it)

%3CLINGO-SUB%20id%3D%22lingo-sub-240779%22%20slang%3D%22en-US%22%3EExcel%2016%20print%20preview%20is%20off%20the%20page%20(have%20to%20scroll%20down%20to%20see%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240779%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20use%20the%20print%20preview%20function%20(ctrl_p%20hotkey%20combo%2C%20file%20menu%20or%20other%20method)%20-%20the%20right%20pane%20(actual%20print%20preview)%20of%20the%20page%20is%20entirely%20off%20the%20page%20and%20I%20have%20to%20scroll%20down%20considerably%20to%20see%20any%20of%20the%20preview).%20The%20issue%20is%20the%20same%20as%20the%20one%20explained%20in%20this%20post%20at%20the%20msoffice%20forum%3A%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_win10-mso_365hp%2Fin-print-preview-suddenly-the-preview-is-off-the%2F08e13391-6dc2-40ed-841d-9941c0bad298%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_win10-mso_365hp%2Fin-print-preview-suddenly-the-preview-is-off-the%2F08e13391-6dc2-40ed-841d-9941c0bad298%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20an%20image%20also%20(I%20stitched%20together%20a%20few%20screen%20shots%20and%20redacted%20some%20identifying%20info).%20As%20can%20be%20seen%20in%20the%20image%20(note%20the%20red%20circles%20around%20the%20scroll%20bar)%2C%20I%20have%20to%20scroll%20down%20at%20least%20one%20page%20to%20see%20a%20preview%20of%20anything%20I%20attempt%20to%20print.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20repair%2C%20a%20full%20uninstall%20and%20reinstall%2C%20starting%20in%20safe%20mode%20and%20a%20host%20of%20other%20things%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20888px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44612i46A67B634E2B34F1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%2016%20Print%20Preview%20Issue.jpg%22%20title%3D%22Excel%2016%20Print%20Preview%20Issue.jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-240779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-240791%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016%20print%20preview%20is%20off%20the%20page%20(have%20to%20scroll%20down%20to%20see%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-240791%22%20slang%3D%22en-US%22%3E%3CP%3EThese%20two%20photos%20may%20be%20even%20more%20helpful.%20I%20did%20blur%20some%20confidential%20info%2C%20so%20that%20is%20me%20editing%20the%20images%2C%20but%20it%20is%20otherwise%20how%20it%20displays.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44614i801D1D55FE58FDDE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%2016%20Print%20Preview%20Issue%20first%20page.jpg%22%20title%3D%22Excel%2016%20Print%20Preview%20Issue%20first%20page.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44616iD36F6F5C6A0DEB83%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%2016%20Print%20Preview%20Issue%20Second%20page.jpg%22%20title%3D%22Excel%2016%20Print%20Preview%20Issue%20Second%20page.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509423%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016%20print%20preview%20is%20off%20the%20page%20(have%20to%20scroll%20down%20to%20see%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F184668%22%20target%3D%22_blank%22%3E%40Jason%20Loesch%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20had%20the%20same%20issue%20as%20we%20just%20moved%20to%20the%20new%20Office%20suite.%26nbsp%3B%20Couldn't%20figure%20out%20the%20answer%20and%20it%20was%20driving%20us%20nuts.%26nbsp%3B%20We%20just%20figured%20it%20out%20though.%26nbsp%3B%20If%20your%20print%20preview%20page%20is%20displaying%20a%20long%20list%20of%20recent%20workbooks%20(the%20list%20on%20the%20left-hand%20side%2C%20lower)%2C%20the%20preview%20display%20itself%20will%20be%20centered%20to%20that%20list.%26nbsp%3B%20I'm%20not%20explaining%20this%20well.%26nbsp%3B%20Anyway%2C%20if%20you%20go%20to%20file%20%26gt%3B%20options%20%26gt%3B%20advanced%20%26gt%3B%20Display%20you%20can%20change%20the%20%23%20of%20workbooks%20to%20display.%26nbsp%3B%20%26nbsp%3BI%20changed%20mine%20to%20a%20small%20number%20(6)%20and%20now%20my%20preview%20is%20proper.%26nbsp%3B%20When%20I%20had%20it%20at%2020%20it%20was%20running%20off%20the%20page.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509523%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016%20print%20preview%20is%20off%20the%20page%20(have%20to%20scroll%20down%20to%20see%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509523%22%20slang%3D%22en-US%22%3EThanks%20I%20did%20notice%20that%20myself%20and%20forgot%20to%20come%20back%20and%20update%20my%20post%20I%20appreciate%20you%20responding%20to%20it%20though.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-832791%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2016%20print%20preview%20is%20off%20the%20page%20(have%20to%20scroll%20down%20to%20see%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832791%22%20slang%3D%22en-US%22%3EThank%20you%20sooooooo%20much%20for%20this.%20It%20was%20driving%20me%20crazy!!%3C%2FLINGO-BODY%3E
New Contributor

When I use the print preview function (ctrl_p hotkey combo, file menu or other method) - the right pane (actual print preview) of the page is entirely off the page and I have to scroll down considerably to see any of the preview). The issue is the same as the one explained in this post at the msoffice forum: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/in-print-previ...

 

I've attached an image also (I stitched together a few screen shots and redacted some identifying info). As can be seen in the image (note the red circles around the scroll bar), I have to scroll down at least one page to see a preview of anything I attempt to print.

 

I have tried a repair, a full uninstall and reinstall, starting in safe mode and a host of other things to no avail.

 

Can anyone help fix this?

 

Excel 16 Print Preview Issue.jpg 

5 Replies

These two photos may be even more helpful. I did blur some confidential info, so that is me editing the images, but it is otherwise how it displays.

Excel 16 Print Preview Issue first page.jpgExcel 16 Print Preview Issue Second page.jpg

@Jason Loesch 

We had the same issue as we just moved to the new Office suite.  Couldn't figure out the answer and it was driving us nuts.  We just figured it out though.  If your print preview page is displaying a long list of recent workbooks (the list on the left-hand side, lower), the preview display itself will be centered to that list.  I'm not explaining this well.  Anyway, if you go to file > options > advanced > Display you can change the # of workbooks to display.   I changed mine to a small number (6) and now my preview is proper.  When I had it at 20 it was running off the page.

Thanks I did notice that myself and forgot to come back and update my post I appreciate you responding to it though.
Thank you sooooooo much for this. It was driving me crazy!!
Man, I wish I could tell you how grateful I am that you posted this. Its ben driving me crazy for months. AND how stupid I feel for not having realized what the problem was. Thanks for taking the time to post the solution!