+ Reply to Thread
Results 1 to 1 of 1

Page breaks change positions depending on the screen i'm working on - how do I fix/lock it

  1. #1
    Registered User
    Join Date
    08-02-2021
    Location
    Aarhus, Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Page breaks change positions depending on the screen i'm working on - how do I fix/lock it

    Hi all
    Hope someone have a tip for me on how to solve my problem.
    I have a report in Excel, and everything looks fine when i have my computer docked at work. Then all the pages fit perfectly when i print to pdf (i convert to pdf from the save as pdf/print to pdf in Excel).
    My problem appears, when I eg. work from home. If I work directly on my laptop or put it on an external screen throug HDMI cabel, then my 31 page report suddenly becomes 71 pages because of the page breaks have changed.
    I can drag the blue lines to make the print area adjusted to the actual 31 paes as intended ,but then it will be a problem next time i'm at the office and dock my computer.
    if i in the print section chose to make all columns fit to one page, then i still have a problem with the page breaks so I end with more pages than intended.

    Is there any way to make sure the page layout works no matter how I look at it?

    Fingers crossed, and thanks for the help!
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Manual page breaks not working
    By dkv98446 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2017, 12:52 PM
  2. Replies: 1
    Last Post: 06-28-2017, 11:28 AM
  3. Page breaks suddenly stopped working.
    By SarahAA in forum Excel General
    Replies: 2
    Last Post: 02-16-2017, 03:06 PM
  4. Clear all page breaks, then insert new breaks at change in data
    By Alex0929 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2014, 03:12 PM
  5. Lock Page Breaks?
    By marcusa in forum Excel General
    Replies: 10
    Last Post: 05-12-2012, 01:57 PM
  6. Replies: 1
    Last Post: 03-15-2009, 06:08 PM
  7. Replies: 0
    Last Post: 11-16-2005, 08:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1