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

S

sokevin

hi,

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

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
 
K

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.
 
E

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.
 
K

Ken Wright

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

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