Excel Print Page Count Estimator

Enter rows, columns, paper, margins and scale to see how many sheets you are about to print.

Built for the moment a big spreadsheet is about to be printed and nobody knows how many sheets that is. Enter the rows and columns, the paper, margins and scale, and it counts the pages across and down. It also finds the scale that fits a target number of sheets. No file is uploaded.

The sheet

Drag a column border in Excel and it shows both a character count and a pixel value. Enter the pixel value for the best result. The default column is 8.43 characters, but Microsoft's documentation does not say how many pixels that is, so 64 here is this page's own default rather than a confirmed figure.

The value in Excel's row height box. The default of 15 is from Microsoft's documentation.

Paper and scale
Paper

Microsoft's documentation names the paper sizes but does not give their dimensions. The measurements here come from the paper standards themselves: ISO 216 for A4 and A3, the US standard for Letter and Legal.

Orientation

This matches the percentage box under Excel's page setup scaling. The commonly quoted range of 10 to 400 could not be confirmed in Microsoft's documentation, so this page does not enforce it.

Margins (inches)

Microsoft's documentation does not state Excel's default margins in inches. The defaults here are this page's own choice, so reading the real values from your file's page setup will give a closer answer.

How many sheets

6 sheets in total

2 across by 3 down

Each sheet holds 10 columns and 48 rows.

Printable area after margins: 6.87 by 10.19 inches.

Fit to a number of sheets

Pick how many sheets across you want and this finds the largest scale that fits.

Sheets across

At 51.5% it fits within 1 sheets across.

Excel has its own fit-to-pages feature, but its documentation does not say how Excel picks the scale. The figure here is found by counting, so it may differ from Excel's.

Figures not found in the documentation

The default margins, the pixel width of a default column, and the allowed scaling range could not be confirmed in Microsoft's documentation. All three are this page's own choices and each field says so. The 15-point row height and the 8.43-character column width are from the documentation.

Nothing you entered was sent anywhere. Everything was calculated on this screen.

This is an estimate

The real count changes with wrapped text, content in headers and footers, a defined print area, repeated title rows, merged cells, images and shapes, and manual page breaks. This page knows about none of those. Check Excel's print preview before you send it to the printer.

Sources

How Excel splits a sheet across printed pages

Made alongside

Other services by the same maker.