| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a header & footer be copied to a new file?
Any help on the aforementioned would be much appreciated! Thanks :)
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Can a header & footer be copied to a new file?
Sheet1 in Book1.xls has a header and foooter
Book2 is also open Using Windows/Arrange in XL2003 or View | Arrange All in XL2007, the two files are tiled so both can ve seen Holding down CTRL, I drag the Sheet1 tab of Book1 to the sheet tab area of Book2 If Book2 already had a Sheet1, it now has Sheet1(2) The new sheet in Book2 has the same header & footer as that in Sheet1 of Book1 But if you are goint to do this weekly, a VBA subrountine would be neater best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "A little stuck" wrote in message ... Any help on the aforementioned would be much appreciated! Thanks :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a header & footer be copied to a new file? | Setting up and Configuration of Excel | |||
| Can I copy header & Footer into new file? | Excel Discussion (Misc queries) | |||
| File name in the footer/header | Excel Discussion (Misc queries) | |||
| How to insert page numbers in a file, not the header or footer | Excel Discussion (Misc queries) | |||
| How do i import header and footer from diferent XLS file? | New Users to Excel | |||
![A little stuck[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
