How to Move or Copy Worksheets or Worksheet Data in Excel Office 365?
Tags: excelpreface, moveorcopyworksheeti
Published: 2020-08-31 12:28:01

---
title: How to Move or Copy Worksheets or Worksheet Data in Excel Office 365?
published: true
date: 2020-08-31 09:17:25 UTC
tags: ExcelPreface,MoveorCopyWorksheeti
canonical_url: https://geekexcel.com/how-to-move-or-copy-worksheets-or-worksheet-data-in-excel-office-365/
---

## Move or Copy Worksheets or Worksheet Data in Excel:

In this article, you will learn how to **Move or Copy Worksheets or Worksheet Data in Excel Office 365**. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

WindowsMacOSWeb

## Move a Worksheet within a Workbook in Windows:

- You need to select the worksheet tab, then just drag it and place wherever you want.

### Copy the worksheet in the same workbook:

- You need to **press** the **CTRL** key and drag it to the place wherever you want.
- You can also use another way to do this, that is you need to **right-click on the worksheet tab** and choose the **Move** or **Copy** option.
- It will open a **Move or Copy dialog box**.
- Then, you need to **select the Create a copy checkbox**.
- Under the **Before sheet** section, **select** any **sheet** where you want to place the copy.
- Hit the **OK** button.

![Move or Copy Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-100.png)<figcaption id="caption-attachment-13001">Move or Copy Dialog box</figcaption>

From the above steps, you can learn how to move or copy the worksheets in Excel.

## macOS:

### Move a Sheet in Excel:

- You have to **drag the sheet tab** to the location where you want to place it.

### Copy a Sheet in Excel:

- You need to hold down **OPTION**.
- Then, you have to **drag the sheet tab** to the location that you want the copied sheet to appear with the row of sheet tabs.

### Note:

- Release the mouse button before you release the **OPTION** key.

### Move a Sheet to Another Workbook:

- **Open the Workbook** which you want to move.
- Go to the **Window** menu, **click the Workbook** which contains the sheet that you want to move.
- On the **Edit** menu, click the **Sheet** option, and select **Move or Copy Sheet**.
- Next, on the **To book** menu, **click the workbook** that you want to move the sheet.
- In the **Before sheet** box, click the sheet that you want to insert the moved sheet, and **click Move to end**.
- Hit the **OK** button.

### Copy a sheet to Another Workbook:

- You have to **open the Workbook** that you want to copy.
- Go to the **Window** menu, **click the Workbook** which contains the sheet that you want to move.
- On the **Edit** menu, click the **Sheet** option, and select **Move or Copy Sheet**.
- Next, on the **To book** menu, **click the workbook** that you want to move the sheet.
- In the **Before sheet** box, click the sheet that you want to insert the moved sheet or **click Move to end**.
- Then, you have to **select the Create a copy checkbox**.
- Click the **OK** button.

### Change the Color of Sheet tab:

- You have to **hold down** the **CONTROL** key and **click the sheet tab**.
- Then, **click the Tab color** and select a color as you wish.

## Web:

### Duplicate or Copy the Worksheet to Another Workbook:

- You have to **select all data on the worksheet**.

### Note:

- To select all data, press **CTRL + Space bar**  and then press **Shift + Space bar**  Shortcut keys.

- Use **CTRL + C** keys to copy the selected item.
- **Click** the ( **+ sign** ) to add the new worksheet.
- Then, click the first cell in the worksheet, and press **CTRL + V** Keys to paste it.

### Closure:

In the above article, you can understand how to **Move or Copy the Worksheets or Worksheet Data in Excel** for **Windows** , **macOS** , and **Web**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!