How to know the correct height of the row

[Smitesh Tamboli]

I have the worksheet in which all the margines are set to 0 (i.e. left, top,
bottom,right,header,footer).
Then I apply the folloing settings
Format>Style>Modify>Font select Courier New, Reqular, 10.
File>Page Setup>Paper size : A4 and Print quality : 600 dpi.

Now my worksheet contain 73rows/page.
Each row has 13.50 points height. so page height is 73*13.50 = 985.5 points
But the standard A4 paper size height is 842 points.

So how the excel fits the 73 rows of each height 13.5 points?

 

[OssieMac]

In Page Setup on the Page tab you can set to 1 Page wide by 1 page tall or
you can adjust this to 1 page wide to 2 pages high etc.

If you set to 1 page wide and leave page high blank then it will be one page
wide by how ever many pages high is required.

 

[Peter T]

I can only print 60 rows at 13.5 points on A4, which seems about right
60 x 13.5 = 810
Depending on the printer, even with zero margins, the maximum print height
is usually a bit less than full A4.
Not sure how you can print 73 rows, what do you return with this (in the
Immediate window)
?Range("1:73").Height

Is your Zoom set at 100%, fit to page maybe

Regards,
Peter T