header/footer for the whole workbook

[Positive]

Hi,

I have a workbook of more than a hundred pages. I want to add the same
header/footer for every page eg. [Tab] & Ratio analysis.

Is there a way that I could do so that I don't have to go to every
single page and customize the header?

Many thanks
Lan

 

[JE McGimpsey]

Group the sheets (select the left-most sheet, then shift-click on the
right-most sheet tab. Change the header. right-click a sheet tab and
choose Ungroup sheets (or else every subsequent change you make will be
applied to all).

 

[Positive]

Group the sheets (select the left-most sheet, then shift-click on the
right-most sheet tab. Change the header. right-click a sheet tab and
choose Ungroup sheets (or else every subsequent change you make will be
applied to all).

Hi,

I have a workbook of more than a hundred pages. I want to add the same
header/footer for every page eg. [Tab] & Ratio analysis.

Is there a way that I could do so that I don't have to go to every
single page and customize the header?

Many thanks
Lan- Hide quoted text -

- Show quoted text -

Thank you so much. It works- Lan