View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jen_writer jen_writer is offline
external usenet poster
 
Posts: 16
Default copy footer without copying page setup

Hello,
I have a workbook with many worksheets. The worksheets have different page
layouts/setups. However, I need the same footer on all sheets. When I "select
all sheets" and add a footer, the page setup copies throughout also. Is there
a way to copy the footer without changing the page setup and without having
to open every single footer to copy/paste?

thanks
Jen