View Single Post
  #1   Report Post  
Pablano C. Pepper
 
Posts: n/a
Default How to change the footer only, on multiple worksheets in Excel?

When selecting multiple worksheets I would like to change the footer without
affecting the header. I have a inventory workbook that I update monthly. I
have the current month in the footer, but the headers are different for each
worksheet.
Currently I can only change the footers one worksheet at a time. My
workbooks contain 25+ worksheets, so changing the footers one at a time is
not fun.