In Excel, how do I get what I type onto page 1 to repeat onto page 2, page 3, page 4, etc.?

You type the information into a cell on the first sheet then link the cells in the other sheets to that cell. So if the info is in cell A1 on the first sheet type (=Sheet1!A1).

@jca, if I’m understanding your question, and I might not be, there is no need to create “blank” space for subsequent pages. I believe you want to create a Header and/or a Footer (Insert Header) so that when you automatically break the page with your successive rows, that header and footer would be repeated.

I have to say that I’m not sure you should be using Excel for this—it almost sounds like you’re wanting a blank grid for folks to write it, etc., and Word might be the better choice for it. Even if you’re entering info into the grid to perform payroll calculations, the Table function within Word can perform math functions.

Or, maybe you want to create an idential grid on each page, in which case you can create the speadsheet, formatting and using column/row headers as you wish, and then use the copy tab function located on the Tab at the bottom of the spreadsheet to create identical copies. You can then modify each copy as you wish.

And I apologize if I’m way off base here.

There are several ways to get to where you want to be here are a few simple ones:

1. Hold the Ctrl key as you click several Worksheet tabs. You’ll see the Worksheet tabs in the color / highlight scheme that shows that they are each “active”. Whatever you type on one sheet will be in all sheets (at the current cursor location – so that can be confusing until you’ve tried it a few times to see how it’ll work).

2. Type only what you want on the first sheet, and then Ctrl-A (select all), Ctrl-C (copy to clipboard), move to the next sheet and Ctrl-V (paste). That’s pretty simple.

3. You can do more or less the same thing with formulas. On Sheet2 at A1, you can enter ”=Sheet1!A1” (without the quotation marks) and copy / paste that formula as required around the sheet. (Since it’s a “relative” formula, if you copy the formula to cell “X10”, for example, then the result will be ”=Sheet1!X10”.)

4. Best would be to make a Template file. Make up only one worksheet exactly the way you want it to look. Then delete ALL OTHER WORKSHEETS in that workbook. Save the file as follows:
Save File As
select “Template” from the “File type” window
Give the file an easy to remember / descriptive name such as “Timesheet”

To use the file you have created, go to File / New / User Templates / “Timesheet”. Any file created from the template will be an exact copy of the original template, without overwriting the original.