Copy headers and footers to other pages?

P

Pete_UK

Select the sheet where the header/footer is set up. You can group
sheets together by holding the CTRL key down and clicking on the sheet
tab. When you have your group, release the CTRL key, and now anything
that you do in one sheet will also be done in the other sheets. Click
on File | Page Setup | Header/Footer tab and then click Custom Header
as if you were going to edit it. Do the same for Custom Footer, then
come out of that and ungroup the sheets by clicking on another sheet
tab (or right click a sheet tab and Ungroup sheets). You should now
find that each of the sheets that you had grouped have the same header
and footer.

Hope this helps.

Pete
 

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