Excel -Cannot global Header change

R

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
 
J

Joel

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

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
 
R

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
Click to expand...

Thank You. It works
Rag742
 
Top