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.

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

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 area will be in the print preview and the rest of the blank pages will not show.

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

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 areas.
  • 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 and remove the blank pages.

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: [Fixed!] Print Preview in Excel Doesn’t Match Document

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.

Download Practice Workbook

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


In this article, we described 4 methods to delete blank pages in print preview in Excel. I hope this will satisfy your needs. Please give your suggestions in the comment box.

Related Articles

<< Go Back to Print Preview in Excel | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

  1. Thank you so much. During my bad day, this is the only problem, i have solved with ur explanation.

    • Dear Anusha Uppuganti,

      You are most welcome. We are so glad that our article explanation helped you.


Leave a reply

Advanced Excel Exercises with Solutions PDF