In Microsoft Excel, sometimes we have some unwanted extra pages or blank pages that we don’t want to print. Page splits determine what data text appears on each page of the printed document. Excel automatically selects them based on normal paper size and margin settings. In this article, we will demonstrate how to delete extra pages in excel.
Download Practice Workbook
You can download the workbook and practice with them.
4 Methods to Delete Extra Pages in Excel
While printing documents from excel, we can remove extra or blank pages in many ways. To delete extra pages in excel we are going to use the dataset below. The dataset contains some product items, the quantity of those items, and their prices. Suppose, we only want to print the dataset of the specific sheet without any blank or extra pages. Let’s go through the methods below to delete extra pages in excel.
1. Delete Extra Pages Using Print Area in Excel
We select Print Area, when we may not want to print the full worksheet, which is one or more ranges of cells. After specifying a print area on the spreadsheet, only the specified print area is printed. To delete extra pages using the Print Area, we need to follow some procedures. Let’s look at those steps below.
- Firstly, select the whole sheet from where you want to delete extra pages.
- Secondly, go to the Page Layout from the ribbon.
- After that, click on Set Print Area from the Print Area drop-down menu.
- Some dotted lines will appear and split the pages, from the dotted line dragging the cursor will delete the other pages shown in the picture below.
Related Content: [Fixed!] Delete Sheet Not Working in Excel (2 Solutions)
2. Use File Tab to Omit Extra Pages in Excel Workbook
The File tab consists of some basic vital options. Those options help us to customize the excel sheet. We can use the File tab to delete extra or blank pages in excel. To do this, let’s take a look at the steps below.
- In the first place, go to the File Tab on the ribbon.
- This will open the main alternative options.
- Now, select Print.
- Next, select the Print Selection from the drop-down menu in the print Settings category.
- And, that’s it! You can see a dotted line and this helps you to remove the extra pages while printing.
Related Content: How to Delete Hidden Sheets in Excel (2 Effective Methods)
- How to Delete a Worksheet with No Prompt Using Excel VBA (5 Methods)
- Excel VBA: Delete Files with Wildcards (4 Methods)
- How to Delete Multiple Sheets in Excel (4 Ways)
3. Page Break Preview to Delete Extra Excel Blank Pages
Page Break Preview is used to modify page breaks such as page layout and format changes affecting the appropriate page breaks. Let’s go through the steps to delete extra blank pages in excel.
- In the beginning, go to the View tab on the ribbon.
- After that, click on the Page Break Preview from the Workbook Views group.
- And, this will change the layout of the spreadsheet and remove all the other blank pages from the worksheet.
4. Extra Pages Deleting with Keyboard Shortcut in Excel
Using keyboard shortcuts is the most useful approach to enhancing productivity while operating in excel. To use keyboard shortcuts to delete extra or blank pages we need to follow the steps down. Let’s demonstrate those steps.
- Firstly, go to the sheet from which you wish to remove the extra pages.
- Secondly, press the keyboard shortcut Alt + P. This will view all the shortcut keys from the keyboard.
- And, now, to change the size of the sheet press SZ or to change the printed area R from Page Setup.
- Finally, after resizing, we can see that all extra pages are gone.
Permanently Change Print Settings to Delete Extra Pages in Excel
We can permanently change the print settings in excel to exclude extra pages. All you need to do is go to the Page Layout tab from the Ribbon. Then from the Page Setup section, you can set the page as per your preference.
The above methods will assist you to delete extra pages in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!