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

How to Delete Blank Pages in Print Preview in Excel (4 Easy Ways)

When we work with Microsoft Excel, some blank, unnecessary pages are added unconsciously to the dataset. There are some techniques to delete those blank pages from the print preview in Excel. We will discuss those techniques here in detail.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Methods to Delete Blank Pages in Print Preview in Excel

1. Set Print Area from Page Layout Tab

We can use the Print Area feature to delete blank pages from the print preview in Excel.

📌 Steps:

  • First, need to select the area we want to print. We delete cells with data only and skip the blank pages.
  • Then, click on the Page Layout tab.
  • Now, choose the Print area and get two options.
  • Click on the Set Print Area option.

Print Area to Delete Blank Pages

  • Now, look at the dataset.

We can see a margin throughout our selected area. Only this are will be in the print preview and the rest of the blank pages will not show.

Read More: [Fixed!] Print Preview Not Available in Excel


2. Use Print Selection Option

In this section, we will use the Excel File tab. This will print only our selected area.

📌 Steps:

  • First, we select out required are.
  • Then, press the File tab.

  • Another window appears.
  • Click on the Print option.
  • Now, go to Settings. After that, press the down arrow, and some options will appear there.
  • Choose Print Selection. This will print only the current selection.

Delete Blank Pages Using File Tab in Excel

Now, look at the print preview. This will show only the sheet or page containing data only and removes the blank pages.

Read More: Excel VBA: Print Preview for Selected Range (5 Examples)


3. Use Page Break Preview Option

Page Break Preview is another option to delete blank pages in Excel.

📌 Steps:

  • Go to the View tab.
  • Now, click on the Page Break Preview option.

Delete blank Pages Using Page Break Preview

  • Now, look at the dataset.

We can see only the area covered with data is shown in the print preview. The main advantage of this method is that we do not need to select the area.

Read More: Excel VBA to Display Print Preview for Multiple Sheets


4. Use a Keyboard Shortcut

There is also a keyboard shortcut to delete blank pages in Excel.

📌 Steps:

  • Just go to the dataset.
  • Press the Alt+P.
  • We will see some shortcuts on the display.
  • Now, press R.

Keyboard Shortcut to delete blank pages in Excel

This will unveil the Print Area option, which will provide the option to delete blank pages as shown in Method 1.

Read More: [Fixed!] Print Preview in Excel Does Not Show All Pages


Conclusion

In this article, we described 4 methods to delete blank pages in print preview in excel. I hope this will satisfy your needs. Please have a look at our website ExcelDemy.com and give your suggestions in the comment box.


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo