How to Remove Page Breaks in Excel

In this tutorial, you will learn how to remove page breaks in Excel workbook.

For printing purposes, page breaks divide a worksheet onto different pages. Based on the paper size, margin options, scale settings, and any manually inserted page breaks, Microsoft Excel automatically inserts page breaks. Before printing, you can change the page breaks in the spreadsheet to get the precise amount of pages you need.

Once ready, we’ll get started by utilizing real-world examples to show you how to remove page breaks in Excel workbook.

Remove Page Breaks

You can easily remove page breaks from your Excel workbook.

Step 1

First, you need a clean and tidy data group to start the tutorial.

Step 2

To view the pagebreak for your Excel worksheet, you can click on the ‘Page Break Preview’ icon which can be located at the bottom-right of your worksheet.

Step 3

Your worksheet will look like this. You can see, the worksheet is broken into 2 pages. To remove the page break, you can easily pull the dotted blue line to the end of the worksheet to create only 1 printing page.

Step 4

Once you are done, your page break will look like this.


That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

In this tutorial, I covered how to remove page breaks in Excel workbook.