Can "Show page breaks" option be set to NO as default for all sheets?

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:

1. Open a new workbook.

2. Run the VBA macro provided above or manually disable "Show Page Breaks" for each sheet.

3. Save this workbook as a template:

   • Go to File > Save As.

   • Choose the file format Excel Template (*.xltx) and save it in the default location for Excel templates (usually C:\Users\[YourUserName]\AppData\Roaming\Microsoft\Templates).

   • Name it Book.xltx.

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