I don't see how you can change the usual blank workbook created by File-New.
However you could use 'New from template' on the task pane. You would have to
create template (really just an ordinary XLS) with the header/footer set &
save as an XLT. When you save as an XLT it should save the file to your
custom templates directory.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.