A gazillion pages in print preview

Jubinell

Board Regular
Joined
Jan 17, 2008
Messages
166
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!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,265
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

Board Regular
Joined
Jan 17, 2008
Messages
166
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

New Member
Joined
Nov 15, 2010
Messages
47
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,030
Messages
5,466,124
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top