Printing - Setup

[Natarajan]

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

 

[Dave Peterson]

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.

 

[Natarajan]

Thanks a lot for your help....

Natarajan

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.