When dealing with several Excel spreadsheets, it is common that we need to order them in a way to organize our work. For this, we teach below how you can copy or move an Excel spreadsheet in the same workbook – or in a different one – either in the editor for Windows, macOS or web version. Check out!
In Excel for Windows
You can also perform this same action by performing the command directly from the tab.
- Right-click on the tab of the spreadsheet in question and tap on the “Move or Copy” option;
- In the dialog box that will open, choose the location of the sheet (pointing to which sheet it should be placed before). 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 dialogs for both methods, you can also copy or move the sheet to other workbooks. If you do, then verify that your information has been preserved, as formulas and graphs may be in error or produce incorrect data.
Also, if you have 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 spreadsheet in Excel for macOS
If you use Excel on macOS and you 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, 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 you do, however, 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 and then on the sheet itself;
- In “Edit”, go to “Spreadsheet” and click on “Move or Copy Sheet”;
- In “To Workbook”, choose the destination workbook;
- Choose the location of the sheet, pointing out which sheet it should be placed in front of;
- If you want to move the sheet to another folder, click “Ok”. If you just want to copy it, check the “Create a copy” box and click “Ok”.
How to move or copy an Excel spreadsheet 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, click with the right mouse button on the tab in question and then on “Duplicate”. Automatically an identical guide will be generated next to the reference guide, just move it later wherever you want.
For the second option, follow the steps:
- Select all the data in the spreadsheet by pressing “Ctrl + Spacebar” and then “Shift +Spacebar”;
- With all data selected, click “Ctrl + C” to copy the information;
- Click on the “+” sign located at the end of the sheet tab bar to create a new sheet;
- In the new spreadsheet, click on the first cell and press the “Ctrl + V” keys.
Since the web version of Excel doesn’t have any specific command that copy or move a sheet to another workbook, you can perform the same steps above to copy information from one sheet, just pasting it into another workbook.
With information: Support Microsoft