G Guest Oct 19, 2007 #1 How do I retain the print settings of one worksheet, when I copy the worksheet to another sheet in the same file.
How do I retain the print settings of one worksheet, when I copy the worksheet to another sheet in the same file.
D Dave Peterson Oct 19, 2007 #2 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.
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.
G Guest Oct 25, 2007 #3 Thanks a lot for your help.... Natarajan Dave Peterson said: 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. Click to expand...
Thanks a lot for your help.... Natarajan Dave Peterson said: 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. Click to expand...
