Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers & footers
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers & footers
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers & footers
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers & footers
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot seem to save my reports with headers and footers. Please | Excel Discussion (Misc queries) | |||
headers and footers | Excel Discussion (Misc queries) | |||
Connect document properties to headers and footers | Excel Discussion (Misc queries) | |||
Pre-set headers and footers for new worksheets | Excel Discussion (Misc queries) | |||
Losing my headers and footers when I copy the file | Excel Discussion (Misc queries) |