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...
You are welcome. 4-years old post and the answer still works.
Excel is infinite as universe, school never could cover all topics. No one pro, includes MVP:s and Microsoft Excel team, knows everything about Excel. Sure they know more than average user, but the main profit they could ask each other directly.
Thanks you so much, for the explanation, we learn everyday and some of these tricks are never taught from school and after so much time loses and struggled, then go on searching on these forumns, we come up with the guys like like Serge Baklan, so get solutions and never leave any thanks.
I have a similar issue, and although I tried un-ticking the 'Scale content' box, it did not resolve the issue.
The issue is with the text re-scaling withing a merged cell, which makes it look different in Page Layout to Print Preview. I think that's what is happening, so in the Walls cell, there are empty rows at the bottom of the cell, which are filled in. I am printing 'No scale', so 100%, and have some custom margins.
You are a saviour SergeiBaklan . I had a similar problem while printing the invoices. Despite selecting the printing area in the landscape, checking fit all columns and leaving 0 margins for header/footer/top/bottom/left/right, the final prints were leaving some bank space at one side of the page.
Your solution fixed it. Many thanks for kindly sharing the solution. SergeiBaklan
Thanks for sharing your problem Gano1224 . Great Help.
I'm currently on Excel v2205, but I'm still having issues with the preview not being the same as the print. But to make matters worse (for me) after I "print" (to PDF) the screen actually changes what I'm seeing in Page Layout... But as soon as I click on Print/Print Preview, the layout changes and moved things up a few rows?
Below are some screenshots of what's I'm seeing.
1. I've deselected the Scale content checkbox in Options/Advanced
2. I then attempt to Print - note the last few lines that should be on the 2nd page
3. Attempting to Save the PDF, to overwrite the existing "test" file.
4. After the Save, the screen immediately changes/updates and move the rows down slightly.
I've have both the Excel page layout set to A4, I also have the PDF printer set to A4. I do have the page setup selected to fit 1 page wide, and infinite tall.
The really stupid thing is... Before doing a print (to PDF) the rows are on the wrong page, after the Print, they move to the 2nd page. But now if I just try and Cut and Paste them (to move them), the moment I Cut, the screen updates and moves things around once more!? So no matter what I do, the screen changes itself?
If I re-select the Scale option in Options/Advanced, the preview remains wrong, the PDF is then correct, and the Pay Layout screen still updates itself every time I do something? π€
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!
"}},"componentScriptGroups({\"componentId\":\"custom.widget.MicrosoftFooter\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"messages({\"constraints\":{\"solution\":{\"eq\":true},\"topicId\":{\"eq\":\"message:1030343\"}},\"first\":10,\"sorts\":{\"postTime\":{\"direction\":\"ASC\"}}})":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8aXwxMHwxMzI6MXxpbnQsMTAzODg2NywxMDM4ODY3","node":{"__ref":"AcceptedSolutionMessage:message:1038867"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null},"totalCount":1},"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/LinearReplyList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/LinearReplyList-1745505307000"}],"message({\"id\":\"message:1038342\"})":{"__ref":"ForumReplyMessage:message:1038342"},"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"components/attachments/AttachmentView/AttachmentViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505307000"}],"cachedText({\"lastModified\":\"1745505307000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1745505307000"}],"message({\"id\":\"message:4199900\"})":{"__ref":"ForumReplyMessage:message:4199900"},"message({\"id\":\"message:4199729\"})":{"__ref":"ForumReplyMessage:message:4199729"},"message({\"id\":\"message:4081222\"})":{"__ref":"ForumReplyMessage:message:4081222"},"message({\"id\":\"message:4075952\"})":{"__ref":"ForumReplyMessage:message:4075952"},"message({\"id\":\"message:4075840\"})":{"__ref":"ForumReplyMessage:message:4075840"},"message({\"id\":\"message:3608208\"})":{"__ref":"ForumReplyMessage:message:3608208"},"message({\"id\":\"message:3482280\"})":{"__ref":"ForumReplyMessage:message:3482280"},"message({\"id\":\"message:3473627\"})":{"__ref":"ForumReplyMessage:message:3473627"},"message({\"id\":\"message:3278574\"})":{"__ref":"ForumReplyMessage:message:3278574"},"message({\"id\":\"message:3043346\"})":{"__ref":"ForumReplyMessage:message:3043346"},"message({\"id\":\"message:3719858\"})":{"__ref":"ForumReplyMessage:message:3719858"},"message({\"id\":\"message:3704054\"})":{"__ref":"ForumReplyMessage:message:3704054"},"message({\"id\":\"message:3678363\"})":{"__ref":"ForumReplyMessage:message:3678363"},"message({\"id\":\"message:3675545\"})":{"__ref":"ForumReplyMessage:message:3675545"},"message({\"id\":\"message:3643520\"})":{"__ref":"ForumReplyMessage:message:3643520"},"message({\"id\":\"message:3891975\"})":{"__ref":"ForumReplyMessage:message:3891975"},"message({\"id\":\"message:3887077\"})":{"__ref":"ForumReplyMessage:message:3887077"},"message({\"id\":\"message:3886844\"})":{"__ref":"ForumReplyMessage:message:3886844"},"message({\"id\":\"message:3778533\"})":{"__ref":"ForumReplyMessage:message:3778533"},"message({\"id\":\"message:3755810\"})":{"__ref":"ForumReplyMessage:message:3755810"},"message({\"id\":\"message:4074057\"})":{"__ref":"ForumReplyMessage:message:4074057"},"message({\"id\":\"message:4031462\"})":{"__ref":"ForumReplyMessage:message:4031462"},"message({\"id\":\"message:4004008\"})":{"__ref":"ForumReplyMessage:message:4004008"},"message({\"id\":\"message:3943114\"})":{"__ref":"ForumReplyMessage:message:3943114"},"message({\"id\":\"message:3931198\"})":{"__ref":"ForumReplyMessage:message:3931198"}},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Deleted","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"false","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MMM dd yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US","es-ES"]},"repliesSortOrder":{"__typename":"InheritableStringSettingWithPossibleValues","key":"config.user_replies_sort_order","value":"DEFAULT","localValue":"DEFAULT","possibleValues":["DEFAULT","LIKES","PUBLISH_TIME","REVERSE_PUBLISH_TIME"]}},"deleted":false},"CachedAsset:pages-1746563201607":{"__typename":"CachedAsset","id":"pages-1746563201607","value":[{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"UserBlogPermissions.Page","type":"COMMUNITY","urlPath":"/c/user-blog-permissions/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"AllEvents","type":"CUSTOM","urlPath":"/Events","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"CommunityHub.Page","type":"CUSTOM","urlPath":"/Directory","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"AllBlogs.Page","type":"CUSTOM","urlPath":"/blogs","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1746563201607,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}","userBanned":"We're sorry, but you have been banned from using this site.","userBannedReason":"You have been banned for the following reason: {reason}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"Rank:rank:37":{"__typename":"Rank","id":"rank:37","position":18,"name":"Copper Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:468222":{"__typename":"User","id":"user:468222","uid":468222,"login":"Gano1224","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"email":"","messagesCount":9,"biography":null,"topicsCount":1,"kudosReceivedCount":5,"kudosGivenCount":2,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-11-25T05:58:28.880-08:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"Category:category:microsoft365":{"__typename":"Category","id":"category:microsoft365","entityType":"CATEGORY","displayId":"microsoft365","nodeType":"category","depth":3,"title":"Microsoft 365","shortTitle":"Microsoft 365","parent":{"__ref":"Category:category:products-services"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","entityType":"CATEGORY","displayId":"top","nodeType":"category","depth":0,"title":"Top","shortTitle":"Top"},"Category:category:communities":{"__typename":"Category","id":"category:communities","entityType":"CATEGORY","displayId":"communities","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Communities","shortTitle":"Communities"},"Category:category:products-services":{"__typename":"Category","id":"category:products-services","entityType":"CATEGORY","displayId":"products-services","nodeType":"category","depth":2,"parent":{"__ref":"Category:category:communities"},"title":"Products","shortTitle":"Products"},"Forum:board:ExcelGeneral":{"__typename":"Forum","id":"board:ExcelGeneral","entityType":"FORUM","displayId":"ExcelGeneral","nodeType":"board","depth":4,"conversationStyle":"FORUM","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"REVERSE_PUBLISH_TIME","repliesFormat":"threaded"},"tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"PRESET_ONLY","description":"Your community for how-to discussions and sharing best practices on Microsoft Excel. If youβre looking for technical support, please visit Microsoft Support Community.","title":"Excel","shortTitle":"Excel","parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:communities"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:products-services"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:microsoft365"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"theme":{"__ref":"Theme:customTheme1"},"boardPolicies":{"__typename":"BoardPolicies","canViewSpamDashBoard":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.access_spam_quarantine.allowed.accessDenied","args":[]}},"canArchiveMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","key":"error.lithium.policies.content_archivals.enable_content_archival_settings.accessDenied","args":[]}},"canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/"},"ForumTopicMessage:message:1030343":{"__typename":"ForumTopicMessage","uid":1030343,"subject":"Excel Print Preview not matching the actual printed document","id":"message:1030343","revisionNum":1,"repliesCount":62,"author":{"__ref":"User:user:468222"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:1030343"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:1030343"},"body@stripHtml({\"truncateLength\":200})":" 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...","body@stringLength":"459","rawBody":"
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 the last 2 weeks, none of the documents I've printed are coming out the way they appear on the workbook.
I have a workbook that should be 23 pages but it prints 26 instead. The rows are extending over into other pages.
Please help!!
","kudosSumWeight":4,"postTime":"2019-11-25T06:07:45.149-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:excel","text":"excel","time":"2016-06-21T14:08:51.129-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDI","node":{"__typename":"Tag","id":"tag:office 365","text":"office 365","time":"2016-06-27T01:27:02.990-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDM","node":{"__typename":"Tag","id":"tag:print","text":"print","time":"2018-11-11T12:45:33.874-08:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjUuM3wyLjF8b3wxMHxfTlZffDQ","node":{"__typename":"Tag","id":"tag:Printing Problem","text":"Printing Problem","time":"2019-10-03T14:25:48.004-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:1030343_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":419035},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[]},"Conversation:conversation:1030343":{"__typename":"Conversation","id":"conversation:1030343","solved":true,"topic":{"__ref":"ForumTopicMessage:message:1030343"},"lastPostingActivityTime":"2025-03-31T06:05:54.616-07:00","lastPostTime":"2025-03-31T06:05:54.616-07:00","unreadReplyCount":62,"isSubscribed":false},"ModerationData:moderation_data:1030343":{"__typename":"ModerationData","id":"moderation_data:1030343","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:1030343_1":{"__typename":"Revision","id":"revision:1030343_1","lastEditTime":"2019-11-25T06:07:45.149-08:00"},"AcceptedSolutionMessage:message:1038867":{"__typename":"AcceptedSolutionMessage","id":"message:1038867","conversation":{"__ref":"Conversation:conversation:1030343"},"author":{"__ref":"User:user:521"},"revisionNum":1,"uid":1038867,"depth":7,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Excel Print Preview not matching the actual printed document","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:1038867"},"parent":{"__ref":"ForumReplyMessage:message:1038342"},"body":"
Hey, I've attached an excel spreadsheet example of what I was talking about, as well as 2 PDFs to explain further.
The \"Print to PDF\" document shows the correct layout
The \"Save as PDF\" document shows how it comes out of the printer - which is a complete mess (for me)
I'd appreciate any insight you can give.
","body@stringLength":"575","rawBody":"
Hey, I've attached an excel spreadsheet example of what I was talking about, as well as 2 PDFs to explain further.
The \"Print to PDF\" document shows the correct layout
The \"Save as PDF\" document shows how it comes out of the printer - which is a complete mess (for me)
I'd appreciate any insight you can give.
","author":{"__ref":"User:user:468222"},"isEscalated":null,"postTime":"2019-11-28T06:30:28.747-08:00","solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[{"__typename":"AttachmentEdge","cursor":"MjUuM3wyLjF8b3w1fF9OVl98MQ","node":{"__ref":"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber1\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/1/PRIMARY.xlsx\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuM3wyLjF8b3w1fF9OVl98Mg","node":{"__ref":"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber2\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/2/PRIMARY%20-%20Print%20to%20PDF.pdf\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuM3wyLjF8b3w1fF9OVl98Mw","node":{"__ref":"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber3\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/3/PRIMARY%20-%20Save%20as%20PDF.pdf\"}"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0xMDM4ODY3LTE1OTM2MGkyOTQ4OEIyNDAzOUY4QjhG?revision=1\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0xMDM4ODY3LTE1OTM2MGkyOTQ4OEIyNDAzOUY4QjhG?revision=1","title":"image.png","associationType":"BODY","width":593,"height":374,"altText":null},"Attachment:{\"id\":\"attachment:message1038867AttachmentNumber1\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45379/1/PRIMARY%20without%20scale.pdf\"}":{"__typename":"Attachment","id":"attachment:message1038867AttachmentNumber1","filename":"PRIMARY without scale.pdf","filesize":196775,"contentType":"application/pdf","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45379/1/PRIMARY%20without%20scale.pdf"},"Attachment:{\"id\":\"attachment:message1038867AttachmentNumber2\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45379/2/PRIMARY%20with%20scale.pdf\"}":{"__typename":"Attachment","id":"attachment:message1038867AttachmentNumber2","filename":"PRIMARY with scale.pdf","filesize":197179,"contentType":"application/pdf","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45379/2/PRIMARY%20with%20scale.pdf"},"Revision:revision:1038867_1":{"__typename":"Revision","id":"revision:1038867_1","lastEditTime":"2019-11-28T12:38:00.959-08:00"},"QueryVariables:ReplyList:message:1038867:1":{"__typename":"QueryVariables","id":"ReplyList:message:1038867:1","value":{"id":"message:1038867","sorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1745505307000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1745505307000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1745505307000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1745505307000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1745505307000","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/LinearReplyList-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/LinearReplyList-1745505307000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber1\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/1/PRIMARY.xlsx\"}":{"__typename":"Attachment","id":"attachment:message1038342AttachmentNumber1","filename":"PRIMARY.xlsx","filesize":20366,"contentType":"application/octet-stream","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/1/PRIMARY.xlsx"},"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber2\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/2/PRIMARY%20-%20Print%20to%20PDF.pdf\"}":{"__typename":"Attachment","id":"attachment:message1038342AttachmentNumber2","filename":"PRIMARY - Print to PDF.pdf","filesize":482163,"contentType":"application/pdf","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/2/PRIMARY%20-%20Print%20to%20PDF.pdf"},"Attachment:{\"id\":\"attachment:message1038342AttachmentNumber3\",\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/3/PRIMARY%20-%20Save%20as%20PDF.pdf\"}":{"__typename":"Attachment","id":"attachment:message1038342AttachmentNumber3","filename":"PRIMARY - Save as PDF.pdf","filesize":91123,"contentType":"application/pdf","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/attachments/gxcuf89792/ExcelGeneral/45344/3/PRIMARY%20-%20Save%20as%20PDF.pdf"},"User:user:2591473":{"__typename":"User","id":"user:2591473","deleted":false,"uid":2591473,"login":"liezelsmit","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-07-23T21:15:42.274-07:00"},"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-7.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2591473"},"ForumReplyMessage:message:4199729":{"__typename":"ForumReplyMessage","uid":4199729,"id":"message:4199729","revisionNum":1,"author":{"__ref":"User:user:2591473"},"readOnly":false,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4199729"},"body":"
SergeiBaklan I realise I'm a bit late to the party, but just wanted to say that this was extremely helpful to me as well. Thank you!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"139","kudosSumWeight":1,"postTime":"2024-07-23T21:16:51.495-07:00","lastPublishTime":"2024-07-23T21:16:51.495-07:00","metrics":{"__typename":"MessageMetrics","views":435},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4199729","repliesCount":1,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:4199900":{"__typename":"ModerationData","id":"moderation_data:4199900","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4199900":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:521"},"id":"message:4199900","revisionNum":1,"uid":4199900,"depth":9,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:4199729"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4199900"},"body":"
liezelsmit , glad it helped, thank you for the feedback
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"62","kudosSumWeight":0,"postTime":"2024-07-24T01:24:54.099-07:00","lastPublishTime":"2024-07-24T01:24:54.099-07:00","metrics":{"__typename":"MessageMetrics","views":412},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4199900","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:4199729":{"__typename":"ModerationData","id":"moderation_data:4199729","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"User:user:2357563":{"__typename":"User","id":"user:2357563","uid":2357563,"login":"Maia_93","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-03-10T23:13:35.186-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2357563"},"ModerationData:moderation_data:4081222":{"__typename":"ModerationData","id":"moderation_data:4081222","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4081222":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2357563"},"id":"message:4081222","revisionNum":1,"uid":4081222,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4081222"},"body":"Wow.. Thank you so much for this.. It also solved mine π₯°π","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"59","kudosSumWeight":1,"postTime":"2024-03-10T23:16:02.592-07:00","lastPublishTime":"2024-03-10T23:16:02.592-07:00","metrics":{"__typename":"MessageMetrics","views":2245},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4081222","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"User:user:2347054":{"__typename":"User","id":"user:2347054","deleted":false,"uid":2347054,"login":"raphidk","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-03-05T01:45:08.315-08:00"},"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2347054"},"ForumReplyMessage:message:4075840":{"__typename":"ForumReplyMessage","uid":4075840,"id":"message:4075840","revisionNum":1,"author":{"__ref":"User:user:2347054"},"readOnly":false,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4075840"},"body":"
Thanks you so much, for the explanation, we learn everyday and some of these tricks are never taught from school and after so much time loses and struggled, then go on searching on these forumns, we come up with the guys like like Serge Baklan, so get solutions and never leave any thanks.
Thank you
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"postTime":"2024-03-05T01:47:59.707-08:00","lastPublishTime":"2024-03-05T01:47:59.707-08:00","metrics":{"__typename":"MessageMetrics","views":2311},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4075840","repliesCount":1,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:4075952":{"__typename":"ModerationData","id":"moderation_data:4075952","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4075952":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:521"},"id":"message:4075952","revisionNum":1,"uid":4075952,"depth":9,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:4075840"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4075952"},"body":"
You are welcome. 4-years old post and the answer still works.
\n
Excel is infinite as universe, school never could cover all topics. No one pro, includes MVP:s and Microsoft Excel team, knows everything about Excel. Sure they know more than average user, but the main profit they could ask each other directly.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"postTime":"2024-03-05T03:17:49.025-08:00","lastPublishTime":"2024-03-05T03:17:49.025-08:00","metrics":{"__typename":"MessageMetrics","views":2293},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4075952","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:4075840":{"__typename":"ModerationData","id":"moderation_data:4075840","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"User:user:2343134":{"__typename":"User","id":"user:2343134","uid":2343134,"login":"Iam_MAA","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-03-02T22:50:45.298-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-4.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2343134"},"ModerationData:moderation_data:4074057":{"__typename":"ModerationData","id":"moderation_data:4074057","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4074057":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2343134"},"id":"message:4074057","revisionNum":1,"uid":4074057,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4074057"},"body":"
I was wondering the issue since past few weeks, you are awesome.
even our IT admin can't find the solution.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"139","kudosSumWeight":1,"postTime":"2024-03-02T22:53:03.978-08:00","lastPublishTime":"2024-03-02T22:53:03.978-08:00","metrics":{"__typename":"MessageMetrics","views":2300},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4074057","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:2255495":{"__typename":"User","id":"user:2255495","uid":2255495,"login":"vanthuong1192","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-01-16T22:41:27.821-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2255495"},"ModerationData:moderation_data:4031462":{"__typename":"ModerationData","id":"moderation_data:4031462","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4031462":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2255495"},"id":"message:4031462","revisionNum":1,"uid":4031462,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4031462"},"body":"Thank you very much!","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"20","kudosSumWeight":1,"postTime":"2024-01-16T22:50:26.254-08:00","lastPublishTime":"2024-01-16T22:50:26.254-08:00","metrics":{"__typename":"MessageMetrics","views":2531},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4031462","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:2190433":{"__typename":"User","id":"user:2190433","uid":2190433,"login":"layling","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-12-07T20:44:17.040-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-4.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2190433"},"ModerationData:moderation_data:4004008":{"__typename":"ModerationData","id":"moderation_data:4004008","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4004008":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2190433"},"id":"message:4004008","revisionNum":1,"uid":4004008,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:4004008"},"body":"Amazing thanks","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"14","kudosSumWeight":1,"postTime":"2023-12-07T20:45:04.513-08:00","lastPublishTime":"2023-12-07T20:45:04.513-08:00","metrics":{"__typename":"MessageMetrics","views":2925},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:4004008","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:2058364":{"__typename":"User","id":"user:2058364","uid":2058364,"login":"UsharaDJ","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-10-01T23:57:27.055-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2058364"},"ModerationData:moderation_data:3943114":{"__typename":"ModerationData","id":"moderation_data:3943114","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3943114":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2058364"},"id":"message:3943114","revisionNum":1,"uid":3943114,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3943114"},"body":"You are life savior.. I also got the same issue and the solution is this.. Thank you very much Sir...!","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"102","kudosSumWeight":1,"postTime":"2023-10-01T23:59:55.953-07:00","lastPublishTime":"2023-10-01T23:59:55.953-07:00","metrics":{"__typename":"MessageMetrics","views":3321},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3943114","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:2035786":{"__typename":"User","id":"user:2035786","uid":2035786,"login":"JakubGlu","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-09-18T23:12:28.860-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-4.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:2035786"},"ForumReplyMessage:message:3887077":{"__typename":"ForumReplyMessage","uid":3887077,"id":"message:3887077","revisionNum":1,"author":{"__ref":"User:user:521"},"readOnly":false,"depth":9,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:3886844"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3887077"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"40","kudosSumWeight":0,"postTime":"2023-07-29T12:01:00.320-07:00","lastPublishTime":"2023-07-29T12:01:00.320-07:00","metrics":{"__typename":"MessageMetrics","views":3691},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3887077","repliesCount":1,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:3931198":{"__typename":"ModerationData","id":"moderation_data:3931198","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3931198":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2035786"},"id":"message:3931198","revisionNum":1,"uid":3931198,"depth":10,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:3887077"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3931198"},"body":"
I have a problem since 6 years and no solution but I have exacly same problem as others here.
I can recognise 3 diffrent view
* view in excell 100% zoom
* view in excel 90% (usualy can be diffrent than 100%)
* preview (just before printing)
* PDF
all this above can be difrent depend situation.
Can I send you my excel example? maybe you could help me?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"218","kudosSumWeight":0,"postTime":"2023-09-18T23:16:21.864-07:00","lastPublishTime":"2023-09-18T23:16:21.864-07:00","metrics":{"__typename":"MessageMetrics","views":3392},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3931198","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1968313":{"__typename":"User","id":"user:1968313","uid":1968313,"login":"nightcrawler01","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-08-05T01:56:53.701-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1968313"},"ModerationData:moderation_data:3891975":{"__typename":"ModerationData","id":"moderation_data:3891975","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3891975":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1968313"},"id":"message:3891975","revisionNum":3,"uid":3891975,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3891975"},"body":"
Almost 4 years later and this is still helping. You've saved me from pulling my hair out. Thank you.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"102","kudosSumWeight":1,"postTime":"2023-08-05T01:59:15.626-07:00","lastPublishTime":"2023-08-05T02:00:10.015-07:00","metrics":{"__typename":"MessageMetrics","views":3628},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3891975","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"User:user:1958647":{"__typename":"User","id":"user:1958647","deleted":false,"uid":1958647,"login":"Mae_G25","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-07-28T17:54:08.818-07:00"},"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-2.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1958647"},"ForumReplyMessage:message:3886844":{"__typename":"ForumReplyMessage","uid":3886844,"id":"message:3886844","revisionNum":1,"author":{"__ref":"User:user:1958647"},"readOnly":false,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3886844"},"body":"
SergeiBaklan omg. all I can say is thank you.. I've been figuring it out why won't it come out identical. You're the best π
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"132","kudosSumWeight":1,"postTime":"2023-07-28T17:55:56.072-07:00","lastPublishTime":"2023-07-28T17:55:56.072-07:00","metrics":{"__typename":"MessageMetrics","views":3693},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3886844","repliesCount":2,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"ModerationData:moderation_data:3887077":{"__typename":"ModerationData","id":"moderation_data:3887077","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ModerationData:moderation_data:3886844":{"__typename":"ModerationData","id":"moderation_data:3886844","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"User:user:1794824":{"__typename":"User","id":"user:1794824","uid":1794824,"login":"Needhu","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-03-25T01:23:37.235-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1794824"},"ModerationData:moderation_data:3778533":{"__typename":"ModerationData","id":"moderation_data:3778533","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3778533":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1794824"},"id":"message:3778533","revisionNum":1,"uid":3778533,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3778533"},"body":"I was also having the same problem for month, Thanks for your help","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"66","kudosSumWeight":1,"postTime":"2023-03-25T01:26:08.380-07:00","lastPublishTime":"2023-03-25T01:26:08.380-07:00","metrics":{"__typename":"MessageMetrics","views":4405},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3778533","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"User:user:1754895":{"__typename":"User","id":"user:1754895","uid":1754895,"login":"Saravanan1971","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-02-28T22:28:59.689-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1754895"},"ModerationData:moderation_data:3755810":{"__typename":"ModerationData","id":"moderation_data:3755810","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3755810":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1754895"},"id":"message:3755810","revisionNum":1,"uid":3755810,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3755810"},"body":"Really excellent solution for this issue. Thanks lot.","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"53","kudosSumWeight":1,"postTime":"2023-02-28T22:36:13.183-08:00","lastPublishTime":"2023-02-28T22:36:13.183-08:00","metrics":{"__typename":"MessageMetrics","views":4597},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3755810","repliesCount":0,"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"User:user:1695983":{"__typename":"User","id":"user:1695983","uid":1695983,"login":"cchirpac","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-01-19T01:54:28.104-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1695983"},"ModerationData:moderation_data:3719858":{"__typename":"ModerationData","id":"moderation_data:3719858","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3719858":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1695983"},"id":"message:3719858","revisionNum":1,"uid":3719858,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3719858"},"body":"
I have a similar issue, and although I tried un-ticking the 'Scale content' box, it did not resolve the issue.
The issue is with the text re-scaling withing a merged cell, which makes it look different in Page Layout to Print Preview. I think that's what is happening, so in the Walls cell, there are empty rows at the bottom of the cell, which are filled in. I am printing 'No scale', so 100%, and have some custom margins.
Any help would be appreciated.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":0,"postTime":"2023-01-19T02:02:03.228-08:00","lastPublishTime":"2023-01-19T02:02:03.228-08:00","metrics":{"__typename":"MessageMetrics","views":4836},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3719858","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:723464":{"__typename":"User","id":"user:723464","uid":723464,"login":"jabbar_abdul123","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-07-09T04:32:04.242-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-2.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:723464"},"ModerationData:moderation_data:3704054":{"__typename":"ModerationData","id":"moderation_data:3704054","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3704054":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:723464"},"id":"message:3704054","revisionNum":1,"uid":3704054,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3704054"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"48","kudosSumWeight":1,"postTime":"2022-12-25T23:37:36.744-08:00","lastPublishTime":"2022-12-25T23:37:36.744-08:00","metrics":{"__typename":"MessageMetrics","views":4990},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3704054","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1616189":{"__typename":"User","id":"user:1616189","uid":1616189,"login":"TwiceJihyoStan","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-11-16T21:48:29.717-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1616189"},"ModerationData:moderation_data:3678363":{"__typename":"ModerationData","id":"moderation_data:3678363","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3678363":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1616189"},"id":"message:3678363","revisionNum":1,"uid":3678363,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3678363"},"body":"Omg. It's Nov 2022 and this really helped me. Thank u so much!","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"62","kudosSumWeight":1,"postTime":"2022-11-16T21:49:52.246-08:00","lastPublishTime":"2022-11-16T21:49:52.246-08:00","metrics":{"__typename":"MessageMetrics","views":5099},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3678363","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1611009":{"__typename":"User","id":"user:1611009","uid":1611009,"login":"sampatkumar","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-11-13T22:00:05.621-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1611009"},"ModerationData:moderation_data:3675545":{"__typename":"ModerationData","id":"moderation_data:3675545","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3675545":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1611009"},"id":"message:3675545","revisionNum":1,"uid":3675545,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3675545"},"body":"
You are a saviour SergeiBaklan . I had a similar problem while printing the invoices. Despite selecting the printing area in the landscape, checking fit all columns and leaving 0 margins for header/footer/top/bottom/left/right, the final prints were leaving some bank space at one side of the page.
Your solution fixed it. Many thanks for kindly sharing the solution. SergeiBaklan
Thanks for sharing your problem Gano1224 . Great Help.
Cheers!!!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":1,"postTime":"2022-11-13T22:11:06.850-08:00","lastPublishTime":"2022-11-13T22:11:06.850-08:00","metrics":{"__typename":"MessageMetrics","views":5139},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3675545","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1549045":{"__typename":"User","id":"user:1549045","uid":1549045,"login":"Deefer197","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-10-03T15:10:44.980-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-8.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1549045"},"ForumReplyMessage:message:1044153":{"__typename":"ForumReplyMessage","uid":1044153,"id":"message:1044153","revisionNum":1,"author":{"__ref":"User:user:468222"},"readOnly":false},"ModerationData:moderation_data:3643520":{"__typename":"ModerationData","id":"moderation_data:3643520","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3643520":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1549045"},"id":"message:3643520","revisionNum":1,"uid":3643520,"depth":9,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:1044153"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3643520"},"body":"
I found this thread while googling to prevent pulling all of my hair out... my hero too!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"106","kudosSumWeight":1,"postTime":"2022-10-03T15:12:31.832-07:00","lastPublishTime":"2022-10-03T15:12:31.832-07:00","metrics":{"__typename":"MessageMetrics","views":5271},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3643520","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1496501":{"__typename":"User","id":"user:1496501","uid":1496501,"login":"GianTav","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-08-24T06:17:21.009-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1496501"},"ModerationData:moderation_data:3608208":{"__typename":"ModerationData","id":"moderation_data:3608208","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3608208":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1496501"},"id":"message:3608208","revisionNum":1,"uid":3608208,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3608208"},"body":"
SergeiBaklan Wow! you are my hero as well Sergei. This was doing my head in.
Thank you so much!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"123","kudosSumWeight":0,"postTime":"2022-08-24T06:20:31.199-07:00","lastPublishTime":"2022-08-24T06:20:31.199-07:00","metrics":{"__typename":"MessageMetrics","views":5400},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3608208","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1417800":{"__typename":"User","id":"user:1417800","uid":1417800,"login":"Minxster","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-06-08T07:07:12.171-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1417800"},"ModerationData:moderation_data:3482280":{"__typename":"ModerationData","id":"moderation_data:3482280","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3482280":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1417800"},"id":"message:3482280","revisionNum":1,"uid":3482280,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3482280"},"body":"
I'm currently on Excel v2205, but I'm still having issues with the preview not being the same as the print. But to make matters worse (for me) after I \"print\" (to PDF) the screen actually changes what I'm seeing in Page Layout... But as soon as I click on Print/Print Preview, the layout changes and moved things up a few rows?
Below are some screenshots of what's I'm seeing.
1. I've deselected the Scale content checkbox in Options/Advanced
2. I then attempt to Print - note the last few lines that should be on the 2nd page
3. Attempting to Save the PDF, to overwrite the existing \"test\" file.
4. After the Save, the screen immediately changes/updates and move the rows down slightly.
I've have both the Excel page layout set to A4, I also have the PDF printer set to A4. I do have the page setup selected to fit 1 page wide, and infinite tall.
The really stupid thing is... Before doing a print (to PDF) the rows are on the wrong page, after the Print, they move to the 2nd page. But now if I just try and Cut and Paste them (to move them), the moment I Cut, the screen updates and moves things around once more!? So no matter what I do, the screen changes itself?
If I re-select the Scale option in Options/Advanced, the preview remains wrong, the PDF is then correct, and the Pay Layout screen still updates itself every time I do something? π€
Excel 01
Excel 02
Excel 03
Excel 04
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":0,"postTime":"2022-06-08T07:27:14.166-07:00","lastPublishTime":"2022-06-08T07:27:14.166-07:00","metrics":{"__typename":"MessageMetrics","views":5596},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3482280","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1415549":{"__typename":"User","id":"user:1415549","uid":1415549,"login":"VZRod639","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-06-06T13:02:08.972-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1415549"},"ForumReplyMessage:message:2875613":{"__typename":"ForumReplyMessage","uid":2875613,"id":"message:2875613","revisionNum":1,"author":{"__ref":"User:user:521"},"readOnly":false},"ModerationData:moderation_data:3473627":{"__typename":"ModerationData","id":"moderation_data:3473627","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3473627":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1415549"},"id":"message:3473627","revisionNum":1,"uid":3473627,"depth":10,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:2875613"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3473627"},"body":"
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!
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"218","kudosSumWeight":0,"postTime":"2022-06-06T13:09:48.821-07:00","lastPublishTime":"2022-06-06T13:09:48.821-07:00","metrics":{"__typename":"MessageMetrics","views":12987},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3473627","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1356226":{"__typename":"User","id":"user:1356226","uid":1356226,"login":"caio_caminoski","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-04-07T01:37:54.980-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1356226"},"ModerationData:moderation_data:3278574":{"__typename":"ModerationData","id":"moderation_data:3278574","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3278574":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1356226"},"id":"message:3278574","revisionNum":1,"uid":3278574,"depth":8,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"AcceptedSolutionMessage:message:1038867"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3278574"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"37","kudosSumWeight":1,"postTime":"2022-04-07T01:38:40.378-07:00","lastPublishTime":"2022-04-07T01:38:40.378-07:00","metrics":{"__typename":"MessageMetrics","views":13741},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3278574","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:1256333":{"__typename":"User","id":"user:1256333","uid":1256333,"login":"Vaibhav_Suresh_Kale","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-12-21T00:55:44.801-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"entityType":"USER","eventPath":"community:gxcuf89792/user:1256333"},"ForumReplyMessage:message:3033904":{"__typename":"ForumReplyMessage","uid":3033904,"id":"message:3033904","revisionNum":1,"author":{"__ref":"User:user:521"},"readOnly":false},"ModerationData:moderation_data:3043346":{"__typename":"ModerationData","id":"moderation_data:3043346","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3043346":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1256333"},"id":"message:3043346","revisionNum":1,"uid":3043346,"depth":10,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:3033904"},"conversation":{"__ref":"Conversation:conversation:1030343"},"subject":"Re: Excel Print Preview not matching the actual printed document","moderationData":{"__ref":"ModerationData:moderation_data:3043346"},"body":"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"39","kudosSumWeight":1,"postTime":"2021-12-21T00:59:33.108-08:00","lastPublishTime":"2021-12-21T00:59:33.108-08:00","metrics":{"__typename":"MessageMetrics","views":14982},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:1030343/message:3043346","repliesCount":0,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1745505307000","value":{"errorTitle":"Failed!","previewFile":"Preview File","downloadFile":"Download File {name}","removeFile":"Remove File {name}","errorBadExtension":"This file does not have a valid extension. \"{extensions}\" are the valid extensions.","errorFileEmpty":"This file is empty or does not exist.","errorTooLarge":"The maximum file size is: {maxFileSize}.","errorTooMany":"Too many attachments. The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1745505307000","value":{"loadMore":"Show More"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"excelgeneral","messageSubject":"excel-print-preview-not-matching-the-actual-printed-document","messageId":"1030343","replyId":"1038867"},"buildId":"-gVUpXaWnPcjlrLJZ92B7","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"o365","openTelemetryServiceVersion":"25.3.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/external/components/ExternalComponent.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/attachments/AttachmentView/AttachmentView.tsx","./components/attachments/AttachmentView/AttachmentViewChip/AttachmentViewChip.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx"],"appGip":true,"scriptLoader":[{"id":"analytics","src":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/pagescripts/1730819800000/analytics.js?page.id=ForumReplyPage&entity.id=board%3Aexcelgeneral&entity.id=message%3A1038867","strategy":"afterInteractive"}]}