ExcelBanter - How can I copy the header and footers onto every page on a workboo

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I copy the header and footers onto every page on a workboo (https://www.excelbanter.com/excel-worksheet-functions/156595-how-can-i-copy-header-footers-onto-every-page-workboo.html)

Lesley Shand

How can I copy the header and footers onto every page on a workboo

Gord Dibben

How can I copy the header and footers onto every page on a workboo

Select a sheet tab then right-click and "select all sheets".

Set up the headers and footers on the active sheet and will be done to all
sheets.

DO NOT FORGET to right-click and "ungroup sheets" when done.

Gord Dibben MS Excel MVP

On Fri, 31 Aug 2007 00:58:01 -0700, Lesley Shand <Lesley
wrote:

All times are GMT +1. The time now is 09:03 AM.