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