EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Copy Excel Sheet
 

Copy Excel Sheet

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 19, 2023

Copy Excel Sheet

 

 

Copy Sheet in Excel

There are 2 ways to copy any worksheet. The first way, click right on any Sheet name tab name and then select the Move Or Copy option from the right-click menu list. Then from the Move Or Copy box, check the box of Create A Copy with a tick and press OK to proceed with creating a copy of that sheet. In a second way, select the sheet we want to copy, then process Ctrl and drag that sheet on the Plus sign beside the sheet name. This will create a copy of the selected sheet keeping the word COPY in the brackets. In this article, we will learn about Copy Excel Sheet.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

There are multiple ways where we can do this task.

  • Move sheet within the same workbook: This will move the worksheet to the end or the start in the same workbook.
  • Copy Sheet within the same workbook: This will create a carbon copy of the same worksheet.
  • Move Sheet to Another Workbook: This will move the worksheet from one workbook to another workbook. It will move the sheet to a new workbook but will disappear from the existing worksheet if you move it.
  • Copy Sheet To Another Workbook: This will copy the worksheet from one workbook to another workbook with a copy of the existing worksheet.

How to Copy an Excel Sheet?

Copy Excel Sheet is very simple and easy to use. Let’s understand the working of copying Excel sheets using different methods.

You can download this Copy Excel Sheet Template here – Copy Excel Sheet Template

Method #1 – Move the Sheet within the Same Workbook

You can apply this method if you want to move the active sheet to the end of the worksheet. For example, look at the below image. I have a total of 3 worksheets.

Copy Excel Sheet Method 1

Right now, Sheet 1 is at the beginning of all the worksheets. So I want to move this sheet to the end of the works sheet.

  • Right-click on Sheet 1 and select Move or Copy

The shortcut key to open Move or Copy is Alt + E + M.

Copy Excel Sheet Method 1-1

  • Once you click on Move or Copy, it will show you a new window. In the new window, select (move to end).

Copy Excel Sheet Method 1-2

  • This will move this sheet to the end.

Copy Excel Sheet Method 1-3

Method #2 – Copy Sheet within the Same Workbook

We can apply this method if you want to create a copy or a replica of the existing worksheet in the same workbook.

I will take the same workbook here as well. I want to create a replica of Sheet 1.

  • Right-click on Sheet 1 and select Move or Copy.

Copy Excel Sheet Method 2-1

  • Once you click on Move or Copy, it will show you the new window. In the new window, select Sheet 1 & check the box, create a copy, and click on OK.

Copy Excel Sheet Method 2-2

  • It will create a copy of the worksheet for you. The new sheet will be the same as the existing worksheet with (2) in front of it.

Copy Excel Sheet Method 2-3

Method #3 – Move the Sheet to Another Workbook

You can apply this method if you want to move the entire worksheet to a new workbook. For this, we need a minimum of two workbooks to be opened. My two workbook names are Worksheet 1 and Worksheet 2.

I have opened both worksheets at this point. In the workbook Worksheet 2, I have a sheet name called Data Sheet, and I want to move this worksheet to another workbook called Worksheet 1.

  • Right-click on the sheet you want to move and select Move or Copy.

Move Sheet to Another workbook

  • Once you select this option, it will show you the new window.

Choose Destination

  • In this window, there is a drop-down called To book. Click on this drop-down. It will show you all the opened workbooks; select which workbook you want to move. I have selected the workbook called Worksheet 1. I am not going to create a copy of the worksheet, but I am just moving it to another workbook.

Choose Destination

  • Once you select the new workbook name, it will show you that workbook’s worksheets. Select the option of (move to end). Click on OK to complete the process.

Move Copy

  • It also deletes the sheet in the workbook called Worksheet 2.

Copy Excel Sheet Method 3-5

Method #4 – Copy the Sheet to Another Workbook

You can apply this method if you want to copy the entire worksheet to a new workbook.

  • Right-click on the sheet you want to move and select Move or Copy. Here I have selected the sheet called Data Sheet in the workbook called Worksheet 2.

 Copy Sheet to Another workbook

  • Once you select this option, it will show you the new window.

Copy Excel Sheet Method 4-2

  • There is a drop-down called To book in this window: Click on this drop-down to show you all the opened workbooks and select the workbook you want to move. I have selected the workbook called Worksheet 1. Here I am selecting the option Create a copy. Once you select the new workbook name, it will show you that workbook’s worksheets. Select the option of (move to end). Click on OK.

Create a Copy

  • It will create a copy of this worksheet in another workbook.

Copy Excel Sheet Method 4-4

Things to Remember About Copy Excel Sheet

  • Based on the requirement, we can choose whether to move or copy the Excel sheet.
  • The shortcut key to open the Move or Copy sheet is ALT + E + M.
  • We need to select the required workbook name To book: drop-down list.
  • If you want to move the sheet to the end, we need to choose the option (move to end).

Recommended Articles

This has been a guide to Copy Excel Sheet. Here we discuss how to copy Excel sheets using different methods, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel Data Formatting
  2. Scrollbar in Excel
  3. Excel Absolute Reference
  4. HYPERLINK in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Copy Excel Sheet Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Copy Excel Sheet Template

EDUCBA

डाउनलोड Copy Excel Sheet Template

🚀 Limited Time Offer! - ENROLL NOW