--Right click the sheet tabSelect all Sheets
--From menu FilePageSetupHeader/Footer tab Set the footer..

If this post helps click Yes
---------------
Jacob Skaria


"Raju" wrote:

I want to have a footer set for all the sheets in a workbook by default. So
that whenever i open excel the footer is on all the sheets.