SOLVED

print preview not matching original document

%3CLINGO-SUB%20id%3D%22lingo-sub-2378702%22%20slang%3D%22en-US%22%3Eprint%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378702%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3ENot%20an%20expert%20in%20excel%20but%20I%20know%20my%20way%20around%20printing%20excel%20sheets%20however%26nbsp%3B%20I've%20recently%26nbsp%3B%20encountered%20a%20problem%20where%20the%20print%20preview%20is%20nothing%20like%20the%20original%20document%20every%20thing%20is%20changed%20from%20design%2C%20font%20to%20table%20layout%2C%20tried%20looking%20for%20solutions%20online%20with%20no%20luck.%3C%2FP%3E%3CP%3Eattached%20is%20an%20example%20of%20the%20problem%20am%20faced%20with%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efig%201.%20normal%20view%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelnormalview.GIF%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282917i8B0A4BD5B0D75770%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excelnormalview.GIF%22%20alt%3D%22excelnormalview.GIF%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efig%202.%20print%20preview%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelprintpreview.GIF%22%20style%3D%22width%3A%20979px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282918i9E917CEDFDE194ED%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excelprintpreview.GIF%22%20alt%3D%22excelprintpreview.GIF%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378745%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060940%22%20target%3D%22_blank%22%3E%40_jboy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20Page%20Setup.%20Has%20Print%20Quality%20been%20set%20to%20Draft%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378804%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378804%22%20slang%3D%22en-US%22%3EPrint%20Quality%20has%20only%20one%20option%20of%20600dpi%20which%20is%20set%20at.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378815%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060940%22%20target%3D%22_blank%22%3E%40_jboy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20on%20the%20Sheet%20tab%20of%20the%20Page%20Setup%20dialog%2C%20has%20the%20Draft%20Quality%20check%20box%20been%20ticked%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0442.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282945i0BDD89CDC2DDDDFA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0442.png%22%20alt%3D%22S0442.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378838%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378838%22%20slang%3D%22en-US%22%3ENo%2C%20it's%20unchecked.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378843%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060940%22%20target%3D%22_blank%22%3E%40_jboy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20out%20of%20ideas%2C%20sorry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378846%22%20slang%3D%22en-US%22%3ERe%3A%20print%20preview%20not%20matching%20original%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378846%22%20slang%3D%22en-US%22%3EThanks%20for%20trying.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hey guys,

Not an expert in excel but I know my way around printing excel sheets however  I've recently  encountered a problem where the print preview is nothing like the original document every thing is changed from design, font to table layout, tried looking for solutions online with no luck.

attached is an example of the problem am faced with 

 

fig 1. normal view 

 

excelnormalview.GIF

 

fig 2. print preview 

excelprintpreview.GIF 

10 Replies

@_jboy 

Click Page Setup. Has Print Quality been set to Draft?

Print Quality has only one option of 600dpi which is set at.

@_jboy 

And on the Sheet tab of the Page Setup dialog, has the Draft Quality check box been ticked?

 

S0442.png

No, it's unchecked.

@_jboy 

I'm out of ideas, sorry.

Thanks for trying.
Possibly a corrupted print driver.
Some things to try:
1. Switch the default printer. Even if you have to set it to a PDF Writer, Send to OneNote, fax, etc. Switch it away from EW - does it display the same way in preview? If it looks OK, then the next step is to remove the printer from your computer and re-add it.

2. Open Excel in safe mode. Close Excel then press and hold the Ctrl key firmly when you click to launch Excel (Not the workbook but the app itself). Then open your workbook through file | open - does it preview the same way? If it looks OK, close the application and re-open your file in normal mode. Sometimes running the app through Safe mode irons out some of these quirks.

3. Save the workbook as a PDF then print the PDF. A workaround in case you're not able to print the workbook cleanly in Excel.
best response confirmed by _jboy (Occasional Contributor)
Solution

@_jboy 

If I may add my opinion too.

Believe that Patrck's PDF bypass can work around the problem.

But as it looks in the picture, it can be in the wrong print area.

 

Go to the page layout

Cancel print area

Select the print area in the worksheet

(select with the mouse button held down - area turns gray)

Go back to the page layout Pressure area Click on Select print area

 

Should work.

 

Greetings,

 

Nikolino

I know I don't know anything (Socrates)

Tried every option first to third nothing seems to work.
tried switching the default printer again and it worked thank you so much.