Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set a minimum row height a the same time with autofit row height | New Users to Excel | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
need to dbl row height without changing height of cell next to it | New Users to Excel | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
resize row height and column height | Setting up and Configuration of Excel |