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

Android Oreo News: Release Date & New Features

Best Album Art 2017: Nominees & past winners of Best Art Vinyl Awards to be exhibited

iMac 21.5-inch (2017) review

Comparatif : quelle est la meilleure batterie externe 2017 ?