Page Setup Across Multiple Worksheets
 

I have designed the page setup requirements for one worksheet (print area,
rows to repeat at top, columns to repeat, etc.). These are not the normal
default settings. I want to copy these setting to other worksheets in the
same workbook. I have tried the following:

1. Activate the sheet that contains the desired setup info. This is the
"source" sheet.

2. Select the "target" sheets. Press Ctrl and click the sheet tabs of the
sheets you want to update with the settings from the source sheet.

3. Select File, Page Setup and click OK.

This doesn't seem to work. Any thoughts?