I have to print a report, containing a few hundred rows of numerical data. I
want Excel to automatically print subtotals of each column at the bottom of
each printed page. I can do it manually, by counting the number of rows that
would fit on a page, and adding the subtotals at the correct position. But,
as soon as you add or delete rows in your ranges, you have to change all your
subtotals again.