header footer

P

Paul B

M&A Jack,

With the sheet that has the footer active, right-click on the sheet tab and
select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode, this will put the footer on all sheets, also
note that it change ALL page settings to the ones on the active sheet.
Margins, print gridlines,..........


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

Top