Forum Discussion

Gano1224's avatar
Gano1224
Copper Contributor
Nov 25, 2019
Solved

Excel Print Preview not matching the actual printed document

Hey there, My Excel print preview and printer seem to be out of sync. I keep my excel worksheets in "Page Layout" mode when I work, I find it best when I plan to print the document in the end. In t...
excel
office 365
print
Printing Problem
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 28, 2019

    Gano1224 

    I played only with PDF files, if you uncheck this setting

    it works correctly. Attached are two PDF:s, with and without scale setting.

Lorenzob19's avatar
Lorenzob19
Copper Contributor
Oct 22, 2021
Thank you for the fix. I had been struggling to allign my prints and your solution worked for me.
  • VZRod639's avatar
    VZRod639
    Copper Contributor
    Jun 06, 2022

    SergeiBaklan 

    I've created a table to show alternating blue and white rows.  I see the colors as expected in the print preview, but when I print, no row colors are printing.  I tried exporting to PDF.  Again, the PDF shows the different row colors, but does not print the blue and white rows.  After trying multiple times, I realized there is a very faint "gray" color where the Blue color should be.  I wouldn't mind having the gray color (giving up on the blue), but it is too faint to be effective in separating the rows.  I googled this issue and kept getting the same results (to check to make sure that "Black and white" box was unchecked in the Sheet Tab of the Page Setup: it is not checked.  And to make sure that "Draft quality" is not checked, it isn't.  I really didn't have to check this, because I have 3 rows ABOVE the "Blue and White" rows that are in color and they print just fine.  I really could use your expertise here!  Please and Thank you!