Microsoft Excel

Excel Move or Copy…

If you want to move a worksheet from one workbook to another open workbook, here’s how it’s done:

  1. Open the first workbook. Then do File – Open the second workbook. Do not use Windows Explorer to open the second workbook.
  2. Right-click the worksheet tab and choose “Move or Copy…”.
  3. Click the “To book” drop-down and the name of the second workbook should be listed.  Click on the second workbook name.
  4. Where it says “Before sheet:”, click (move to end) to add another worksheet tab at the end of the other workbook.
  5. Click the “Create a copy” button to create a copy.
  6. Click OK.

    Hope that helps!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s