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

  • Thread starter Thread starter sokevin
  • Start date Start date
S

sokevin

hi,

is there a quick way i can add the same footer note (date/time/tab
name) for each of my worksheets?
:)
 
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
 
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.
 
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.
 
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. :-)
 
Back
Top