Ms Excel Headers

  Durko 11:32 14 Feb 2005
Locked

Can anyone advise/explain if there is a simple procedure for creating an initial header in excel that will also show in each other worksheet within a single workbook without having to set one up each time?

Any advice greatly appreciated.

  Rand Al Thor 12:04 14 Feb 2005

Create a template. Have a look at the help file for templates.

  exdragon 12:06 14 Feb 2005

If you click the first sheet tab, hold down the shift key, then click the last sheet in the workbook, they will all be selected. Then you can go to View/header and footer to create what you want. Then deselect the sheets by holding down the shift key and clicking the highlighted tab.

Is that what you mean? Apologies if it's not!

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

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?