Office
Sign in
Move or copy worksheets or worksheet data

Move or copy worksheets or worksheet data

You can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.

  1. Select the worksheets that you want to move or copy. If you want to move or copy more than one, press and hold the Ctrl key, and then click the tabs of the sheets you want to copy.

    Note    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  2. Select Home > Format > Move or Copy Sheet. Or, you can also right-click a selected sheet tab, and then click Move or Copy.

    Move or Copy Sheet
  3. In the Move or Copy dialog box, click the sheet that should be after the moved or copied sheet.

    Move or Copy dialog box

    Or you can click (move to end) to insert after the last sheet in the workbook.

  4. To copy the sheets instead of moving them, in the Move or Copy dialog box, select the Create a copy check box.

    When you create a copy of the worksheet, the worksheet is duplicated in the workbook, and the sheet name indicates that it is a copy — for example, the first copy that you make of Sheet1 is named Sheet1 (2).

Notes and tips

  • If you don't see the workbook that you want to copy to, see Move or copy a portion of a worksheet to another.

  • To move sheets in the current workbook, you can drag the selected sheets along the row of sheet tabs. To copy the sheets, hold down Ctrl, and then drag the sheets; release the mouse button before you release the Ctrl key.

  • To rename the moved or copied worksheet, right-click its sheet tab, click Rename, and then type the new name in the sheet tab. (Alternatively, you can double-click the sheet tab and then edit the name.)

  • To change the color of the sheet tab, right-click the sheet tab, click Tab Color, and then click the color that you want to use.

    Tab Color
  • Be aware that calculations or charts that are based on worksheet data might become inaccurate if you move the worksheet. Similarly, if a moved or copied worksheet is inserted between sheets that are referred to by a 3-D formula reference, data on that worksheet might be unexpectedly included in the calculation.

  1. To move or copy worksheets to another workbook, make sure that the target workbook is open in the same instance of Microsoft Excel.

    Note: You cannot move or copy worksheets between workbooks that are open in separate instances of Excel. If a workbook is opened in a separate instance of Excel — for example, this can happen when you open that workbook from a Windows SharePoint Services site — make sure that you open that workbook in the same instance of Excel instead by browsing to it in the Open dialog box (File tab, Open).

  2. Select the worksheets that you want to move or copy. If you want to move or copy more than one, press and hold the Ctrl key, and then click the tabs of the sheets you want to copy. If you want to select all sheets, right-click a sheet tab, and then click Select All Sheets.

    Note: When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the sheet tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  3. Select Home > Format > Move or Copy Sheet. Or, you can also right-click a selected sheet tab, and then click Move or Copy.

  4. In the Move or Copy dialog box, click the workbook to which you want to move or copy the selected sheets. Or you can click new book to move or copy the selected sheets to a new workbook.

  5. In the Before sheet list, click the sheet that should be after the moved or copied sheet. Or you can click (move to end) to insert after the last sheet in the workbook.

  6. To copy the sheets instead of moving them, in the Move or Copy dialog box, select the Create a copy check box.

    When you create a copy of the worksheet, the worksheet is duplicated in the destination workbook. When you move a worksheet, the worksheet is removed from the original workbook and appears in the destination workbook only.

Notes and tips

  • To rename the moved or copied worksheet in the destination workbook, right-click its sheet tab, click Rename, and then type the new name in the sheet tab.

  • To change the color of the sheet tab, right-click the sheet tab, click Tab Color, and then click the color that you want to use.

  • Worksheets that you move or copy to another workbook will use the theme fonts, colors, and effects that are applied to the destination workbook.

  1. In a worksheet, select the data that you want to move or copy.

    Note: If the selection includes hidden rows or columns, Excel also copies the data in those hidden rows and columns. You may have to temporarily unhide rows or columns that you do not want to include, and then select each range of data that you do want to move or copy in separate operations. For information, see Show or hide columns and rows.

  2. If you want to move the data, press CTRL + X. If you want to copy, press CTRL + C.

  3. Go to the worksheet where you want to paste the data, whether that sheet is in the same workbook or a different one.

  4. Select the upper-left cell of the area in which you want to paste the data.

    Note: Data in the paste area will be overwritten. Also, if the paste area contains hidden rows or columns, you might have to unhide the paste area to see all the copied cells.

  5. Press CTRL + V.

