Excel – Print area changes when copying a worksheet (only in my account)

Our take

Have you ever faced the frustration of your print area shifting when copying a worksheet in Excel? This issue, particularly in your M365 account, can feel perplexing when everything appears to work seamlessly in another account. Fortunately, there’s a clear connection between your settings and this unexpected behavior. By understanding how print areas are defined and potentially altered, you can regain control over your Excel documents. Let’s explore the steps to diagnose and resolve this issue, ensuring your print areas remain consistent and reliable.

I’m having the following issue:

When I copy a worksheet in Excel, the print area changes in the copied version. This only happens in my M365 account. If I create the same copy using a different M365 account, the print area / formatting is correct.

Steps I’m using:

- Right-click the worksheet tab → Move or Copy

- Select Move selected sheets (To book)

- Choose (new workbook) and check Create a copy

Result:

Original: print area ends between row 63 and 64

Copy: print area ends between row 58 and 59

I strongly suspect that I’ve accidentally changed some Excel setting in my account, but I can’t figure out what it is.

Has anyone seen this before or has an idea what could cause this?

Thanks in advance!

https://preview.redd.it/m1ap8sz8smhg1.png?width=1107&format=png&auto=webp&s=9a801b29c9ec6c188a0dac2be5603fce2ce36a24

https://preview.redd.it/yngby6j9smhg1.png?width=1108&format=png&auto=webp&s=f47c599c6d009e6ada0efe2775e715f1e18faa56