How to Print X Rows Per Page in Excel?

In this article, the main objective is to guide the user through the process by using which printing X rows per page become easy for the user. This article describes two examples of how to perform the same task. The first example includes using the page break manually. The second example is based on the use of kutools. If will talk about the easiest guided example, is the second example that uses the kutools, as the number of steps performed to achieve the task is too less when compared with others.

Example 1: To print X rows per page by inserting the page break manually.

Step 1

To understand the process of printing X rows. Consider the given Excel spreadsheet data below. This sheet contains a total of 6 rows and 4 columns.

Step 2

In this example, will try to divide the available data by applying breaks at 2 columns. Click on the 3 rd row, header highlighted below.

Step 3

To apply the break, click on “Page Layout”, and then go to the “Breaks” tab. Further, select the option “Insert Page Break”. Consider the below depicted image for reference:

Step 4

The above step will display a long line that shows the required page break. Consider the image snapshot provided below:

Step 5

Now, go to the 5th row header, and Click on the row header specified below. After that open the “Page Layout” tab, and under the “Page Setup” pane, select the “Insert Page Break” option. Consider the below-highlighted image for proper reference:

Step 6

This step will display another page break at 4 th rows, refer below snapshot to understand the concept properly.

Step 7

Repeat the same with other rows, and after applying page breaks to all available data for 2 rows. Click on the “File” tab, and then choose the option “Print”, as depicted below:

Step 8

After clicking on Print, a print preview will be opened on the right-hand side. Since the provided worksheet contains data within 6 rows. And the applied page breaks are each in 2 rows. So, there is a total of 3 pages, here each page contains 2 rows on a single print sheet. Refer snapshot provided below for proper reference:

Example 2: To print X rows per page by inserting the page break by using the kutool.

Step 1

In this example also will be using the same worksheet, but this time user will learn the process of using the Kutools to perform the same task. Firstly, click on the “Kutools Plus” tab, and then click on the “Printing” tab, further select the option “Insert page break for every row, …”. Consider the below-depicted image for the proper reference.

Step 2

The above step will open a dialog box “Insert Page Break for Every Row, …”. This dialog box contains the label “Interval of:”. Here, will be using 2 as input. Please note that users can enter data according to their own requirements. Finally, click on the “OK” button.

Step 3

The image shows the page break applied to the available worksheet.

Conclusion

In this article, the user will understand the process of printing a specific number of rows per page in Excel. This can be done by enhancing the readability and presentation of user data. Printing X rows per page allows for a more organized and professional representation of user information, making it easier to analyze and share. Whether the user is creating reports, financial statements, or any other form of data output, this technique will help the user to present the Excel data in a clear and structured manner.