Move or copy worksheets or worksheet data

You can apply the Move or Copy Sheet command to relocate or duplicate whole worksheets (also known as sheets), to other locations in the same or another workbook. You can utilise the Cut and Copy commands to relocate or replicate a section of the data to other worksheets/workbooks.

Move a worksheet within a workbook

Choose the worksheet tab, and drag it to your intended location.

Caution: When you relocate a sheet to another workbook, check any formulas or charts that specify data on that particular sheet because moving the sheet might lead to errors or create inaccurate results for your dataset. Likewise, if you move a sheet that is alluded to by 3-D references, the calculation might contain or omit data on the sheet.

Copy a worksheet in the same workbook

Press CTRL and drag the worksheet tab to the specific tab location you prefer.

OR

  1. Right-click on the worksheet tab and press Move or Copy.
  1. Choose the Create a copy checkbox.
  1. Below Before sheet, click the ideal location for placing the copy.
  1. Select OK.

Still need help?

Alternatively, you can enlist an expert in the Excel Tech Community, find support in the Answers Community, or recommend a new feature or area of improvement on Excel User Voice.

%d bloggers like this: