The dreaded one cell per page print problem - excel 2007

[new4me]

I have a worksheet that is 122 lines X 13 columns, size 12 fonts, although this has happened in the past with various size worksheets. Excel has arbitrarily divided the worksheet into 5 pages down & 2 columns wide equaling 10 pages altogether. I have tried to manipulate this into – say 2 or 3 pages down and most importantly – one page wide. I have done this with hundreds of larger worksheets, generally with no problem. However, when I try to adjust the pages in any way I get the dreaded one page per cell treatment in page break preview where each cell is assigned it’s own page, leaving me with thousands of print pages of one cell each. I reset the print area to one cell, and widen out; try to change the scaling to various percentages or ‘fit to X pages wide by X pages tall’, adjusted the margins, yet I am stuck in this endless loop of not being able to get out of one page per cell.

 

[glakshman]

Thanks a lot. I was struggling for past 30min.
This worked for me like wonder.

Lakshman

Quick and easy to fix - at least, I've found this to be very reliable.

Change your printer, then change it back.

From some speculation and some educated guesswork, what seems to be happening is that Excel is grabbing a copy of the printer driver to determine exactly what your file will look like when printed. Sometimes that printer driver gets corrupted, so we end up with things like the one-cell-per-page problem. To fix it, go to File > Print in 2003 and earlier or Office > Print > Prnt in 2007 to open the print dialogue. Change to a different printer (I suggest the Office document image writer, as it is part of MS Office), and preview the result. Then go back to the print dialogue and switch back to the original printer.

This seems to fix the problem 100% of the times I have had to try it.