![how to insert page breaks for each row in excel how to insert page breaks for each row in excel](https://img.techwallacdn.com/375/ppds/9703e97f-5cbc-4909-9cbe-aa03dd812ede.png)
For example, for 9 th row, select the A9 cell. Step 1: To insert the Horizontal page break to your Excel spreadsheet, select the first cell of a row where you want to add a page break. We will use the same Excel file that is used in the previous example. You may need to add more cells to your print area after you set it up. Horizontal page break inserts solid line just below to the selected row-cell. When you finish, click “Normal” or “Page Layout” to return to your sheet, depending on which view you were using. Open the View tab and select “Page Break Preview.” You’ll then see each print area you’ve set for that sheet. Once you set up your print area, you may want to confirm you’ve selected the right cells.
![how to insert page breaks for each row in excel how to insert page breaks for each row in excel](https://cdn.extendoffice.com/images/stories/doc-excel/insert-page-break-x-rows/doc-insert-page-break-x-rows-5.png)
This allows you to quickly print that same spot without resetting the print area.
![how to insert page breaks for each row in excel how to insert page breaks for each row in excel](https://www.excelatwork.co.nz/wp-content/uploads/2018/06/Excel-Print-Setup-4.png)
LstRw ActiveSheet.Cells(Rows.Count, 'A').End(xlUp).Row For Each Ce In Range('A2:A' & LstRw) If Len(Ce.Value) 0 Then Before:Ce End If Next End Sub.
#How to insert page breaks for each row in excel code
I was wondering if it would be possible to modify the code to place the page break AFTER each blank row. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. When it’s time to print, each print area will display on its own page.Īfter you set a print area in your Excel sheet, it will save automatically when you save your workbook. I revisited this code this morning for a different project. To set a single print area, select the cells. Next, head to the Page Layout tab and pick “Set Print Area” in the Print Area drop-down box.