Insert Page Break Every X Rows in the Worksheet in Excel Office 365!!
Tags: insertpagebreakevery, kutoolsexceltutorial, kutools
Published: 2020-09-25 03:44:21

---
title: Insert Page Break Every X Rows in the Worksheet in Excel Office 365!!
published: true
date: 2020-09-24 11:48:49 UTC
tags: InsertPageBreakEvery,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/insert-page-break-every-x-rows-in-the-worksheet-in-excel-office-365/
---

## Insert Page Break Every X Rows in the Worksheet:

In this tutorial, we will guide you to learn the steps to **Insert Page Break Every X Rows in the Worksheet in Excel Office 365** using **Kutools. Get an official version of MS Excel from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## **Steps to Insert Page Break Every X Rows in the Worksheet:**

To insert page break every x rows in the worksheet, follow the below instructions.

- First, you have to activate the worksheet where you want to insert the page breaks.
- Go to the **Kutools Plus Tab, select** the **Printing** option, **choose** the **Insert Page Break Every Row** option from the menu.

![Choose Page Break Every Row option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Page-Break-Every-Row-option.png)<figcaption id="caption-attachment-14585">Choose Page Break Every Row option</figcaption>

- It will open the  **Insert Page Break Every Row dialog box, ** you need to **specify the intervals** of rows that you need to insert into the worksheet.
- Then, **click** the **OK** button.

![Insert Page Break Every Row dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Insert-Page-Break-Every-Row-dialog-box.png)<figcaption id="caption-attachment-14586">Insert Page Break Every Row dialog box</figcaption>

- Now, a prompt box will pop out to tell you how many page breaks have been inserted into the worksheet.
- **Click** the **OK** button to close this dialog box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Click-the-OK-button.png)<figcaption id="caption-attachment-14587">Click the OK button</figcaption>

- Now, you can see that the page breaks have been inserted into the worksheet in the specified intervals.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-5.png)<figcaption id="caption-attachment-14588">Result</figcaption>

## Reset All Page Breaks:

- You can remove all the page breaks of a worksheet using the **Reset All Page Breaks** option under the **Breaks** option in the **Page Layout** section.

![Choose Reset All Page Breaks option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Note.png)<figcaption id="caption-attachment-14593">Choose Reset All Page Breaks option</figcaption>

## **Verdict:**

In this tutorial, we guided you to learn the steps to **Insert Page Break Every X Rows in the Worksheet in Excel Office 365** using **Kutools.** Give your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!