Wednesday, June 7, 2023
HomeHow toHow to copy or move an Excel worksheet in the same workbook

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

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!

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

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.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

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.

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.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

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.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

George Philip
George Philiphttps://betechwise.com
George is a tech-savvy professional and enthusiast. He writes content that gives you the insights and information you need to understand how tech is impacting your life, workplace, and world. You may contact him via his email - [email protected]

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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

- Advertisment -

Most Popular

-Advertisement-spot_img

RECENT POST