•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does my Excel turn on print lines randomly (over night)
Our take
Have you ever woken up to find page break lines strewn across your carefully formatted Excel sheets? This frustrating occurrence can disrupt your financial models, especially when you’ve meticulously set print areas and aligned sections. While it may feel random and perplexing, this issue often stems from Excel's automatic adjustments in response to changes in data, formatting, or printer settings. Understanding the underlying causes can help you regain control over your spreadsheets and maintain the clarity you need for effective data management.
I think I turn nuts. I have a very clean formatted financial model.
Randomly (i.e., not after pressing a certain combination by accident, etc.) I will get up (often in the morning) and see that my sheet has page break lines all over the workbook.
This is particularly annoying for sheets in which I have formatted via page break view + set print area to separate sections, as those are all not aligned anymore.
Why is this the case? Where does this come from?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#rows.com#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#financial modeling#google sheets#financial modeling with spreadsheets#Excel#print lines#page break#financial model#page break view#formatted#workbook#set print area#sections#alignment#randomly