View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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