Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Delete Extra Pages in Excel (4 Methods)

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.

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

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.

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 the 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

Related Content: How to Delete Hidden Sheets in Excel (2 Effective Methods)


Similar Readings:


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.

Read More: How to Delete Excel Sheet Using VBA (10 Suitable Ways)


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.

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.

Read More: Shortcut to Delete Sheet in Excel (5 Quick Examples)


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.


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. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo