Complete Excel noob here -

If I've defined a custom view in one workbook, how can I apply it to
another. It is not shown in the list.

What I want to do:

I have a workbook with columnar data similar to a check register. I have set
up the formatting for display and print formatting, including headers &
footers. This data is for a specific client but I want to save that
formatting, both visual and print so that I can create new workbooks for
other clients and apply the same formatting. I thought that by saving the
custom view it would work but it is not seen outside of the workbook in
which I created  it.

It's probably obvious but I just can't see the solution.

I was reading up on Styles & Templates but that doesn't seem to include the
print formatting or have I misread the help?

Thanx,

Vic Baron