Move or Copy a Worksheet in Excel 2013

How to move or copy sheets from one position to another in MS Excel 2013?

Explanation

To move sheet:
To move sheet from one place to an other follow the steps given below.
Step 1: You can move sheet using the options given below.
Option 1:
Step 1: Select the sheet to be moved. In Home tab, select Format under Cells.
Step 2: Under Organize sheets select Move or Copy sheet...

Option 2: Right click and select Move or Copy... on the sheet to be moved.

Step 2: Move or Copy dialog box opens. In the Before sheet field, move the sheet to the position where you need and click OK.

Option 3: Use the mouse pointer and drag the sheet to the position you need.

To copy sheet:
To create a copy of the existing file, follow the steps below.
Step 1: Select the sheet for which you need to create a copy.
Step 2: Right click on the worksheet and select Move or Copy...

Step 3: In Move or Copy dialog box, enable Create a copy check box and click OK.

Copy of the existing worksheet will be created as shown in the image below.

Related Topics