How to know the correct height of the row

  • Thread starter Thread starter Smitesh Tamboli
  • Start date Start date
S

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?
 
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.
 
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
 
Back
Top