Sorry, I have been prompted that I might have not answered the question, or answered the wrong question.
Instead of hard coding numbers, you can just put the first number in cell A1 and, in A2, put the formula
and drag down.
Now, here lies the problem: there is no way of knowing how many rows you will need to fill 8 (or 11) inches of paper. This will depend on the printer, if the printer can print without borders, what font and font size you have chosen.
So, you'll need ti decide what the parameters are and drag down as far as you think is necessary and do a Print Preview. If it's too short, continue dragging down. If it's too long, select the excess cells and drag them to the top of the next column. Continue dragging down. Once you know how long the page needs to be, just keep continuing copying and dragging the formula.
@Ford: better?
Bookmarks