| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header/Footer to update on all sheets
Hi,
I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header/Footer to update on all sheets
Hi Jonno
You could group the required worksheets and then set up the Headers & Footers!! What sort of editing will you be doing to the Headers/Footers? -- Cath "Jonno" wrote: Hi, I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header/Footer to update on all sheets
Ill be adding new info into them, just words and numbers. But i need to make
sure all the rest get updated!! how do you do the grouped header and footer? -- Jonno "Cath" wrote: Hi Jonno You could group the required worksheets and then set up the Headers & Footers!! What sort of editing will you be doing to the Headers/Footers? -- Cath "Jonno" wrote: Hi, I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header/Footer to update on all sheets
To group the worksheets select the first worksheet tab then hold down the
shift key and click on the last worksheet, this will group the worksheets together. Then set up the Header and Footer as required, these will be inserted into all selected worksheets. The only way I can think of doing the update is to group the sheets and edit the Header/Footer. You could record a macro to select the text (from the cell), copy it, then group the worksheets and paste the text to the Header/Footer. Cheers Cath -- Thanks Cath "Jonno" wrote: Ill be adding new info into them, just words and numbers. But i need to make sure all the rest get updated!! how do you do the grouped header and footer? -- Jonno "Cath" wrote: Hi Jonno You could group the required worksheets and then set up the Headers & Footers!! What sort of editing will you be doing to the Headers/Footers? -- Cath "Jonno" wrote: Hi, I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header/Footer to update on all sheets
Click on the first tab and ctrl-click on subsequent tabs (or right click on any
and choose Select all sheets). Then do the page setup. Lots of these settings will be applied to all the sheets that are grouped. Be careful. Make sure you ungroup the sheets when you're done. Almost all the changes you make to a grouped sheet will affect the other sheets in that group. Rightclick on any of the grouped sheets tab and select "ungroup sheets". Jonno wrote: Ill be adding new info into them, just words and numbers. But i need to make sure all the rest get updated!! how do you do the grouped header and footer? -- Jonno "Cath" wrote: Hi Jonno You could group the required worksheets and then set up the Headers & Footers!! What sort of editing will you be doing to the Headers/Footers? -- Cath "Jonno" wrote: Hi, I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header/Footer to update on all sheets
Dont think itll work properly to how i have my worksheet set out but thank
you for trying!!! -- Jonno "Cath" wrote: To group the worksheets select the first worksheet tab then hold down the shift key and click on the last worksheet, this will group the worksheets together. Then set up the Header and Footer as required, these will be inserted into all selected worksheets. The only way I can think of doing the update is to group the sheets and edit the Header/Footer. You could record a macro to select the text (from the cell), copy it, then group the worksheets and paste the text to the Header/Footer. Cheers Cath -- Thanks Cath "Jonno" wrote: Ill be adding new info into them, just words and numbers. But i need to make sure all the rest get updated!! how do you do the grouped header and footer? -- Jonno "Cath" wrote: Hi Jonno You could group the required worksheets and then set up the Headers & Footers!! What sort of editing will you be doing to the Headers/Footers? -- Cath "Jonno" wrote: Hi, I would like all my sheets to have the same header/Footer with out having to manually input it, each time. Also the header/Footer on the first sheet will be edited therefore the header will need to automatically update all the rest of the sheets. Is this possible? -- Jonno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to apply the same header or footer to all sheets in workbook | Excel Worksheet Functions | |||
| Same Header/Footer-Different Sheets | Excel Discussion (Misc queries) | |||
| How do I update the built in header and footer pull down lists? | Excel Discussion (Misc queries) | |||
| add a header and or footer to all sheets/tabs | Excel Discussion (Misc queries) | |||
| Using same Header & Footer for Multiple Sheets in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
