Register now or log in to join your professional community.
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.
NOTE Moving an automatic page break changes it to a manual page break.
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.
