Need help setting this up?
If you'd rather not deal with the technical side, we can fully set up and manage your Microsoft 365 for you — including email, DNS, and ongoing support.
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.
Move a worksheet within a workbook
-
Select the worksheet tab, and drag it to where you want it.
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 3-D references, the calculation might include or leave out data on the sheet.
Copy a worksheet in the same workbook
-
Press CTRL and drag the worksheet tab to the tab location you want.
OR
-
Right click on the worksheet tab and select Move or Copy.
-
Select the Create a copy checkbox.
-
Under Before sheet, select where you want to place the copy.
-
Select OK.
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.
Related Guides
- Split text into different columns with the Convert Text to Columns Wizard
- Import or export text (.txt or .csv) files
- Insert or delete cells, rows, and columns
- Collaborate on Word documents with real-time co-authoring
- OneDrive basics
Prefer us to handle this?
We provide fully managed Microsoft 365 setup and support — so you can focus on running your business.