Notes and tips

  • Before you paste, you can also press CTRL + ALT + V (Ctrl, Option, V on the Mac), and then choose an option like Column widths to paste in the widths of the original data. Or, choose Values to paste only the values and not the formulas of the original data.

  • By default, Excel displays the Paste Options button on the worksheet to provide you with special options when you paste cells, such as Keep Source Formatting. If you do not want Excel to display this button every time that you paste cells, you can turn this option off. (On the File tab of the ribbon at the top of the workbook, click Options, click Advanced category, and then select the Show Paste Options button when content is pasted check box under Cut, Copy, and Paste).

  • When you copy cells, cell references are automatically adjusted. However, when you move cells, cell references are not adjusted, and the contents of those cells and of any cells that point to them might be displayed as reference errors. In this case, you will have to adjust the references manually.

When you need to reorganize your data, you can easily change the order of sheets in a workbook, or move or copy a sheet to another workbook. But be aware that calculations or charts that are based on sheet data may become inaccurate if you move the sheet.

Move a sheet

  • Drag the sheet tab to the location that you want along the row of sheet tabs.

Copy a sheet

  1. Hold down OPTION.

  2. Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs.

    Important: Release the mouse button before you release the OPTION key.

Move a sheet to another workbook

Caution: When you move a sheet to another workbook, check any formulas or charts that refer to data on the sheet because moving the sheet might cause errors or produce unintended results in your data. Similarly, if you move a sheet that is referred to by a 3-D references, the calculation might include or leave out data on the sheet.

  1. Open the workbook that you want to move the sheet to.

  2. On the Window menu, click the workbook that contains the sheet that you want to move.

    Click the sheet that you want to copy to the other workbook.

  3. On the Edit menu, click Sheet > Move or Copy Sheet.

  4. On the To book menu, click the workbook that you want to move the sheet to.

    Tip: To create a new workbook that contains the moved sheet, click new book.

  5. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end.

  6. Click OK.

Copy a sheet to another workbook

  1. Open the workbook that you want to copy the sheet to.

  2. On the Window menu, click the workbook that contains the sheet that you want to copy.

    Click the sheet that you want to copy.

  3. On the Edit menu, click Sheet > Move or Copy Sheet.

  4. On the To book menu, click the workbook that you want to copy the sheet to.

    Tip: To create a new workbook that contains the moved sheet, click new book.

  5. In the Before sheet box, click the sheet that you want to insert the copied sheet before, or click move to end.

  6. Select the Create a copy check box.

  7. Click OK.

Change the color of a sheet tab

Coloring the sheet tabs can help you keep track of your information in a large workbook.

  1. Hold down CONTROL and click the sheet tab.

  2. Click Tab Color, and then click the color that you want to use.

See also

Rename a sheet

In Excel Online, you can duplicate (or copy) worksheets within the current workbook. Simply right-click the tab name at the bottom of the sheet and click Duplicate.

Note: You may receive an error when you are trying to duplicate a worksheet that contains a chart, picture, or shape. If you get an error, you can duplicate the sheet manually.

If you have elements in your worksheet that interfere with duplicating it, you can still create a copy of the worksheet manually by copying all the data and pasting it into a new sheet. Here's how:

  1. Select all the data in the worksheet.

    Keyboard shortcut: Press Ctrl+Spacebar, on the keyboard, and then press Shift+Spacebar.

  2. Copy all the data on the sheet by pressing Ctrl+C.

  3. Click the plus sign to add a new blank worksheet.

    Add new sheet button

  4. Click the first cell in the new sheet and press Ctrl+V to paste the data.

    Note: You will lose any conditional formatting applied to the cells when you paste them into the new worksheet.

In Excel Online, the option to move or copy a sheet isn’t available when you right-click a sheet tab, as it is in the Excel desktop application. In Excel Online, you can achieve the same result by copying all of the data in the worksheet and pasting it into a blank worksheet in the other workbook.

Follow these steps to move or copy a worksheet to another workbook in Excel Online:

  1. Select all the data in the worksheet.

    Keyboard shortcut: Press Ctrl+Spacebar, on the keyboard, and then press Shift+Spacebar.

  2. Copy all the data on the sheet by pressing Ctrl+C.

  3. Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet. 

    Add new sheet button
  4. Click the first cell in the new worksheet, then press Ctrl+V to paste the data into that worksheet.

    Note: You will lose any conditional formatting applied to the cells when you paste them into the other workbook.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×