SOLUTION: Set the screen resolution and the zoom setting to that of the computer that the file was formatted on. The second laptop screen resolution was 1920 x 1080 with the zoom setting, in the laptop's Display screen, being set to 125%.įor some reason, Excel uses the screen resolution and/or the zoom setting for determining the page breaks instead of row references.
This laptop's screen resolution was set at 1366 x 768 and the "Make it easier to read what's on your screen" setting (which I'll call the zoom setting), in the laptop's Display screen, was set to 100% (Default).
Please remember to mark the replies as answers if they helped. For example, select Row 64, go to Page Layout > Breaks > Insert Page Break: Hope you can find this helpful. The file was formatted using the first laptop. Besides, a workaround I noticed is that the Page Layout view is correct if we manually add the page breaks between pages. It would move the Page Break up 2 additional rows with each break. Page Break Preview shows only those parts of the active sheet that will print and how the content will be split across pages. It already has Header option by default (I will add Person wise Sales Data. The firstīreak was normal, the second break was 2 rows up, the third was 4 rows up and so on. Click on Page Layout option and it will show you the excel sheet in a page layout. However, on the other laptop, the Page Breaks would slowly shift down throughout the document. When I printed the file or checked the Page Breaks within Excel on one laptop, it was fine. But when I still had to cooperate with Excel users I saw them working on their. The Excel file I was using was saved as a 2016. Ive looked in the Manual, and in the Q&Ain Page Break Preview mode. On this page, quality pie chart examples are selected for anyone to view and use.
#EXCEL 2016 PAGE BREAK PREVIEW WINDOWS 7#
Both had Windows 7 (64-bit) updated to the same specs, Office 2016 (32-bit) updated to the same specs and using the same Printer. 7 hours ago &0183 &32 Average annual salary in Japan by age group (2016). Do you have more than one sheet selected If so, you should see Group in the title bar. My scenario was similar as I had 2 laptops setup the same. You can switch to the Page Layout view or the Page Break Preview view, using the corresponding buttons on the View tab of the Ribbon. I had the same issues and found a solution posted in another forum.
0 kommentar(er)
