Remove Page Breaks

[gheyman]

When I was trying to adjust the view size (zoom) in the bottom right corner. I accidently clicked the "Page Break Preview" icon. Now I have the page breaks showing on my tab - which I dont want. How do I undo this? I tried Page Layout / breaks / Remove Page Breaks but nothing happens. The page breaks are still there.

Thank you

 

[rollis13]

From menu View / click Normal in section Workbook Views.

 

[HaHoBe]

Hi gheyman,

if you mean the dotted lines on the sheets I usually use a macro like

Sub s1()
  Dim wsTab As Worksheet

  For Each wsTab In ActiveWorkbook.Worksheets
    wsTab.ResetAllPageBreaks
  Next wsTab

End Sub

Ciao,
Holger

 

[gheyman]

Interesting, neither worked. ugh!

 

[rollis13]

Have you tried rebooting your PC ?
Elsewise, please attach a screenshot.

 

[HaHoBe]

Hi gheyman,

maybe Insert, move, or delete page breaks in a worksheet helps.

Ciao,
Holger