HomeFixesHow to Fix Microsoft Excel Prints Blank Pages

How to Fix Microsoft Excel Prints Blank Pages

Author

Date

You created a spreadsheet with only two pages. But, when you start to print the document, you unexpectedly end up with blank pages at the end. So, why is Microsoft Excel printing blank or white pages?

There are different reasons for the printed blank pages you see on your MS Excel document. You may have overlooked the formatting on your spreadsheet document, or you end up printing the entire worksheet file, including the extra blank sheet pages at the end. If you do not like seeing the blank pages getting printed, you can do the following methods below.

How-to-Fix-Microsoft-Excel-Prints-Blank-Pages-from-a-Spreadsheet-Document
Photo credit: rawpixel/Freepik

How to Stop & Avoid Printing Blank or White Pages in Microsoft Excel

Unexpectedly, printing blank pages on Microsoft Excel happens to a lot of users. To stop and avoid such a scenario and fix the printing issue, follow the troubleshooting solutions and workarounds below.

Method #1 – Print your Excel Spreadsheet by Page

Instead of printing the entire Excel spreadsheet in one go, you can print each page one at a time.

  • On your Excel document, click the File tab.
  • Go to Print.
  • Navigate to Settings.
  • In the Pages section, enter the page you want to print. You can also select to print the current page only.
  • Click the Print button.
  • After printing one page, do the same with the rest of the pages.

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

If you only have a few items on your MS Excel document to print, you can fit everything on one page, so you will not see any blank cells or pages.

  • Go to the menu section and select the Page Layout tab.
  • Click the small launcher at the bottom of the Page Layout section to open the dialog box.
  • Navigate to the Page tab.
  • Go to Scaling and select the Fit To option.
  • Set the height and width of the page to fit all the entries.
  • Once done, click OK.
  • You will then see what the document will look like once printed. If everything looks good, you can print it.

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

  • Click the File tab.
  • Go to Options.
  • Navigate to the Advanced tab.
  • Look for the Display Options for this Worksheet.
  • Click the box next to the Show a Zero in Cells that Have Zero Value.

Method #4 – Print your Excel Worksheet to High Quality

  • Head over to the Page Layout tab and click the small launcher.
  • On the Page Layout window, navigate to the Sheet tab.
  • Scroll down to the Print section.
  • Uncheck the boxes next to Black and White and Draft Quality.
  • Now, go over to the Page tab.
  • Look for the Print Quality option and click the drop-down arrow.
  • Select High.
  • Click OK.

Method #5 – Unhide Hidden Cells in MS Excel

First, you need to show the location of the hidden cells in your MS Excel worksheet.

  • Navigate to the Home tab in the Menu section.
  • Head over to the Editing section.
  • Click Find & Select.
  • Select Go To Special.
  • Choose Visible Cells Only.
  • Click the OK button.
  • Now, you will see the selected visible cells in your spreadsheet. Unselected cells are the hidden cells you need to unhide. Right-click on the cell, row, or column, and select Unhide.

Which solutions above helped you avoid and stop the blank pages printing issue on your Microsoft Excel spreadsheet? You can tell us in the comment section below.

Related

More From

How to Create New Calendar Events from the Taskbar in Windows 10

Organizing your events is convenient thanks to the Mail and Calendar apps on Windows 10. These programs are pre-installed with your OS and helps...

How to Fix Not Getting Ultra HD 4K Titles or Videos Not Showing on Netflix

Netflix offers Ultra HD (UHD) 4K titles for your viewing pleasure. With the 4K content, you can watch movies or shows with the highest...

How to Fix Authentication Error on Nook e-Reader Device

A lot of people who love reading are finding a huge advantage when using e-readers. With a single and compact mobile device, users can...

How to Fix Screen Time Limits Feature on Microsoft Family Safety Not Working

Microsoft Family allows parents to manage the screen time of their kids through the Microsoft Family Safety feature. The parental control tool enables them...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected

Trending