Excel Header/Footer

  recap 13:39 30 Jan 07
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 07

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 07

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

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos