Duplicating Work sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JERRY - 26 Jun 2007 00:00 GMT

I have become somewhat familiar with Excel over a period of time, but I
often have difficulty in duplicating work sheets .... exactly. I have
created a sheet where I have adjusted the height of certain rows, widths,
etc. It seems however, when I copy and paste and then paste special asking
that column widths be maintained I still do not get an exact duplicate. When
I do a print preview of the original work sheet it all fits on one page. A
print preview of the copy, I get some bleed over of the worksheet to the 2nd
page.

Could someone please help me with this?

Thank you for any assistance
Jerry

Reply to this Message

Pete_UK - 26 Jun 2007 00:02 GMT

I find the easiest way to duplicate a sheet is CTRL-drag - hold the
CTRL key down and just drag the sheet tab with the mouse left button.
A small black arrow appears, to indicate where the copy of the sheet
will go when you release the mouse button. An alternative is to right-
click the sheet tab and then select Move or Copy sheet and follow it
through.

Hope this helps.

Pete

> I have become somewhat familiar with Excel over a period of time, but I
> often have difficulty in duplicating work sheets .... exactly. I have
[quoted text clipped - 9 lines]
> Thank you for any assistance
> Jerry

Reply to this Message

Stan Brown - 26 Jun 2007 11:17 GMT

Mon, 25 Jun 2007 18:53:19 -0500 from JERRY <jerry@home>:

> I have become somewhat familiar with Excel over a period of time, but I
> often have difficulty in duplicating work sheets .... exactly. I have
[quoted text clipped - 4 lines]
> print preview of the copy, I get some bleed over of the worksheet to the 2nd
> page.

Why not try Edit ... Move or Copy Sheet?

In the dialog box, be sure to check "create a copy".

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message

JERRY - 26 Jun 2007 16:28 GMT

Thanks guys
I love this forum. Generally quick, and, almost always what the Dr ordered.

Thanks again
Jerry

> Mon, 25 Jun 2007 18:53:19 -0500 from JERRY <jerry@home>:
>> I have become somewhat familiar with Excel over a period of time, but I
[quoted text clipped - 13 lines]
>
> In the dialog box, be sure to check "create a copy".

Reply to this Message