How do I set a default header and footer that can be applied to any sheet with a tool bar button?
To set your default Header and Footer: First create the header and footer you want to use with the a sheet you select. Once that is ready, use the Options command and then selecting Set Header / Footer tab. This will allow you to ‘set’ the default header and footer using the current sheet as the model.