Constant footer in Excel

[ranebow]

In WORD you can change the "NORMAL" document to put the file name in the footer of EVERY Word document you create. Is there a way to customize the footer on ALL Excel sheets the same way? I want my worksheet name, date & time to appear on each workbook I create or update.

 

[pbrodsky]

Look up Templates in Excel help.

 

[SkipVought]

Hi,

Select ALL sheets

Do Page Setup.

VOLA!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[ranebow]

I've looked up templates and tried to change what it told me with no luck.

I want it to AUTOMATICALLY put the stuff on each sheet whenever I create a new one. In my old age I know I forget to do it.

 

[SkipVought]

Turn on your macro recorder and automate it!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}