Link to home
Create AccountLog in
Avatar of berei
berei

asked on

How to calculate #rows on a page in Excel

Can any one explain to me how Excel calculate number of rows on a physical page?
I have set the pagesize to A4 (equals 29,7 cm or 11,69"), Top and button margin to 1,905cm (0,75") and all rows to  height 20 pixels. Excel show me 50 rows per page, but this do'nt match my simple calculation:

PageSize-(top+button)=25,89cm  or 10,19"
50 rows a 20 pixels = 1000pixels.
1000pixels=1000/96 inches=10,41666667" = 10,41666667*2,54cm = 26,45833333cm

According to my calculation there are only rooms for 49 rows.
What did I miss?

Brgds
berei
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

You should use points to do your calculation for the rows instead of pixels since pixels are dependent on the display device.  I believe 20 pixels is just an estimate for the default row height of 15 points.  Since a point is 1/72 of an inch,

15 points * 1/72 = 0.2083"
49 rows * 0.2083" = 10.2083333"
Avatar of berei
berei

ASKER

It still don't fit.
Excel show 50 rows, but 50 rows of height 15 point gives:
50 row * 0.2083 = 10.415" (same result as above), but there is only room for 10.19"
SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account