Rather than copying the Form to 84 worksheets, copy the worksheet 84 times.

The original print setup will be retained for each copied sheet.


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 10:27:05 -0800, Michelle
wrote:

I'm creating a form worksheet that will be repeated 84 times. Is there a way
that I can copy this same form into each tab without having to do a page set
up for each worksheet? Each tab represents one filing cabinet number and the
form is for a Record Inventory. This form is just one page with merged cells,
column headings etc.

Thanks!