I have many different worksheets in one Excel file. They each have a different header, but the same footer. I need to update the footer on all sheets, without changing the headers. If I select all sheets, then modify the footer on whichever sheet is visible, it not only changes the footer on each sheet (which is what I want), but it also changes the header on every sheet to be the same as the header on the visible sheet (which I don't want). How can I modify the footers on all worksheets without affecting the headers? Thank you!!!!