•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel – Print area changes when copying a worksheet (only in my account)
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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#row zero
#rows.com
#google sheets
#Excel
#print area
#worksheet
#copying
#M365 account
#formatting
#Move or Copy
#Move selected sheets
#new workbook
#Create a copy
#settings
#suspect
#issue
#row
#account