Hi,Tom-Con
Welcome to Microsoft Community!
I understand your desire to eliminate the tedious step of just removing the display of page breaks! By default, Excel doesn't provide a direct option in the user interface to set this option for an entire workbook or for all new workbooks, but there are several ways you can manage this setting more efficiently:
1.VBA Macro to Disable Show Page Breaks for All Sheets in a Workbook
You can use a VBA macro to automatically disable the "Show Page Breaks" option for all worksheets in a workbook. Here’s a simple macro that will do this:
Sub DisableShowPageBreaks()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.DisplayPageBreaks = False
Next ws
End Sub
You can run this macro every time you open a workbook where you want to disable the page breaks for all sheets.
2. Setting it as Default for All New Workbooks
To make this setting default for all new workbooks, you would typically need to alter the default workbook template:
Open a new workbook.
Run the VBA macro provided above or manually disable "Show Page Breaks" for each sheet.
Save this workbook as a template:
This new template will then be used every time you create a new workbook, applying the settings you’ve configured, including having "Show Page Breaks" disabled.
Looking forward to your follow up reply!
Best Regards,
Mila-MSFT| Microsoft Community Support Specialist