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

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,8

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

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"

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

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

15 points * 1/72 = 0.2083"

49 rows * 0.2083" = 10.2083333"