What is Page break Preview in Excel?

In page break preview we can see the printing view of excel sheet.

To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it. Although you can work with page breaks in Normal view, we recommend that you use Page Break Preview view to adjust page breaks so that you can see how other changes that you make (such as page orientation and formatting changes) affect the automatic page breaks. For example, you can see how a change that you make to the row height and column width affects the placement of the automatic page breaks.

To adjust page breaks, you can insert your own page breaks, move existing page breaks, or delete any manually-inserted page breaks. You can also quickly reset all page breaks to automatic page breaks. After you finish working with page breaks, you can return to Normal view.

Page break preview option make your view a preview of where page will break during printing.

click the view tab and go to the workbook views group to view the page break preview button in excel2007.

Page break preview option show you where will page break down, and another page will start.

To print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page breaks. In this view, manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break pages automatically.

1. On the View menu, click Page Break Preview.
2. Do one of the following:

• To move a page break, drag the page break to a new location.

 NOTE   Moving an automatic page break changes it to a manual page break.

• To insert a vertical or horizontal page break, select a row or column below or to the right of where you want to insert the page break, right-click, and then click Insert Page Break.
• To remove a page break, drag the page break outside of the page break preview area.
• To remove all manual page breaks, right-click any cell on the worksheet, and then click Reset All Page Breaks.

To veiw the exact printing page from your excel sheet ...

print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page break.