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