After that, go to the View tab in Excel and select the Page Break Preview icon in the Workbook Views group. Select the worksheet in which you need to insert page breaks.Ģ. The horizontal page break is inserted in the selected sales table. Next, go to the Page Layout menu and select Insert Page Break. We selected the A9 cell and applied the breaks in this example. These are the steps you need to follow:ġ. Select any cell in column A or right below the row where we want to insert the page break. In case you are unsatisfied with the way your data is laid out over multiple pages, you can manually insert page breaks where you need them. Inserting Page Breaks in Excel: Steps to Follow How to manually insert a page break in Excel?īefore you print anything on Excel, always check the Print Preview section. You can see all of your changes with the help of Excel Page Break Preview. In this post, we’ll discuss how to insert page breaks in Excel. If you want to print a table with an exact number of pages, this process is really helpful. In case you want something other than the default settings for your page breaks, you can do that too. In Excel, page break marks are automatically inserted based on paper size, margin and scale options. Verify that page break lines are displayed in grey color.Page breaks perform the task of dividing a worksheet into individual pages for printing purposes. Select ‘ InsertPageBreaksEveryXRows’ and click Run. Step 4: Click Developer->Macros to run Macro. And then quit Microsoft Visual Basic for Applications. Step 3: Save the codes, see screenshot below. XLastrow = xWs.Range('A1').SpecialCells(xlCellTypeLastCell).Row XRow = Application.InputBox('Enter Row Number', xTitleId, '', Type:=1) Step 2: In Microsoft Visual Basic for Applications window, click Insert->Module, enter below code in Module: Sub InsertPageBreaksEveryXRow() You can also press Alt + F11 keys simultaneously to open it. Or you can enter Microsoft Visual Basic for Applications window via Developer->Visual Basic. Select View Code, Microsoft Visual Basic for Applications window pops up. You can also see where page breaks will appear if you click Page Break Preview Button image on the Excel status bar. Go to the View tab in Excel and click on the Page Break Preview icon in the Workbook Views group. Step 1: On current visible worksheet, right click on sheet name tab to load Sheet management menu. Pick your Excel worksheet where you need to insert page breaks.

How to insert page breaks in excel