Right-click a worksheet tab and choose "Select All Sheets", then set
your footer. Right click any worksheet tab and choose "Ungroup Sheets"
(or else any further changes will likewise affect all sheets).




In article ,
"Hans" wrote:

How do I put footers and dates on all Excel worksheets in just one go?
Have several XLS files that have 10's of worksheets.