How do I get rid of these dotted lines? Are they something to do with print areas?
Is it not just the page layout/set-up?
have you tried going to ‘view’ and selecting ‘normal’? (i’m guessing it’s currently on ‘page break preview’?)
that’s what I thought but messing with the print area bit doesn’t fix it. it’s on half of my worksheets too, not all of them
nope that doesn’t fix it either. it’s on normal
Fill in the gaps with a pencil.
Do they print out?
didn’t show on print preview. shut it down and reopened and they’ve gone.
It’s using a work template which is filled with macros, so wonder if something ran and it triggered something. you can print elements off by clicking macro buttons so maybe there is some functionality to set print areas or something. weird
thanks for the ideas guys!
File > Options > Advanced > Display Options for This Worksheet > Display Page Breaks
Yeah, they appear when you go into View and select normal, and then never disappear again unless you do the above or something much simpler because excel hates us
activesheet.DisplayPageBreaks = False