How to Hide Page Breaks Across Every Worksheet in WPS Office Spreadsheets with VBA
Question details
The user needs to hide dashed page-break lines on all worksheets in an Excel-compatible workbook at once instead of clearing them one sheet at a time.
- Product
- WPS Office Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- After using Print Preview or other print-related actions, Excel 2016 displays page breaks on multiple worksheets in a workbook.
- Observed behavior
- The normal Hide Page Breaks option must be applied separately to each sheet and may need to be repeated after print-related actions.
Open the target workbook in WPS Office Spreadsheets and press Alt+F11 to confirm that the VBA editor opens before you run the macro.
Run a VBA Macro to Set DisplayPageBreaks to False on All Worksheets
This is the fastest method when the same dashed page-break lines appear on multiple sheets, because it applies the change to every worksheet in the active workbook at once.
The macro uses the ActiveWorkbook.Worksheets collection and sets each worksheet's DisplayPageBreaks property to False. It does not delete manual page breaks or change the print layout.
In WPS Office Spreadsheets, open the workbook that contains the visible page breaks and press Alt+F11 to open the VBA editor.
In the Project Explorer, right-click the workbook project, choose Insert, and then click Module.
Copy the following macro and paste it into the module window: Sub StopShowingPageBreaks() Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets sh.DisplayPageBreaks = False Next sh End Sub
Click anywhere inside the Sub StopShowingPageBreaks() code, then press F5 or go to Run > Run Sub/UserForm.
Return to the workbook and check each worksheet. The dashed page-break lines should no longer be visible in Normal view.
Hide Page Breaks in Every Worksheet with WPS Office Spreadsheets
Use WPS Office Spreadsheets and its VBA support to run a workbook-level macro that turns off the on-screen page-break display for all worksheets at once. The same macro works in Excel-compatible files, so you can manage page-break clutter without switching tools.
- 1. Download and install WPS Office: Go to the official WPS Office download page and install WPS Office on your computer.
- 2. Open your Excel workbook: Launch WPS Office Spreadsheets and open the .xlsx or .xlsm file that displays page breaks.
- 3. Open the VBA editor: Press Alt+F11 to open the VBA editor and insert a new module.
- 4. Paste and run the macro: Paste the StopShowingPageBreaks macro, then press F5 to hide page breaks across all worksheets.
- 5. Check worksheets: Return to Normal view and verify that page-break lines are hidden on every worksheet.
Frequently Asked Questions
Why do page breaks keep reappearing after I hide them?
Page breaks reappear whenever you open Print Preview, Page Layout view, or use other print-related actions for that sheet. The DisplayPageBreaks setting is sheet-level and print actions can turn it back on, so you may need to run the macro again.
Can I hide page breaks on all sheets without a macro?
The built-in Show page breaks option is normally applied per worksheet in Excel and WPS Office Spreadsheets. To update every sheet at once, use the VBA macro that loops through ActiveWorkbook.Worksheets and sets DisplayPageBreaks to False.
Does this VBA macro remove manual page breaks?
No. The macro only hides the automatic dashed page-break lines on screen. It does not delete manual page breaks or change how the workbook prints.
Will this macro work when I open the workbook in WPS Office Spreadsheets?
Yes. WPS Office Spreadsheets supports VBA macros, so you can press Alt+F11, paste the same code into a module, and run it from the VBA editor.
