Custom Footer To All Tabs/Worksheets

[Kolin]

Hey guys,

I have a fairly simple (i think) request. Basically, I have a bunch of tabs that I want to print out all with the same custom footer (Date on left, File path in middle, Tab on right).

Is there any way to apply that custom footer to ALL tabs instead of having to do page setup and change the footer every tab I have?

Thanks!

[shg]

To do all, click the first tab, and Shift+click the last tab

To do some, select the first and Ctrl+click the other tabs of interest

Then do page setup.

[Kolin]

Thank you very much, works perfectly, knew it would be staring me in the face :P