headers and footers

G

Guest

Is it possible to update the headers and footers of a number of different
excel files at the same time? I have over 100 files all with the same Headers
and Footers, which need to be up-dated from time to time. It would save a
great deal of work if they could all be changed in a batch.
 
G

Guest

hold control key and select all the sheets that you want to have the same
header and footer then go to view-->header & footer and change the header and
footer.

Nikki
 
D

Dave O

The automated solution requires some coding- not inordinately
difficult, but some attention to detail to make it do what you need.
For instance, what is it in the headers and footers that needs to
change? Do you need only to add text, or is it page numbers and tab
names?
 

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

Similar Threads

Headers and Footers size 2
Headers & Footers _auto update info from a cell in the worksheet 4
Help with Headers and Footers 1
Protecting Headers and Footers!! 2
headers footers 3
Headers and Footers 3
How can I change the predefined headers and footers in Excel? 2
Headers & Footers in Excel 1

Top