How To Remove Page Breaks In Excel

To remove page breaks in Excel, go to the Page Layout tab, click on the Breaks button, and select Remove Page Breaks.

Excel is a powerful tool for data organization and analysis, but sometimes it can be frustrating when unwanted page breaks disrupt the flow of your spreadsheet. Whether it’s a single cell or an entire row that is causing the page break, knowing how to remove these interruptions is essential for creating a professional-looking document. In this blog post, we will guide you through the step-by-step process of removing page breaks in Excel, allowing you to regain control over the presentation and readability of your data. So let’s dive in and discover the techniques to effectively remove page breaks in Excel!

How To Remove Page Breaks In Excel: Step-by-Step


Step 1: Launch Excel,

To access Excel, locate and click on the application icon on your system. Once opened, choose the specific document in which you wish to eliminate page breaks.

Next Step

Step 2: Open the relevant worksheet,

To navigate through your Excel workbook, locate and select the specific worksheet that contains the page breaks you wish to remove. Simply click on the corresponding tab at the bottom of the screen.

Next Step

Step 3: Switch to Normal View,

In order to remove page breaks, switch to the ‘Normal’ view by clicking the ‘View’ tab, then selecting ‘Normal’ from the menu.

Next Step

Step 4: Select the ‘Breaks’ option,

Once the worksheet is open, navigate to the ‘Page Layout’ tab on the Ribbon. Locate the ‘Breaks’ option in the ‘Page Setup’ group to configure page layout settings.

Next Step

Step 5: Click ‘Remove Page Breaks’,

After clicking on ‘Breaks’, a dropdown menu will appear. Select ‘Remove Page Breaks’ to delete all manually-inserted page breaks. Automatically-inserted page breaks introduced by Excel’s printing layout will not be affected.

Next Step

Step 6: Save your changes,

After successfully removing the page breaks, save your changes by clicking on the ‘File’ tab, followed by selecting ‘Save’.


In conclusion, removing page breaks in Excel is a straightforward process that can greatly enhance the readability and presentation of your worksheets. By following the simple steps outlined in this guide, you can easily eliminate unwanted page breaks and ensure that your data flows seamlessly across pages. Whether you are creating reports, invoices, or any other document in Excel, knowing how to remove page breaks is an essential skill that will save you time and frustration. So go ahead and take control of your Excel worksheets by removing those pesky page breaks, and enjoy a more polished and professional-looking final product.

Table of Contents