How to Remove Excel 2010 Page Breaks

In this tutorial you are going to learn how to remove excel page breaks.


Step # 1 – Identify the Page Break to Remove

Open the Excel document that contains the page break that you want to remove. Here we have a small address book with a break between rows 4 and 5 (indicated by a dotted line). This is the break that we want to remove.

The page break we want to remove

Step # 2 – Switching to Page Break Preview View

In the tab at the top of the window click the “View” option. In the “Workbook Views” section click on the “Page Break Preview” option. The view of the spreadsheet will change and the page breaks will appear as blue lines. We can now more clearly see where the page break we want to remove is.

Page break preview view

Step # 3 – Deleting the Page Break

Now click on the “Page Layout” tab as this is where we can remove page breaks, but first we need to select which break to remove. You can do this by selecting any cell directly below the break – in this case any cell in row 5. Now click on the “Breaks” icon and click “Remove Page Break” and the blue line will vanish and that is how to remove excel page breaks.

Selecting the page break to remove