Ms Excel Headers

  Durko 11:32 14 Feb 2005

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

Dell XPS 13 9370 (2018) review

Best Keyboards for Designers & Artists

What to ask Siri on the HomePod

Meilleurs VPN (2018)