Hover the cursor over the page break line that you want to adjust.This will change the worksheet view and you will be able to see all the page breaks as thick blue lines In the workbook views group, click on the Page Break Preview option.Once you have inserted the page breaks in the worksheet, you can make minor adjustments by dragging the horizontal or vertical page break lines.įor this to work, you need to be in the Page Break Preview mode.īelow are the steps that you can use to move the page break by dragging it: If you want to remove all the page breaks that you manually inserting and reset them to the default ones, there’s an option for that too.īelow are the steps to reset a page break in Excel:īe above steps would remove all the manually inserted page breaks and place the page breaks based on the page size, margin, and scale (as it does by default) Keyboard Shortcut to Remove the Page Break ALT + P + B + A Moving the Page Break Manually Keyboard Shortcut to Remove the Page Break ALT + P + B + R Reset All Page Breaks if you try and do that, Excel would only consider the last selected row and remove the page break above it. Note: you cannot remove multiple page breaks in one go by selecting multiple rows or columns. In case you have inserted multiple praise breaks that you want to remove, you’ll have to repeat this process one by one. The above steps would remove the page break above the selected row. Select the row above which you have the page break.In our example, suppose I want to remove the page break that I inserted after the data for the US region. Just like you can add a page break in Excel, you can also easily remove a page break. Note: You can also switch between the Normal view and Page Break Preview by clicking on the icons in the status bar. To go back to the regular worksheet view, click on the Normal option in the View tab. The above steps would change the view of your worksheet and you will be able to see how much content would be printed on each page.Įvery page break is showed as a thick blue line, and pages are numbered which makes it easy to understand what content would go on what printed page.
In the Workbook Views group, click on the Page Break Preview option.Once you have inserted the page breaks in Excel, you can quickly check what all would be printed on each page by going to the page break preview mode. Keyboard Shortcut to Insert Page Break ALT + P + B + I Check Page Break Insertion from the Page Break Preview Doing this would insert a horizontal page break right above the cell and a vertical page break just to the left of the cell. Note: If you want to insert both horizontal and vertical page breaks at a specific location, you can do that by selecting the cell and repeating the same process above to insert the page break. Note that you can insert as many page breaks as you want.įor example, if you want to print the data for each region on a different page, you can insert multiple horizontal page breaks by selecting the row right below where the data for that region ends and inserting a page break there. Simply select the column B for which you want the page break to be added and go to the ‘Page Layout’ tab and click on the ‘Insert Page Break’ option Just like the way I have inserted a horizontal page break in Excel, you can also insert a vertical page break. You may not be able to see this line if you already have the gridlines visible, but if you hide the gridlines you would be able to see this as shown below. The above steps would insert the page break right above the selected row.Įxcel also shows you the positions of the page breaks by adding a light gray dotted line between the two pages. Click on the ‘Insert Page Break’ option.In the ‘Page Setup’ group, click on the ‘Breaks’ option.Select the row above which you want to insert the page break.So to do this, I’ll have to manually insert a page break after the data for the US. If I go ahead and print the data as of now, everything would be printed on a single page because the data is not big enough to be split into multiple pages. In this data, I want to print all the records for the US on the first phase and then all the remaining records on the second page. Suppose I have a data set as shown below where I have the sales numbers for different people working for different regions. Manually Inserting Page Breaks in Excel (Horizontal/Vertical)
0 kommentar(er)
