Printing - Setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Natarajan - 19 Oct 2007 12:41 GMT

How do I retain the print settings of one worksheet, when I copy the
worksheet to another sheet in the same file.

Reply to this Message

Dave Peterson - 19 Oct 2007 13:10 GMT

Instead of copying the cells from one worksheet to another, you could copy the
entire worksheet.

In xl2003:
Edit|move or copy sheet
specify where you want it to go and check that box on the bottom.

Or you can ctrl-click on the worksheet tab and drag a copy to the new location.

> How do I retain the print settings of one worksheet, when I copy the
> worksheet to another sheet in the same file.

Signature

Dave Peterson

Reply to this Message

Natarajan - 25 Oct 2007 11:49 GMT

Thanks a lot for your help....

Natarajan

> Instead of copying the cells from one worksheet to another, you could copy the
> entire worksheet.
[quoted text clipped - 7 lines]
> > How do I retain the print settings of one worksheet, when I copy the
> > worksheet to another sheet in the same file.

Reply to this Message