HOW DO I REPEAT CELLS ON EVERY PAGE

[Ian Kentzer]

[Bob Phillips]

File>Page setup>Sheet nd set Rows To repeat

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ian Kentzer" <Ian Kentzer@discussions.microsoft.com> wrote in message
news:D7CFEE8E-8780-4AAB-B0EF-DB1A066222B5@microsoft.com...
>

[kghexce]

If your question regards titles on pages printed previous answer is what you need.

If your question is about duplicating complete sheets with formulas, etc. the following is a non VBA way.

Create the first sheet with the formulas and formatting you wish
1) CTRL HOME to put cursor in top left
2) CTRL A to select all
3) CTRL C to copy
4) CTRL PAGE DOWN to select next sheet
5) CTRL V to paste everything in the next sheet.

If there are many sheets to populate, a macro will speed it up. Just record the relevant portions. Another macro which runs the first macro a fixed number of times also makes it easier.

One can adjust the number of sheets created on new file creation in the options menu. Set it to the number of worksheets you need and then just open a new file. Alternately one could INSERT WORKSHEET as part of the above.

You may want to turn recalculation off temporarily to speed things up.