Excel help

How do I get rid of these dotted lines? Are they something to do with print areas?

Excel 2016

help please!!

Is it not just the page layout/set-up?

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?

1 Like

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

1 Like

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