Excel Print Area

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

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.

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.

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. :

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

Print Area

Re: Print Area

Re: Print Area (Scott)

Re: Print Area (Scott)