Copying Print Settings from one worksheet to another

I am trying to copy the print settings(including the headers and footers) for one excel worksheet to another. I have found the following hint on internet and it works fine for copying the print setting(including the head/foot) but it is also grouping the worksheets. Click on the tab of the worksheet you want to copy. Then hold down the Shift or Ctrl key and click on the tab of the worksheet where you want the settings and click on File, Page Setup and OK. How can I just copy the print setting without grouping the worksheets?

Any help would be greatly appreciated.

Follow the instructions, the select any single (unselected) sheet to ungroup. It's not a permanent thing.

Packman,

Welcome to the forum.

Please take a few minutes to read the forum rules, and then start your own thread.

Thanks