How to Delete Extra Pages in Excel (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Delete Extra Pages in Excel: 4 Methods

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.

4 Methods 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.

STEPS:

  • 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.

Delete Extra Pages Using Print Area in Excel

  • 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.

Delete Extra Pages Using Print Area in Excel


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.

STEPS:

  • In the first place, go to the File tab on the ribbon.

Use File Tab to Omit Extra Pages in Excel Workbook

  • This will open the main alternative options.
  • Now, select Print.
  • Next, select Print Selection from the drop-down menu in the Print Settings category.

Use File Tab to Omit Extra Pages in Excel Workbook

  • And, that’s it! You can see a dotted line and this helps you to remove the extra pages while printing.

Use File Tab to Omit Extra Pages in Excel Workbook


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.

STEPS:

  • 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. Deleting Extra Pages with Keyboard Shortcut

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.

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.


Download Practice Workbook

You can download the workbook and practice with them.


Conclusion

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.


Related Articles


<< Go Back to Print Area | Page Setup | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo