To Insert or Remove a Page Break in Excel

Microsoft Excel has the option of Inserting & Removing page breaks. In the “Page Layout” tab onthe ribbon and in the “Page Setup” group the“Break” option is available in Excel.

Insert Page Break: - This option is used to print the worksheets of a workbook on separate pages.

The shortcut key to Insert Page break: - ALT < P < B < I

Remove Page Break: - This option is used to remove the inserted Page Break.

The shortcut key to Remove Page break: - ALT < P < B < R

Let’s understand how to insert page break in Excel.

I have a data in the range A2:E56, in which column A contains “Region”, column B “City”, column C “Product”, column D “Total Revenue”, and column E “Net Revenue”.

To insert section break or page Break, follow the below mentioned steps:-

Select the Cell A2;go to the “Page Layout” tab in the ribbon.
In the “Page Setup” group select “Insert Page Break” from the “Breaks” drop down menu.

Let’s understand how to remove page break in Excel.

To remove section break or page break, follow the below mentioned steps:-

Select the Cell A2, go to the “Page Layout” tab in the ribbon.
In the “Page Setup” group, select “Remove Page Break” from the “Breaks” drop down menu.

Dave
August 27, 2014 at 3:53 am

How do you do this in Excel 2013. So far the only way I have found to remove them when Print Preview presents is to go through File, Options, Advanced and scroll clear down until I find Show Page Breaks and uncheck the box. I find this tedious and annoying. Surely there is a better way.

The Page Layout menu on the ribbon offers this option, but it does nothing. BTW I am using the Home/Student version. Could that be the problem?

Reply ↓