| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
header/footer for the whole workbook
Hi,
I have a workbook of more than a hundred pages. I want to add the same header/footer for every page eg. [Tab] & Ratio analysis. Is there a way that I could do so that I don't have to go to every single page and customize the header? Many thanks Lan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
header/footer for the whole workbook
Group the sheets (select the left-most sheet, then shift-click on the
right-most sheet tab. Change the header. right-click a sheet tab and choose Ungroup sheets (or else every subsequent change you make will be applied to all). In article . com, Positive wrote: Hi, I have a workbook of more than a hundred pages. I want to add the same header/footer for every page eg. [Tab] & Ratio analysis. Is there a way that I could do so that I don't have to go to every single page and customize the header? Many thanks Lan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
header/footer for the whole workbook
On Oct 2, 9:34 am, JE McGimpsey wrote:
Group the sheets (select the left-most sheet, then shift-click on the right-most sheet tab. Change the header. right-click a sheet tab and choose Ungroup sheets (or else every subsequent change you make will be applied to all). In article . com, Positive wrote: Hi, I have a workbook of more than a hundred pages. I want to add the same header/footer for every page eg. [Tab] & Ratio analysis. Is there a way that I could do so that I don't have to go to every single page and customize the header? Many thanks Lan- Hide quoted text - - Show quoted text - Thank you so much. It works- Lan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up single Header/Footer for all tabs in Excel Workbook. | Excel Worksheet Functions | |||
| Inserting the same header/footer on all worksheets in a workbook | Excel Discussion (Misc queries) | |||
| how to apply the same header or footer to all sheets in workbook | Excel Worksheet Functions | |||
| Can you put the same header/footer on the entire workbook? | Excel Worksheet Functions | |||
| How to save a custom header/footer on ea. sheet of a workbook? | Excel Worksheet Functions | |||
Linear Mode
