How do i import header and footer from diferent XLS file?

G

Guest

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
 
F

Franz Verga

Beck said:
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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No More New Fonts May Be Applied To This Work Book 2
Headers and Footers - How to copy? 1
New Header/Footer Quick Part? 6
Formatting question 3
word 2003 - How do I make the first page header a different size from the other pages? 0
manually set headers adn footers 1
Problems with Headers/Footers 1
Header footer question 2

Top