Printing - Setup
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
|