Thread: How do I make a single header/footer common across all worksheets?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
  
Posts: 476
Default How do I make a single header/footer common across all worksheets?
I have 15 worksheets in a file, and each needs the same header & footer. I
have tried control-clicking to highlight each tab & then "Page Setup" to
change the header/footer, but only get the first worksheet clicked to 'take'
the header/footer. Is there some way to do a mass change to avoid tediously
clicking into & copy-pasting the information into individual worksheets?
Reply With QuoteReply With Quote