| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header or Footer to Multiple Worksheets Simultaneously
How do I do this?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header or Footer to Multiple Worksheets Simultaneously
Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer and put the information you want. HTH John "khuff" wrote in message ... How do I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header or Footer to Multiple Worksheets Simultaneously
Just a note of caution.
This will also change all other print settings to same as active sheet. With the exception of print area and rows to repeat at top. Gord Dibben MS Excel MVP On Thu, 29 Jan 2009 16:56:02 -0500, "John" wrote: Hi Khuff PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer and put the information you want. HTH John "khuff" wrote in message ... How do I do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header or Footer to Multiple Worksheets Simultaneously
Works like a champ!
Thanks John! "John" wrote: Hi Khuff PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer and put the information you want. HTH John "khuff" wrote in message ... How do I do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header or Footer to Multiple Worksheets Simultaneously
Good addition to the above, Thanks Gord
"Gord Dibben" wrote: Just a note of caution. This will also change all other print settings to same as active sheet. With the exception of print area and rows to repeat at top. Gord Dibben MS Excel MVP On Thu, 29 Jan 2009 16:56:02 -0500, "John" wrote: Hi Khuff PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer and put the information you want. HTH John "khuff" wrote in message ... How do I do this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header or Footer to Multiple Worksheets Simultaneously
You're welcome
John "khuff" wrote in message ... Works like a champ! Thanks John! "John" wrote: Hi Khuff PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer and put the information you want. HTH John "khuff" wrote in message ... How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a header and footer to multiple worksheets? | Setting up and Configuration of Excel | |||
| Format multiple Worksheets Simultaneously | Excel Discussion (Misc queries) | |||
| Add a Row to Multiple Worksheets Simultaneously | Excel Worksheet Functions | |||
| Updating Multiple Worksheets Simultaneously | Excel Discussion (Misc queries) | |||
| How to insert same header/footer across multiple worksheets? | Excel Worksheet Functions | |||
Linear Mode
