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?




What version of Excel are you using?

The way you've described performing the operation should work. I do it all
the time in Excel 2000, 2002 and 2003. Another way to choose all of the
sheets at once is to select the one at one "end" of the group and then go to
the other end of the group and [Shift]+click it and those two sheets and all
between should be chosen and you should be able to make global header/footer
changes to them.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question