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?
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.