(2) Click the Browse button in the Date range box, and select the range that you will batch insert page breaks. (1) Click the Browse button in the Titles range box, and select the title row in the specified range that you will batch insert page breaks. ![]() In the opening Split to Columns dialog box, you need to: ![]() Click Split to Columns on the Kutools Plus tab.Ģ. Full feature free trialģ0-day, no credit card required! Free Trial Now!ġ. If you have Kutools for Excel installed, its Split to Columns utility can help you batch insert multiple page breaks after every x rows with keeping title in each page easily in Excel.ģ00 handy tools for Excel. Click OK, and then it will insert a page break in every X rows. Here I insert page break in every 3 rows. Click Run button and a dialog pops out for you to specify every X rows you want to insert a page break in. XLastrow = xWs.Range("A1").SpecialCells(xlCellTypeLastCell).Row XRow = Application.InputBox("Row", xTitleId, "", Type:=1) VBA: Insert page break in every X rows in a worksheet. In the window, click Insert > Module to show a new module window, then copy the following VBA code into the module window. Press Alt + F11 to display the Microsoft Visual Basic for Applications window.Ģ. ![]() ![]() Here I will insert a page break in every 3 rows.ġ. Maybe you are not familiar with VBA running before, but with the follow steps you may know how to run the VBA to insert a page break every X rows.
0 Comments
Leave a Reply. |