How to copy or move an Excel worksheet in the same workbook

by George Philip
Published: Last Updated on 0 comment
EXCEL

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.

  1. Go to Format: Open the worksheet in question and, in the “Home” of the Excel menu, click on “Format”;
  2. Send move or copy worksheet: In the “Organize Sheets” area, click on the “Move or Copy Sheet” option;
  3. 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.

  1. Right-click on the sheet tab in question and tap on the “Move or Copy” option;
  2. 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.

Trade Gift Card With Chinese Gift Card Vendor on WhatsApp Now!!!

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:

  1. In the source workbook, open the Window menu;
  2. Click on the workbook that contains the reference sheet, then on the sheet itself;
  3. In “Edit”, go to “Sheet” and click on “Move or Copy Sheet”;
  4. In “To Workbook”, choose the destination workbook;
  5. Choose the location of the worksheet, pointing before which worksheet it should be;
  6. 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.

Trade Gift Card With Chinese Gift Card Vendor on WhatsApp Now!!!

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:

  1. Select all data in the worksheet by pressing “Ctrl + Spacebar” and then “Shift + Spacebar”;
  2. With all the data selected, click “Ctrl + C” to copy the information;
  3. Click on the “+” sign located at the end of the worksheets tab bar to create a new worksheet;
  4. 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.

Trade Gift Card With Chinese Gift Card Vendor on WhatsApp Now!!!

You may also like

Leave a Comment

* By using this form you agree with the storage and handling of your data by this website.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

betechwise logo

Copyright © 2023 Betechwise. All Rights Reserved.

Adblock Detected

Please support us by disabling your AdBlocker extension from your browsers for our website.