How to Copy Excel Sheet to Another Sheet (5 Ways)

You may want to create copies of your worksheet for different reasons such as you may want to keep a backup or you may want to do different calculations on the same dataset. In this article, I’ll describe 5 easy ways to copy an Excel sheet to another sheet.

Consider the following sheet named Book List. We will copy this sheet to a new sheet.

Copy sheet Dataset

Download Excel Workbook

5 Ways to Copy Excel Sheet to Another Sheet

1. Copy a Sheet by Right Clicking

We can easily copy a sheet by right-clicking. Right click on the sheet name > Select Move or Copy.

Copy sheet to another sheet

A Move or Copy will appear. Select the sheet before which you want to copy your sheet. Check the box Create a Copy.

Copy sheet to another sheet

After pressing OK your sheet will be copied before the sheet you selected.

Copy sheet to another sheet

Read more: How to Copy a Sheet in Excel

2. Manually Copy to a New Sheet

You can also manually copy your sheet to a new sheet. Select the first cell to your sheet. To select all the occupied files press CTRL+SHIFT+END

Copy sheet to another sheet

Copy all the cells by pressing CTRL+C

Copy sheet to another sheet

Open a new worksheet in your workbook. Select the first cell. Press CTRL+V.  Your sheet will be copied.

Copy sheet to another sheet

3. Copy Excel Sheet by Dragging

The easiest way to copy your sheet is Dragging. Simply click on the sheet which you want to copy, press CTRL and drag the sheet to where you want to copy.

Copy sheet to another sheet

After that, you will get your copied sheet.

copy sheet by dragging


Similar Readings:


4. Copy a Sheet using the Ribbon

Another way to copy a sheet is using the ribbon. Open the sheet you want to copy. Go to Home > Cells > Format > Move or Copy Sheet

Make Duplicate sheet

A Move or Copy will appear. Select the sheet before which you want to copy your sheet. Check the box Create a Copy.

Make Duplicate sheet

After pressing OK your sheet will be copied before the sheet you selected.

Make Duplicate sheet

5. Copy Sheet from another Workbook

You can also copy sheets from one workbook to another. Suppose you want to copy this book list sheet to another workbook named “ another sheet”. First, you need to open the two workbooks at the same time.

Copy sheet from another workbook

Then, you need to open the Move or Copy box in your first workbook by right-clicking on the sheet name. After opening the Move or Copy box select another sheet in the To workbook box.

Copy sheet from another workbook

Select the sheet before which you want to copy your sheet. Check the  Create a copy box. Press OK.

Copy sheet from another workbook

After that, your sheet will be copied in the “another sheet” workbook.

Copy sheet from another workbook

You can also copy a sheet from another workbook by dragging or using ribbon which are stated above.

Conclusion

By applying any of the five methods you will be able to copy a sheet to a new sheet. Hope you find this article helpful. Feel free to leave a comment if you have any confusion.


Further Readings

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo