Shortcut to insert page break in Excel

Insert a page break in Excel to specify where a new page will begin in the printed copy.

To insert a horizontal page break, execute the following steps.

1. Select the first row of the new page.

2. On the Page Layout tab, in the Page Setup group, click Breaks.

3. Click Insert Page Break.

Excel displays a solid line (manual page break) to show you where the new page begins. Dashed lines are page breaks inserted automatically by Excel.

Note: in a similar way, you can select a column to insert a vertical page break.

4. On the File tab, click Print for a print preview.

Note: to remove a horizontal page break, select a cell below the page break that you want to remove and click Breaks, Remove Page Break. To remove all manual page breaks, click Breaks, Reset All Page Breaks. You cannot remove automatic page breaks.

If you work with large Excel spreadsheets, you know how frustrating it can be to scroll back and forth between different parts of the sheet. Page breaks can help alleviate this issue by allowing you to break up your sheet into smaller, more manageable pieces.

While you can insert page breaks manually, there is a much faster way to do it using a keyboard shortcut. In this article, we'll show you how to quickly insert page breaks in Excel using a keyboard shortcut.

How to Insert a Page Break in Excel

There are two ways to insert a page break in Excel: manually or using a keyboard shortcut.

To insert a page break manually, click the Insert tab on the ribbon and then click the Page Break button in the Breaks group. This will insert a page break above the active cell.

If you want to insert a page break below the active cell, you can select the cell below where you want the page break and then click the Page Break button.

You can also insert a page break by right-clicking on the cell where you want the page break and then selecting Insert Page Break from the context menu.

To insert a page break using a keyboard shortcut, simply press Ctrl+Shift+Enter. This will insert a page break above the active cell.

If you want to insert a page break below the active cell, you can press Ctrl+Shift+Enter and then press the down arrow key. This will move the page break below the active cell.

How to Remove a Page Break in Excel

If you want to remove a page break, you can click on the break line and then press the Delete key. You can also right-click on the break line and select Delete Page Break from the context menu.

If you want to remove all page breaks from your sheet, you can click the Page Layout tab on the ribbon and then click the Breaks button in the Page Setup group. This will open the Page Break dialog box. From here, you can click the Remove All button to remove all page breaks from the sheet.

How to Use the Page Break Preview Feature in Excel

The Page Break Preview feature in Excel allows you to see how your sheet will look when it is printed. This can be helpful if you want to make sure that your page breaks are in the right place.

To access the Page Break Preview feature, click the View tab on the ribbon and then click the Page Break Preview button in the Workbook Views group. This will open your sheet in Page Break Preview mode.

In this mode, you'll see blue lines that represent the page breaks in your sheet. You can drag these lines to move the page breaks. You can also double-click on a blue line to insert a new page break.

To exit the Page Break Preview mode, click the Normal button in the Workbook Views group.

The Bottom Line

Page breaks are a helpful way to break up large Excel spreadsheets into smaller, more manageable pieces. You can insert page breaks manually or use a keyboard shortcut. You can also use the Page Break Preview feature to see how your sheet will look when it is printed.

Want to learn how to insert and remove page breaks in Excel? If you want to print your excel sheet, it divides into pages automatically if your data is large. This is done by Excel, by inserting page breaks in between the sheets.

However, the page breaks that Excel inserts by default are based on scale options like margins and paper size. It would be much more convenient if the user decides where to put these page breaks or remove them if needed.

Suppose, you are making a list of revenues collected by 60 workers in four months. And you want to print the sheet. Excel will divide the content into pages depending on the page scaling. Now, you want to print exactly 15 individuals on one page and then next and so on. This can be done by placing the page breaks manually.

Preview the Page Breaks in Excel

By default, the Page break initiated by Excel is shown as a dotted grey line on the sheet. However, you can highlight the page break line by changing the view.

• Go to the ‘View’ tab in the header menu.
• You will find the ‘Workbook views‘ section on the top right corner of the screen.
• Click on the Page Break preview.

Now you can see the contents that are printed on the first page, second page and so on.

Inserting Page Breaks in Excel

Suppose, you have made a list of 20 workers in a factory and their revenues collected in five months for each worker (an excel sheet is displayed below for your reference) and you wish to print this sheet.

Now, all the entries will be printed on the same page because the data is not large enough. But you want to print exactly 10 individuals on the first page, this can be done by inserting a horizontal page break.

Note: The page break works with top and left preference. So, if you are inserting a page break at row 18, then the break-line will appear between rows 17 and 18. The contents from row 18 will be printed on another page. In the case of columns, suppose you select column E, then content till column D will be printed on a separate page, and so on.

1. Horizontal page break

To print the 10 individuals on a page, we have to insert a horizontal page break between rows 13 and 14 since we have 2 rows on the top with the header and a blank one. See the steps below to add page breaks in Excel:

1. Select row to insert page break by clicking on the row number.[we have selected 14 as per our example]
2. Click on the ‘Page Layout‘ tab.
3. In the Page Setup group click on the ‘Breaks’ option.
4. Now confirm by selecting ‘Insert Page Break’.

On doing this a page break will be inserted between rows 13 and 14 in our sample sheet, as shown above.

2. Vertical Page Breaks in Excel

Similar steps are done to insert a page break between columns. Suppose you have to insert a page break between columns D and E. See the steps below:

1. Select column E by clicking on the column number.
2. Click on the Page Layout tab.
3. In the Page Setup group click on the Breaks option.
4. Now click on the Insert Page Break.

On doing this a page break will be inserted between the column D and E.

Note: You can also insert a page break using a keyboard shortcut. The shortcut to insert page break is Alt + P + B + I

Removing Page Break in Excel

A similar algorithm is used to remove the page break(horizontal/vertical). Suppose we have to remove the horizontal page break we placed between the 13th and 14th. To remove page break a step-by-step tutorial is given below:

1. Select the row of page break by clicking on the row number.[selecting 14, as per our example]
2. Click on the ‘Page Layout‘ tab.
3. In the ‘Page Setup‘ group click on the ‘Breaks’ option.
4. Now select the ‘Remove Page Break’ option to remove the page break.

Similarly, we can omit a Vertical Page Break by selecting the column next to the break line and repeating the above steps.

You can remove one page break at a time using the above method or all at once by resetting the page breaks in the ‘Page Setup’ group. But you can not omit multiple page breaks simultaneously.

Note: You can remove a page break using a keyboard shortcut. The shortcut to insert page break is Alt + P + B + R.

Moving Page Breaks in Excel

You can slide the page break line manually to your desired place. Follow the steps below:

1. Go to the ‘Page Break Preview‘. The steps for doing it are discussed above.
2. Move your cursor to the thick blue break lines. Your cursor will transform into a double-headed arrow.
3. Press the Left key of the mouse and drag the break line to your desired place.
4. A new page break will be inserted into your spot removing the older one.

Hide or Show the Page Break line in Excel

You can hide the page break line if you want. Go with the steps below:

• Go to the ‘File’ tab and click on it.
• Click on the ‘Options’.
• You will be redirected to the ‘Excel Options’. Click on ‘Advanced’.
• Now scroll down to the Display options for the worksheets.
• Uncheck the ‘Show page breaks’.

Doing this will hide the grey page break lines. Though the break lines in the page break preview will still be visible. Moreover, the page break lines are hidden for this workbook only. You have to repeat the steps again for another workbook if you are willing to hide the break lines there.

Conclusion

Hope you have learned well how to insert or remove page breaks in Excel. For more tutorials on Excel, check out quickexcel.com.