Excel -Cannot global Header change
 

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

Excel -Cannot global Header change
 

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

"Rag742" wrote:

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

Excel -Cannot global Header change
 

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

On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote:

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

Excel -Cannot global Header change
 

On Feb 14, 1:18 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote:

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

Thank You. It works
Rag742

Excel -Cannot global Header change
 

Happy to hear you're sorted out.

Appreciate the feedback.

On 14 Feb 2007 13:25:44 -0800, "Rag742" wrote:

On Feb 14, 1:18 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On 14 Feb 2007 09:19:31 -0800, "Rag742" wrote:

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

Thank You. It works
Rag742