A gazillion pages in print preview

[Jubinell]

Hi,

I have a workbook with 5 sheets. These sheets generally span 1.5 pages wide and 3 pages long in automatic height & width (scale to fit = 100%).

Now, I just did something and the following phenomenon appears:
1) There is no problem with automatic height and length, scale to fit = 100%
2) As soon as I set height = some page(s), or width = some page(s), Excel divides my sheet into as many pages as there are cells. At the same time, the "scale to fit" percentage is automatically reduced to 10%.
3) I have tried to reset the print area but that just adds more cells into my print area (each of them still print in one page)
4) The only way to restore the print preview to a "normal" state is by setting the height and width values to "automatic" and scale-to-fit percentage to 100%. But of course, by doing so I cannot print my sheets in the number of pages I want.

Any advice is greatly appreciated!

 

[AlphaFrog]

What version of Excel do you have?
Do you have the latest updates?
Are you printing to a standard paper size or something unusual?
What printer do you have and do you have its' latest driver?

 

[Jubinell]

Thank you for your help AlphaFrog.

I am using Excel 2010.
My margins: top & bottom 2.5cm, left and right 2cm, header & foot 1.3cm. Center page Horizontally. Orientation portrait. Paper size A4.

This problem only occurs with this particular workbook. And it has only been occurring in the last few days.

I don't think this has anything to do with the printer. The thing is messed up in Print Preview even when I'm connected to a diff printer, or when I'm not connected to any printer, not when I print it out. I have tried printing out because it would take hundreds of pages. Furthermore, when I set width and height to automatic and scale-to-fit to 100% it looks OK in Print Preview so I assume it would also print out fine.

 

[snowjoke]

Have you tried adjusting the print area in Page Break Preview mode? (View menu)

That's the way to get it printing on what pages you want.