View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donna Donna is offline
external usenet poster
 
Posts: 180
Default can you set up global headers & footers for all sheets in a file?

I have a file that has several worksheets... I want the same header & footer
in all... and then I want to be able to change it globally... for instance,
the header might say "Preliminary Draft", and then when it becomes final, I
want to change it to "Final" without having to go into each worksheet. Is
this possible?