Copying individual sheets from 1 worksheet to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 31 Jul 2007 20:56 GMT

I would like to copy an entire sheet (tab) from one worksheet to
another. It seems easy at first. I merely "select" all the cells in
the source sheet (tab) in the source worksheet, copy to the clipboard
(^C), select the destination sheet (tab) in the destination worksheet,
and paste from the clipboard (^V).

This works fine except, formatting is not copied. How do I do the
copy if I want to copy the formatting, headers, footers, etc.?

Dave

Reply to this Message

Ron de Bruin - 31 Jul 2007 21:04 GMT

With both workbooks open

Right click on a sheet tab and choose "Move or copy
Select the sheet you want

Change "to book" to the destination book

And check "create a copy"

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I would like to copy an entire sheet (tab) from one worksheet to
> another. It seems easy at first. I merely "select" all the cells in
[quoted text clipped - 6 lines]
>
> Dave

Reply to this Message

Bernard Liengme - 31 Jul 2007 21:15 GMT

Use the Window command on menu bar to arrange the two workbooks side by side
Click the tab of the source worksheet (the tab is the little thing at bottom
of a worksheet)
Hold down the CTRL key and drag with the mouse (watch icon representing a
piece of paper) to the tab line in the target worksheet.

If you hold down SHIFT rather than CTRL then the worksheet is moved, not
copied
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I would like to copy an entire sheet (tab) from one worksheet to
> another. It seems easy at first. I merely "select" all the cells in
[quoted text clipped - 6 lines]
>
> Dave

Reply to this Message

Rate this thread: