How to stop printing blank pages

If you are getting blank pages when you are printing a worksheet, then there are a number of possibilities:

1. You have some ‘unnoticed’ text in one of the cells, e.g. ‘.’ or ‘,’.

2. You have cells that contain text, but the text color is the same as the cell background color.

3. You have a cell with a formula that returns a blank value.

4. You have empty cells that are formatted with borders or shading.

5. You have set a print area that spans into more than one page.

Possible Resolutions:

1. For unnoticed text, press CTRL+END to find the last non-blank character, and delete it if it is not required. Repeat the process if necessary.

2. For formulas, display formulas by pressing CTRL+’~’ then try to find the formula that returns a blank value.

3. Set the print area to the required cells only. Read more.

Comments

  1. Clive says:

    Yeah, looked at this and still have a problem then realised you sometimes have to save worksheet first before print preview.

  2. Jeff says:

    Here’s another possiblity i found:

    I had a graphic sitting on top of my header..and it was maybe 1 pixel over the print range on the right edge. This was resulting in a ‘blank’ page. Took me a 1/2 hour to find it lol

  3. Greg LeCheminant says:

    I have a problem. I upgraded from 2007 to 2010. When I prepare an excel worksheet and go to print it, the print preview page shows everything that I prepared, but when I print, it only prints blank pages. It doesn’t matter which printer I send it to, I get blank pages. So far the only way I have found to get it to print is to attach it to an e-mail and send it to myself. Then when it is downloaded from my e-mail and saved, it will print. I have tried all the steps that should be unnecessary, including saving it first, making sure that the print color is not the same as the background, setting the print area, etc. — I didn’t have this problem when I first set up Excel 2010. And I when I googled this problem, I found that there are others with exactly the same problem.

    Does anyone have a fix for this?