XLplus Add-On: Page Breaks
You can add or delete Page Breaks using the Context Menu. Select whether to add or remove Page Breaks. The option depends on the cell selected. In case the cell contains Page Breaks, you can delete the existing ones. In case it does not contain Page Breaks, you can add Page Breaks. Alternatively you can choose whether to show or hide Page Breaks. This will not remove them, but only hide them. In case you choose to show Page Breaks, this will show automaticaly and manually created page Breaks. The deletion of a Page Break affects manual Breaks only.
You can additionally remove Page Breaks when using XLplus Add-On: Remove Print Settings. This Add-On supports you to easily remove Print Settings of the active Worksheet, all Sheets of the Active Workbook or selected Sheets of a selected Workbook.
Display Page Breaks
When using the Context Menu, you can explicitly select whether to show Page Breaks or whether to hide them. When using XLplus Add-On: Remove Print Settings, Page Breaks will always be hidden.