Your Search for Microsoft Excel tips and Tricks ends here.

Ad

Copying a Worksheet into another Workbook

How to make a copy of a Worksheet from the current Workbook to another Workbook?

  1. Open the Target Workbook, when the Source Workbook is already in open state.
  2. Right-Click on the Source-Worksheet Tab.
  3. Select the Move or Copy... option from displayed shortcut menu.
  4. Select the Target Workbook name from the To Book: drop-down list.

  5. Put a check-mark in the Create a Copy option and click OK.

There you are, you have a clone of the source worksheet on your Target Workbook.

Instead, if you want to move a worksheet to the target Workbook, select (Move to End) option.

Share:

Trending

Popular Posts

Search This Blog

Blog Archive

Powered by Blogger.

Featured Post

Copying a Worksheet into another Workbook

How to make a copy of a Worksheet from the current Workbook to another Workbook? Open the Target Workbook, when the Source Workbook is alr...

Recent Posts