Excel print page counts and scaling

1. How Excel splits a sheet

When printing, Excel cuts the sheet into paper-sized pieces. Columns that do not fit across move to the next sheet, and rows that do not fit down move to another. The total is therefore the count across multiplied by the count down.

That multiplication is where people get caught. One column too many makes it two sheets across, which doubles the whole job. Twenty sheets becoming forty usually has this cause.

2. The basic rules: four things set the count

First, the paper and its orientation. A4 portrait and landscape hold noticeably different numbers of columns, and turning the page often halves the count across on its own.

Second, the margins. Smaller margins leave more printable area and fit more cells. They cannot go to zero, though, since every printer has an edge it cannot reach.

Third, the scale. A lower scale shrinks the cells so more fit. Halving it roughly doubles both directions, which cuts the total to nearly a quarter.

Fourth, the size of the cells themselves. Microsoft's documentation gives a default column width of 8.43 characters and a default row height of 15 points, with maximums of 255 and 409.

3. The rules inside this page

This page counts how many scaled cells fit into the printable area after margins, then divides the totals and rounds up. Across and down are counted separately and multiplied, because Excel never breaks inside a column or a row.

Column width is entered in pixels. Excel's character unit depends on the font, so the documented number alone cannot be converted to inches. Drag a column border in Excel and it shows the pixel value; entering that gives the closest answer.

Three figures could not be confirmed in the documentation: the default margins, the pixel width of a default column, and the allowed scaling range. All three are this page's own choices and each field says so. The commonly quoted 10 to 400 range in particular is not enforced here, because it could not be confirmed.

The fit-to-sheets scale is not found by dividing areas. That formula ignores the space wasted at a column break: asked to fit twenty columns into three sheets across, it returned a scale that actually needed four. The page now searches by counting, and returns the largest scale that genuinely fits.

Nothing you enter is sent to a server. The work happens in your browser, and the server learns only three facts: that the page opened, that a count was produced, and that a link was copied. No file is read or uploaded.

4. Getting it right

The cheapest way to cut the count is turning the page landscape. Text stays the same size, and for a wide table the effect is the largest available.

Scale comes next. Push it too low and nobody can read the result; for anything you hand to someone else, below 70 percent gets difficult.

Narrowing columns works too. An empty or needlessly wide column creating a whole extra sheet across is a common find.

5. A little deeper

Excel has a fit-to-pages feature of its own. Its documentation does not explain how Excel picks the scale, so the figure here, found by counting, may differ from Excel's.

Setting only the sheets across and leaving the down count open usually works better. Forcing both into one sheet drives the scale far below readable.

Content in headers and footers eats into the body area. This page works from the four margins alone, so it cannot account for that.

6. Where people get stuck

If the count here differs from Excel's preview, check the margins first. The defaults on this page are its own choice rather than a confirmed figure, so reading the real values from your file's page setup helps a lot.

If text wraps inside cells, the row height is above 15 points. Enter the real height.

A 'cannot count' message means the margins exceed the paper, or a single cell is bigger than the paper. Check whether the scale is set very high.