How To Remove Page Break In Excel

How To Remove Page Break In Excel

Read the article to know how to remove page break in excel.

Page breaks in Excel can definitely be frustrating especially if they fall at unwanted places. This can also lead to the breakout of pages non-intuitively during printout.

If you wish to not face this situation, it is best that you learn about how to remove the page break in Excel.

What is a Page Break in Excel?

A page break is a divider that marks areas where your worksheet will break into separate pages when printed.

There are two types of page breaks:

  • Page breaks that are automatically added by Excel (marked as dashed lines)
  • Page breaks that are manually added by the user (marked as solid lines)

The automatic page breaks are added based on different settings like scale, margin, and paper size to make sure that you get an optimal number of rows and columns per page.

Manual page breaks are added from the Page Layout->Breaks->Insert Page break menu.

How to Remove Page Break in Excel

Firstly ensure you are in the Page Break Preview, to remove the page break.

Page breaks can be both vertical and horizontal. Vertical page breaks cause column-wise separation, while horizontal page breaks cause row-wise separation. You can delete both these types of page breaks and choose the one you want to keep.

  • To remove a vertical page break, select the column to the right of the page break that you want to remove.
select the column to the right of the page break
  • To remove a horizontal page break, select the row that is just below the page break that you want to remove.
select the row below page break
  • Next, from the Page Layout tab, select Breaks. Select ‘Remove Page Break’ from this list.
Click on Remove Page breaks
  • Another way to remove a page break is by dragging it left, past the row headers or up, past the column headers, until it is outside the page break view area.
Drag the page break lines

Returning to Normal View from Page Break Preview

Once you are done with the page breaks preview, this is how you return back to the normal view.  Click on ‘Normal’ from the View tab (under the ‘Workbook Views’ group).

Click on Normal

Alternatively, click on the Normal icon from the Excel status bar:

Click normal icon in status bar

You might still see the page breaks (in grey color this time) once your switch back to the normal view. This is because the page breaks get turned on automatically. 

Dashed line that shows page breaks

To remove this, close and reopen your worksheet without saving.

Also Read
How to Make an Attendance Sheet In Excel
How To Multiply In Excel

If you still see the grey dotted lines, then follow the steps below to hide the page breaks:

  1. Select the File tab.
Click on File
  1. Click on Options
Click on Options
  1. Select the ‘Advanced’ category.
Click on Advanced
  1. Scroll down to the category ‘Display options for this worksheet’.
Scroll to ‘Display options for this worksheet’.
  1. Uncheck the box next to ‘Show Page Breaks’.
Uncheck show page breaks
  1. Click OK to close the Excel Options box.

All the grey dotted lines should now disappear from the Normal view of your worksheet.

Dotted lines are not shown
Lio

Maximize Your Online Business Potential for just ₹79/month on Lio. Annual plans start at just ₹799.

2 Comments

  • Please let me know if it is possible to remove the table format in Excel. If yes, pls let me know how to remove formatting from the table. I always tend to get confused and I am someone who always has to use excel worksheets as a part of my work

    • Hello Kajal,

      Yes, it is possible to remove the table format in Excel.
      You can choose any cell in the Excel table and then go to the Design tab. Click on the More icon in Table Styles and select the option Clear.

Leave a Reply

Your email address will not be published. Required fields are marked *