Blog

How to Fix Microsoft Excel Prints Blank Pages? (August 2022) Easy Solution!

By Umair Qureshi

Posted on July 14, 2022

You made a calculation sheet with just two pages. Yet, when you begin to print the report, you suddenly end up with clear pages toward the end. All in all, for what reason is Microsoft Excel printing clear or white pages?

There are various explanations behind the printed clear pages you see on your MS Excel archive. You might have neglected the designing on your calculation sheet report, or you wind up printing the whole worksheet record, including the additional clear sheet pages toward the end. In the event that you could do without seeing the clear pages getting printed, you can do the accompanying techniques beneath.

The most easy method to Stop and Avoid Printing Blank or White Pages in Microsoft Excel

Startlingly, printing clear pages on Microsoft Excel happens to a great deal of clients. To pause and keep away from such a situation and fix the printing issue, follow the investigating arrangements and workarounds beneath.

Method #1 – Print your Excel Spreadsheet by Page

On your Excel archive, click the File tab.
Go to Print.
Explore to Settings.
In the Pages segment, enter the page you need to print. You can likewise choose to just print the ongoing page.
Click the Print button.
Subsequent to printing one page, do likewise with the other pages.

Method #2 – Fit your Microsoft Excel Document in One Page

In the event that you just have a couple of things on your MS Excel record to print, you can fit everything on one page, so you won’t see any clear cells or pages.

Go to the menu area and select the Page Layout tab.
Click the little launcher at the lower part of the Page Layout area to open the discourse box.
Explore to the Page tab.
Go to Scaling and select the Fit To choice.
Set the level and width of the page to fit every one of the sections.
Once finished, click OK.
You will then, at that point, see what the record will resemble once printed. In the case of everything looks great, you can print it.

Method #3 – Make Sure There is a Zero of every Zero Value Cells

Click the File tab.
Go to Options.
Explore to the Advanced tab.
Search for the Display Options for this Worksheet.
Click the crate close to the Show a Zero in Cells that Have Zero Value.

Method #4 – Print your Excel Worksheet to High Quality

Make a beeline for the Page Layout tab and snap the little launcher.
On the Page Layout window, explore to the Sheet tab.
Look down to the Print segment.
Uncheck the crates close to Black and White and Draft Quality.
Presently, head toward the Page tab.
Search for the Print Quality choice and snap the drop-down bolt.
Select High.
Click OK.

Method #5 – Unhide Hidden Cells in MS Excel

To start with, you really want to show the area of the secret cells in your MS Excel worksheet.

Explore to the Home tab in the Menu segment.
Go to the Editing segment.
Click Find and Select.
Select Go To Special.
Pick Visible Cells Only.
Click the OK button.
Presently, you will see the chose apparent cells in your bookkeeping sheet. Unselected cells are the secret cells you really want to unhide. Right-click on the cell, line, or section, and select Unhide.