How to Delete Unwanted Pages in Excel

Page breaks are the boundaries in a worksheet that decide what content goes on your printed document page. Excel chooses these for you automatically, using your default paper size and margin settings. You can also adjust the automatic page breaks by scaling your print job smaller (less than 100 percent) or larger (more than 100 percent) than your working document. Insert, delete, or move page breaks in Excel to make sure pages print as expected.

How to Set Your Print Area in Excel

Creating page breaks is a great way to manage larger documents, but what if you want to print a snapshot of the content and not the whole worksheet? You can use printer options to print a selected area by following these steps. For one-time printing:

Change Print Settings Permanently

If you’ll print the selected area more than once and want to set a print area for the document permanently, you can do it this way.