# 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
IrogSinta

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"
berei

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
IrogSinta

membership
Create an account to see this answer
Signing up is free. No credit card required.