Excel Header/Footer

  recap 13:39 30 Jan 2007
Locked

I have a workbook with 16 sheets and want to insert a Header and Footer that will read the same on all sheets.

Is there a way of doing this, across the whole workbook, in one go instead of each individual sheet?

  Flying Teddy 14:07 30 Jan 2007

Right click one of the sheet tabs at the bottom of the page and then select 'select all sheets'. Then create your header/footer and it will appear on all sheets.

  recap 14:13 30 Jan 2007

Thanks Flying Teddy, it had to be something easy, lol

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?