Headers & footers


G

Guest

Is it possible to set the header and footer in an Excel file so it is
repeated across the worksheets contained within the file. i.e. Each workbook
contains 3 worksheets. I set the header and footer info on worksheet 1.
However I have info on Worksheets 2 and 3 and the header and footer info
doesn't copy across. I have to manually enter them. Can you help. Is there an
easy way to do this?


Regards

Darren M
 
Ad

Advertisements

G

Guest

Darren,

Try selecting all of the relevant sheets selected when you apply your
header/footer.

Regards,

Chris.
 
G

Guest

Right click on a tab of the spreadsheet, select all sheets, then enter page
setup and your header/footer.

Ewan
 
Ad

Advertisements

D

Dave Peterson

slect sheet1, then ctrl-click on sheet2's tab, then ctrl-click on sheet3's tab.

You've just grouped those worksheets (notice the [Group] in the title bar).

Now apply the header/footer to the selected sheets.

And rightclick on one of those grouped sheets and select ungroup sheets.

If you leave them grouped, then almost anything change you make to one, you'll
make to all.
 

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