Hi daidipya,

put &[tab] in to your footer will display the sheet name
&[file] will display the book name.

If you want this to be in every file you use, then open a blank
worksheet set up your custom footer and save it as a template
file called book1. Put it in the xlstart folder.

HTH
Martin