Forum Discussion
Print Preview Not Matching Original Document
wingsofElyon I had the same problem and then started searching for solutions, which led me to your post. I think I know what is going wrong and have managed to fix it on my side. The issues is that when you go into print break preview mode, it gives you the alignment lines in blue. You can adjust these and this is what I did to get the sizing to what I needed - but that is the problem. Excel is allowing you to change the print break lines and knows how to deal with the cells realignment when doing that, but it does not know how to fix that relative to the objects and images we lay over the cells. So it tried to stretch or squash the lines to compensate. I realigned the blue page breaks so that they fit a A4 aspect ration and made sure that both cells and objects / images where aligned in print preview. This worked for me and I managed to get it right.
Hope this helps.