Header, Footer, Column Width, Margins
I just recently started a new job and I'm using an existing Workbook. This workbook has multiple pages and I need to add a header, footer, change margins and reset columns. Can anyone tell me how to apply this to the entire workbook so i don't spend hours changing each page? The previous user was linking to Word and printing there but it can be done from Excel if I can get these changes made. thanks for any help. -- Toysforfids ------------------------------------------------------------------------ Toysforfids's Profile: http://www.excelforum.com/member.php...o&userid=37655 View this thread: http://www.excelforum.com/showthread...hreadid=572633 |
Header, Footer, Column Width, Margins
If by "pages" you mean worksheets, you can group the sheets and do them all at
once. Select a sheet. Right-click on the sheet tab and "select all sheets". Do your page setup on the active sheet and will be done to all sheets. DO NOT FORGET to ungroup the sheets when setup is complete. Either right-click and "ungroup" or select any sheet but the active sheet. Gord Dibben MS Excel MVP On Thu, 17 Aug 2006 10:03:32 -0400, Toysforfids wrote: I just recently started a new job and I'm using an existing Workbook. This workbook has multiple pages and I need to add a header, footer, change margins and reset columns. Can anyone tell me how to apply this to the entire workbook so i don't spend hours changing each page? The previous user was linking to Word and printing there but it can be done from Excel if I can get these changes made. thanks for any help. |
Header, Footer, Column Width, Margins
Thank you for the help. This workbook is a monster. -- Toysforfids ------------------------------------------------------------------------ Toysforfids's Profile: http://www.excelforum.com/member.php...o&userid=37655 View this thread: http://www.excelforum.com/showthread...hreadid=572633 |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com