| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Header to all tabs / pages
Laura
If I already had the header/footer set on one worksheet, in pre xl2007 (it may work on 2007 I just don't speak 07 yet) I would "Group" all sheets with the one with the header/footer as the ative one. I would goto viewheader and footerI would select "ok" and let xl do the rest. It will copy the header/footer to all worksheets. As Sheleoo said you can also modify, or build from scratch, the header/footer at this time and it will hit all worksheets. Mike Rogers "Laura" wrote: Is there a way to copy a header into all worksheets in a file automatically |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get all the tabs and pages of the worksheets to appear? | Excel Worksheet Functions | |||
| Use rows 1-3 for header on all 13 pages | Excel Discussion (Misc queries) | |||
| Header not showing on all pages | Excel Discussion (Misc queries) | |||
| Tabs v.Pages | Excel Worksheet Functions | |||
| How do i number pages in a header consequently | Excel Worksheet Functions | |||
![Mike Rogers[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
