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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com