Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to print X rows per page in Excel?

If you have a range of data with multiple rows in Excel, and now you want to print this range by 3 rows per page, how should you do? This tutorial just talks about the manual method and quick tricks to print fixed rows per page in Excel.

Print X rows per page by insert page break manually

Print X rows per page by running VBA

Print X rows per page by Kutools for Excel good idea3


Easily insert blank rows or columns in every other row in Excel

In some cases, you may want to insert blank rows or columns in every other or nth row/column as below screenshot shown. In Excel, you only can insert the rows/columns one by one manually, but with Insert Blank Rows & Columns of Kutools for Excel, you just need 3 steps, the blank rows or columns will be inserted in every nth row or columna as you need.  Click for 60 days free trial!
doc insert blank row
 
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.

arrow blue right bubble Print X rows per page by insert page break manually


To print fixed rows per page, what we need to do is to insert the page breaks every n rows.

For instance, here I want to print 3 rows per page, now I begin to insert page breaks by manual.

1. Select the 4th data, see screenshot:

doc print x row per page 1

2. Then click Page Layout > Breaks > Insert Page Break. See screenshot:

doc print x row per page 2

Now a page break is inserted under the 3rd row. See screenshot:

doc print x row per page 3

Now to repeat step 1 and step 2 to insert other page breaks.

Tip: If you want to insert page break every n row, select n+1 row, 2n+1 row, 3n+1 row…to insert page breaks.

doc print x row per page 4

3. Then you can go to File (Office button) > Print to print the data by 3 rows per page.

doc print x row per page 5


arrow blue right bubble Print X rows per page by running VBA

If you have hundreds of rows needed to insert page breaks, the above manual method is not a good choice. If you are interested in VBA, this tutorial can introduce a VBA code to quickly insert page breaks in every nth rows.

1. Press Alt + F11 to enable Microsoft Visual Basic for Applications window.

2. Click Insert > Module, then paste below VBA code into the new Module window.

VBA: Insert page breaks every nth row.

Sub formatSheets()

For i = 3 To 11 Step 3
    ActiveSheet.HPageBreaks.Add Before:=Cells(i + 1, 1)
Next
End Sub

3. Then press Run. And you can see page breaks are inserted in every 3rd row.

doc print x row per page 6

Tip: In the VBA code, 3 To 11 Step 3 means that to insert page breaks in every 3rd row from the 3rd row to 11th row, and you can change it based on your needs.


arrow blue right bubble Print X rows per page by Kutools for Excel

However, for most of Excel green hands, VBA code is also not an easy way to solve the problem that print x rows per page. Here if you like to try a new thing, you can try to use Kutools for Excel, a handy Excel tool which can make Excel more interesting and easier, its Insert Page Break Every Row utility can quickly insert page breaks in every nth row as you need.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Enable the worksheet you want to insert page breaks, and click Kutools Plus > Printing > Insert Page Break Every Row. See screenshot:

doc print x row per page 10

2. In the Insert Page Break Every Row dialog, type the interval number you want to insert page breaks, and click Ok. Then a dialog pops out to remind you how many breaks are inserted, just click OK to close it. See screenshot:

doc print x row per page 8


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    James · 1 years ago
    Is there a way to only print rows that you have entered data into? eg. I only want to print rows where I have entered data into column H?
    • To post as a guest, your comment is unpublished.
      Sunny · 10 months ago
      Select the column range you want to print, and click file > print, select print selection in settings section.