•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Different print outcome from print preview
Our take
Are you frustrated by discrepancies between print preview and actual print outcomes in your Excel documents? This common issue can disrupt your workflow and lead to wasted resources. When your print area, defined through the Name Manager and OFFSET function, is misaligned, it can result in unexpected extra pages during printing. In this discussion, we’ll explore the root causes of this problem and provide practical solutions to ensure your printed documents match your expectations. Keep reading to discover how to achieve accurate printing every time.
I have an excel document where the "print area" is controlled through "name manager". It uses the offset function and reads a row variable to decide how many rows the "print area" has.
The issue is when I go into print preview, though the document is shown as 2 pages, the printing outcome is 3 pages. While the document supposed to print as 3 pages, the actual outcome would be 4 pages. The printing outcome is always 1 page more than whatever is supposed to print as shown in print preview.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience