If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i import header and footer from diferent XLS file?
I have header adn footer on one XLS file, but i am having hard time to copy
same header and footer from one file to e different one. can somebody help me? thank you |
#2
|
|||
|
|||
How do i import header and footer from diferent XLS file?
Beck wrote:
I have header adn footer on one XLS file, but i am having hard time to copy same header and footer from one file to e different one. can somebody help me? thank you Hi Beck, Open both files, copy one of the sheets from the file with header and footer to the other one. Select the sheet with header and footer, then holding down the Ctrl key select the sheets you want to copy header and footer to. From menu File, Page setup, select Header/Footer tab, then click Ok. Now right click on a sheet tab and select Split sheets. From Print Preview you can check that header and footer has been copied, so you can delete the sheet copied from the other workbook. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Header and Footer area have vanished (Word 2002) | Mark | General Discussion | 5 | May 10th, 2006 04:33 PM |
how to extract a page from 100page word file with footer & header | Sreek | General Discussion | 1 | February 16th, 2006 02:12 PM |
Using Forms in header and footer (or linking file properties) | LRI | Page Layout | 5 | October 14th, 2005 04:48 PM |
Same header but even/odd footer (sorry for the new thread) | B?atrice Karjalainen | Page Layout | 1 | December 16th, 2004 12:40 AM |
Headers and Footers | Specter7 | New Users | 2 | May 17th, 2004 03:51 PM |