MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Print Area


Posted by Hey Mikey on January 07, 2002 12:01 PM

Never had this problem before, and it's with this one workbook only.
I set the Print area, then View it. Page one only
shows printing 5 lines, page 2 shows printing about 15
lines, pg 3 shows 2, and 12 on the last.

How do I correct the problem so the first page fills up with the proper number of printable lines, the second the same etc?

Baffled.

Mike


Posted by Scott on January 07, 2002 12:08 PM

Sounds like you may have Page Breaks set. When doing Print Preview, go to Setup, and select the Page Tab. Then select the Page tab. Then you can select Fit to and put "1" in the Wide box, and then delete out anything in the Tall box, and then click OK. This should fix your problem.

Posted by Hey Mikey on January 07, 2002 12:17 PM

Normally I set the AdjustTo to whatever looks good for the printout and the lines that don't fit scroll off to the next page. The scrolling is no longer working for some strange reason.

Hope that's a bit clearer.

Posted by Scott on January 07, 2002 1:09 PM

Mike, it still sounds like you have page breaks. By adjusting the "Adjust to", your are not clearing your page breaks. If you adjust your "Fit to", this will change your page breaks. By leaving the "tall" box blank, it will adjust your page breaks accordingly.

If it's not this, than I'm stumped (which isn't hard to do). Good luck. : Sounds like you may have Page Breaks set. When doing Print Preview, go to Setup, and select the Page Tab. Then select the Page tab. Then you can select Fit to and put "1" in the Wide box, and then delete out anything in the Tall box, and then click OK. This should fix your problem. :