Headers and Footers - How to copy?


The Hun

Using Excel 2002

When doing a copy/paste of a worksheet into another Excel file, or
into another tab within an Excel file, how do we make the header and
footer stay with the worksheet so that it appears after the worksheet
has been pasted?





Instead of copy and pasting the whole worksheet into a new file, try right
clicking on the tab name and selecting "Move or Copy". when the window opens
pick the name of the file you want the worksheet to go to in the first drop
down box, tell it in what order you want it to appear in the new worksheet
and finally check the Make a COPY box at the bottom. If you forget the last
part, it'll move the original worksheet instead of making a copy of it.

Hope this helps.

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