Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Headers and Footers - How to copy?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
The Hun - 13 Mar 2008 14:04 GMT
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?

Thanks,
Red - 14 Mar 2008 00:00 GMT
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.
Signature

Just a fellow Excel user here to help when I can.....

> Using Excel 2002
>
[quoted text clipped - 4 lines]
>
> Thanks,

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.