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

Note: kutools for Excel 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.

• 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.

• 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.

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

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.

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. Keep Learning!!