ExcelBanter - Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/241280-excel-2007-a.html)

Is it possible to copy Header and Footer data across all sheets in a
multi-page Workbook.
If not, why not?
--
J. W. McLachlan

You can. Right click the sheet tabSelect all sheets and then set header and
footer which will be applied for all sheets

If this post helps click Yes
---------------
Jacob Skaria

"Brachy" wrote:

Is it possible to copy Header and Footer data across all sheets in a
multi-page Workbook.
If not, why not?
--
J. W. McLachlan

Be careful with this.

It will also change most print settings on all sheets to that of the
activesheet.

Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 03:31:01 -0700, Jacob Skaria
wrote:

You can. Right click the sheet tabSelect all sheets and then set header and
footer which will be applied for all sheets

If this post helps click Yes
---------------
Jacob Skaria

"Brachy" wrote:

Is it possible to copy Header and Footer data across all sheets in a
multi-page Workbook.
If not, why not?
--
J. W. McLachlan