Can I use the same footer for multiple worksheets in same workboo.
 

Is there a way to format multiple worksheets in a workbook to have the same
custom footer without having to setup each worksheet separately?

There's a couple of ways.

If you already have a sheet set-up with your footer, select that sheet.
Now, hold <Ctrl, and click in the tabs of all the other sheets that you
wish to have the same footer.
When they're all selected (Grouped - tabs are white), and the main sheet's
name is also "bold", meaning it's the sheet of focus, then:

<File <PageSetup <OK

And *all* the selected sheets will have the same footer.

The caveat here, is that *all* the sheets will *also* have all the rest of
the Page Setup "settings" as that of the main sheet.

The other option is to select all the sheets in the same way as before from
the very beginning, before other setup options are chosen.
Then, go into Page Setup, create your custom footer, and then "Ungroup" the
sheets before you create other individual Setup options for each sheet.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Bigkahuna" wrote in message
...
Is there a way to format multiple worksheets in a workbook to have the same
custom footer without having to setup each worksheet separately?

Thanks for your help on this.

"Bigkahuna" wrote:

Is there a way to format multiple worksheets in a workbook to have the same
custom footer without having to setup each worksheet separately?

Thanks for the feedback.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Bigkahuna" wrote in message
...
Thanks for your help on this.

"Bigkahuna" wrote:

Is there a way to format multiple worksheets in a workbook to have the
same
custom footer without having to setup each worksheet separately?