WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » How to Copy Sheet in Excel?

How to Copy Sheet in Excel?

Top 5 Different Ways to Copy or Move Sheets in Excel

Below are the 5 ways of copying a sheet in Excel.

  1. By using the dragging method
  2. By using the right-click method
  3. Copy a sheet by using Excel Ribbon
  4. Copy Sheet from Another Workbook
  5. Copy Multiple Sheets in Excel

#1 Copy Sheet by Dragging Method

As per our understanding, drag & drop means to move something from one place to another. This method is very easy, and the fastest way of copying the sheet.

Below are the steps for copying a sheet by using a dragging method:

  • Step 1: Click on the sheet tab (Sheet1) that you want to copy. Refer to the below screenshot.

Copy sheet Example 1

  • Step 2: Press the CTRL key and drag the Sheet1 where you want to place it then, this will create a copy of the Sheet1 with the name of Sheet1 (2) as per the below screenshot.

Copy sheet Example 1-1

#2 Copy Sheet by Right- Click

This is also the easiest way to copying or making a duplicate sheet in excel using a mouse. Below are the steps:

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 1: Right-click on the sheet tab. It will open a drop-down list of options. Click on the Move or Copy option from the drop-down list.

Copy sheet Example 1-2

  • Step 2: This will again open the Move or Copy dialog box. Refer to the below screenshot.

Copy sheet Example 1-3

  • Step 3: Select the option under the Before Sheet section, where you want to move or copy the sheet (Sheet1). Here I want to copy the sheet at the end of the sheets hence selected the last option, which is a move to end. Tick on the box “Create a copy.” Click on OK.

Copy sheet Example 1-4

  • Step 4: It will create a copy of Sheet1 like the below screenshot.

Copy sheet Example 1-5

#3 Copy a Sheet by Using Excel Ribbon

For copying a sheet by using this method, follow the below steps:

  • Step 1: Go to the HOME tab. Click on the FORMAT option under the Cells section shown as below screenshot (denoted by a red box).

Copy sheet Example 3

  • Step 2: This will open a drop-down list of options. Click on the Move or Copy Sheet option, as shown in the below screenshot.

Copy sheet Example 3-1

  • Step 3: This will again open a Move or Copy dialog box, as shown below.

Copy sheet Example 3-2

Follow the same steps which we followed under the Copy sheet by Right–click section.

#4 Copy Excel Sheet from Another Workbook

If we have done some work on the Excel workbook and have to share some part of it or one sheet with someone. We don’t want to share the whole workbook with him due to some critical and confidential information. In that case, we can use this option of copying the sheet from our workbook into a separate workbook.

The steps are the same, which we learned in the above section.

  • Step 1: Right-click on the sheet tab which you want to copy and then choose the option Move or Copy from the drop-down list.

Example 4

  • Step 2: Again, the Move or Copy dialog box will appear as shown in the below screenshot. Click on “To Book” and select the target file.

Example 4-1

  • Step 3: To copy the sheet into a new workbook, select a new book then, Under Before sheet section, choose the destination where you want to place a copy of the sheet. Also, tick on Create a copy checkbox then, Click on OK.

Example 4-2

#5 Copy Multiple Sheets in Excel

We also can copy multiple excel sheets. Follow the below steps:

  • Step 1: For selecting adjacent sheets, click on the first sheet tab, press the SHIFT key, and click on the last sheet tab.

Example 5

  • Step 2: For alternate or non-adjacent sheets, click on the first sheet tab, press the CTRL key and click the other sheets tab one by one, which you want to copy.

Example 5-1

  • Step 3: After selecting multiple sheets, do a right-click. A dropdown list will open. Choose the Move or Copy option. Follow the same steps, as we discussed in the above section.

Things to Remember

  • When we open the Move or Copy dialog box, under the “To book” section, Excel displays only the open workbooks in the drop-down list. Hence open the destination workbook before copying the sheet.

Recommended Articles

This has been a guide on how to Copy Sheet in Excel. Here we discuss the top 5 methods to Copy Sheet, including dragging, right-click, and ribbon. We also discuss how to copy multiple sheets in excel along with practical examples and a downloadable template. You may learn more about excel from the following articles –

  • Excel Group Worksheet
  • Hiding Column in Excel
  • Division in Excel
  • Regression Analysis Excel
  • CAGR Formula in Excel
1 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More