header/footer for the whole workbook

  • Thread starter Thread starter Positive
  • Start date Start date
P

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
 
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).
 
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 said:
Hi,
Click to expand...
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.
Click to expand...
Is there a way that I could do so that I don't have to go to every
single page and customize the header?
Click to expand...
Many thanks
Lan- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thank you so much. It works- Lan
 
Back
Top