LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default How to know the correct height of the row

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

"Smitesh Tamboli" wrote in
message ...
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
FormatStyleModifyFont select Courier New, Reqular, 10.
FilePage SetupPaper 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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set a minimum row height a the same time with autofit row height Julie B New Users to Excel 2 May 5th 23 07:44 PM
Row Height stopped growing and Auot-Fit Row Height does not work PSULionRP Excel Discussion (Misc queries) 0 May 19th 09 07:59 PM
need to dbl row height without changing height of cell next to it Excel-Illiterate New Users to Excel 1 May 16th 06 01:08 AM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
resize row height and column height Tom Setting up and Configuration of Excel 3 April 3rd 05 02:03 PM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"