header/footer for the whole workbook
 

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

header/footer for the whole workbook
 

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).


In article . com,
Positive wrote:

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

header/footer for the whole workbook
 

On Oct 2, 9:34 am, JE McGimpsey wrote:
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).

In article . com,



Positive wrote:
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