how do i format the footer on worksheets all the same?

[sokevin]

hi,

is there a quick way i can add the same footer note (date/time/tab
name) for each of my worksheets?

 

[Frank Kabel]

Hi
select all tabs (holding down the SHIFT key just select them) for which
you want to change the footer/header. Goto 'File - Pagesetup' and
choose/define your footer

HTH
Frank

 

[Ken Wright]

Or if the first is already done, then just group them, hit File Page setup, hit
OK and out, and they will all take on the characteristics of the first.

 

[Earl Kiosterud]

That works even when you've changed some sheet other than the first -- just
drag that sheet so it's physically first. There's also Edit - Repeat page
setup.

 

[Ken Wright]

LOL

drag that sheet so it's physically first. There's also Edit - Repeat page

Cheers Earl - I'd never seen that till I tried it just now after reading your
note.

 

[sokevin]

thanks alot.

much aprreciated from this newbie :