S Sylvie Mar 3, 2004 #1 when copying from one worksheet to another, why doesn't the formatte printing area copy with it? How can I do that
when copying from one worksheet to another, why doesn't the formatte printing area copy with it? How can I do that
D Dave Peterson Mar 4, 2004 #2 If you're copying a range from one sheet to another, I think excel does a good job in not matching the print range. But if you're creating a new sheet based on an existing sheet, I think you'll find it easier to copy the whole worksheet. Edit|Move or copy sheet|check copy! and copy it where you want it. (You can also control-click on the worksheet tab and drag it where you want it copied.)
If you're copying a range from one sheet to another, I think excel does a good job in not matching the print range. But if you're creating a new sheet based on an existing sheet, I think you'll find it easier to copy the whole worksheet. Edit|Move or copy sheet|check copy! and copy it where you want it. (You can also control-click on the worksheet tab and drag it where you want it copied.)
