I have a workbook that contains many, many tabs. I am trying to format all of
my headers/footers and margins at once, rather than go to each individual
tab, go to my set-up and make revisions there. When making changes to my
worksheet I can group my tabs, make a change, save, then ungroup and
everything has changed - it does not work like that for my headers and
footers. Any ideas? I really appreciate it and Happy New Year to you!!

Select all tabs first by clicking on the first one, then hold the shift down
and click on the last one, then change headers and footers

"Kim" wrote:

I have a workbook that contains many, many tabs. I am trying to format all of
my headers/footers and margins at once, rather than go to each individual
tab, go to my set-up and make revisions there. When making changes to my
worksheet I can group my tabs, make a change, save, then ungroup and
everything has changed - it does not work like that for my headers and
footers. Any ideas? I really appreciate it and Happy New Year to you!!

I know how to group tabs but its just not working for some reason. I'll try
again.

"dlw" wrote:

Select all tabs first by clicking on the first one, then hold the shift down
and click on the last one, then change headers and footers

"Kim" wrote:

I have a workbook that contains many, many tabs. I am trying to format all of
my headers/footers and margins at once, rather than go to each individual
tab, go to my set-up and make revisions there. When making changes to my
worksheet I can group my tabs, make a change, save, then ungroup and
everything has changed - it does not work like that for my headers and
footers. Any ideas? I really appreciate it and Happy New Year to you!!

Keep trying.

Header changes on the active sheet will be replicated on all sheets in the
group.

There are a couple of print setttings that cannot be done on grouped sheets.

Print Range and rows to repeat at top are not available.


Gord Dibben MS Excel MVP


On Fri, 29 Dec 2006 12:45:01 -0800, Kim wrote:

I know how to group tabs but its just not working for some reason. I'll try
again.

"dlw" wrote:

Select all tabs first by clicking on the first one, then hold the shift down
and click on the last one, then change headers and footers

"Kim" wrote:

I have a workbook that contains many, many tabs. I am trying to format all of
my headers/footers and margins at once, rather than go to each individual
tab, go to my set-up and make revisions there. When making changes to my
worksheet I can group my tabs, make a change, save, then ungroup and
everything has changed - it does not work like that for my headers and
footers. Any ideas? I really appreciate it and Happy New Year to you!!