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

Darren,

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

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Darren M" wrote:

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

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

Ewan

"Darren M" wrote:

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

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.

Darren M wrote:

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

--

Dave Peterson