View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
click! click! is offline
external usenet poster
 
Posts: 1
Default Different headers, same footers on multiple worksheets

I have a workbook with 12 different worksheets, each with a different header.
I want the same footer on each worksheet. When I select all sheets and
apply the footer, it causes all of the headers to be changed to exactly the
same thing. Is there a way for me to put the same footer on each worksheet
without clicking each one individually, but still keeping the original
(different) headers?