Excel -Cannot global Header change

[Rag742]

My excel workgroup consists of 15 work sheet. I cannot make changes in
the header globally. I have to go to individual work sheet and make
the change. What can I do to correct thsi setup. Thanks.
Rag742

 

[Guest]

the only way I know how to do this would be to write a macro. Youcan access
the headers and footers with macros.

 

[Gord Dibben]

Is a "workgroup" a single workbook?

Are the 15 worksheets in that single workbook?

If so, select a sheet then right-click on the sheet tab and "select all
sheets".

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

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


Gord Dibben MS Excel MVP

 

[Rag742]

Is a "workgroup" a single workbook?

Are the 15 worksheets in that single workbook?

If so, select a sheet then right-click on the sheet tab and "select all
sheets".

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

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

Gord Dibben MS Excel MVP

Thank You. It works
Rag742

 

[Gord Dibben]

Happy to hear you're sorted out.

Appreciate the feedback.