When dealing with several Excel spreadsheets, it is common to need to order them in order to organize our work. For that, we teach below how you can copy or move an Excel worksheet in the same workbook – or in a different one – either in the editor for Windows, macOS or the web version. Check out!
In Excel for Windows
See below how to copy or move an Excel for Windows worksheet in the same workbook.
- Go to Format: Open the worksheet in question and, in the “Home” of the Excel menu, click on “Format”;
- Send move or copy worksheet: In the “Organize Sheets” area, click on the “Move or Copy Sheet” option;
- Choose the worksheet destination: In the dialog box that will open, choose the destination folder and the location of the sheet (pointing before which sheet it should be). If you are going to move it, click “Ok”. If you are going to copy it, check the “Create a copy” box and click “Ok”. That’s it, your worksheet has already been copied or moved to another location in the same workbook.
You can also perform this same action, performing the command directly through the tab.
- Right-click on the sheet tab in question and tap on the “Move or Copy” option;
- In the dialog box that will open, choose the location of the sheet (pointing before which sheet it should be). If you are going to move it, click “Ok”. If you are going to copy it, check the “Create a copy” box and click “Ok”.
Note that in the dialog boxes of both methods it is also possible to copy or move the worksheet to other workbooks. If you do, then check that your information has been preserved, as formulas and graphs can be in error or produce incorrect data.
Also, if you have a few sheets in your workbook, you can move the desired sheet just by dragging its tab to the desired location. And, if you want to copy it, you can do the same, but keeping the “Ctrl” key pressed all the time.
How to Move or Copy a Worksheet in Excel for macOS
If you use Excel on macOS and just want to move a sheet in the same workbook, drag the sheet tab to the desired location. If you, however, want to copy the worksheet, repeat the action, but keeping the “OPTION” key pressed the whole time. For the command to work, it is very important that you press the key before dragging the guide and only release it after releasing the mouse button.
If, however, you want to copy or move the sheet to another workbook, do the following:
- In the source workbook, open the Window menu;
- Click on the workbook that contains the reference sheet, then on the sheet itself;
- In “Edit”, go to “Sheet” and click on “Move or Copy Sheet”;
- In “To Workbook”, choose the destination workbook;
- Choose the location of the worksheet, pointing before which worksheet it should be;
- If you want to move the worksheet to the other folder, click “Ok”. If you just want to copy it, check the “Create a copy” box and click “Ok”.
How to move or copy a spreadsheet in Excel via the web
If you use Excel via the web and just want to move a sheet in the same workbook, drag the sheet tab to the desired location. If you do, however, want to copy the spreadsheet, there are two ways to do this.
For the first option, right-click on the tab in question and then on “Duplicate”. Automatically, an identical guide will be generated next to the reference guide, simply by moving it to wherever you want.
For the second option, follow the steps:
- Select all data in the worksheet by pressing “Ctrl + Spacebar” and then “Shift + Spacebar”;
- With all the data selected, click “Ctrl + C” to copy the information;
- Click on the “+” sign located at the end of the worksheets tab bar to create a new worksheet;
- In the new worksheet, click on the first cell and press the “Ctrl + V” keys.
As the web version of Excel does not have any specific command to copy or move a worksheet to another workbook, you can perform the same steps as above to copy information from a worksheet, just pasting it into another workbook.