Thanks a lot for your help....

Natarajan

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson